Product Importer
- 29 Mar 2023
- 2 Minutes to read
- Print
- DarkLight
- PDF
Product Importer
- Updated on 29 Mar 2023
- 2 Minutes to read
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
If you want to update existing products, use the Product Exporter to export them with their details and settings. The Advanced sheet format is the best for exporting and importing to edit products as it contains the most information and settings for your products. Edit the details and use the product importer to upload them. **The Product Importer will wipe any product information left blank in the excel sheet on existing products.**
The Product Importer tool will allow you to import multiple products into your admin panel. The import tools can also be used with the Product Exporter to make mass updates to existing product details.
Importing Products
If you want to update existing products, use the Product Exporter to export them with their details and settings. The Advanced sheet format is the best for exporting and importing to edit products as it contains the most information and settings for your products.
The importer tool will review products based on SKU and either create a new product if the SKU does not exist or update the existing product that matches the SKU.
1. Go to Settings > Import/Export > Product Importer in the Admin Panel.
2. If you are importing products for the first time and do not yet have an excel sheet filled out in one of the two required import formats, select either Download Regular Sample File or Download Advanced Sample File.
If you want to update existing products, use the Product Exporter to export them with their details and settings. The Advanced sheet format is the best for exporting and importing to edit products as it contains the most information and settings for your products.
3. Complete the sample sheet following the formatting guidance found in the Regular vs. Advanced Sheet Formats Documentation. When complete, ensure your file is saved to s spot you can easily find on your computer and completely close the sheet (not just minimized).
If you fill out the sample sheet or edit a product export sheet to update existing products, be aware that all fields overwrite the existing content or setting on the product. It is best to use the Product Exporter (Advanced Format) when updating products to avoid wiping out settings on an existing product.
4. Click Browse to locate the import sheet you have saved on your computer.
5. Select the Format that the sheet uses. See the Regular vs. Advanced Sheet Formats Documentation for more details on the differences.
6. Click Import.
A progress bar will let you know the status of your import.
Was this article helpful?
