Import & Export moves your products, categories and customers in and out of the shop as files. Import adds many products at once from one CSV file.
Use it to load a catalog you already keep in a spreadsheet, or to keep a copy of your data.
Before you start
- Import & Export is part of your plan. If your plan does not include it, the page shows an upgrade card instead.
Step 1. Open Import & Export
In the side menu, under Management, select Import & Export. Each data set has its own card: Products, Categories and Customers, with the number of records on each.
Step 2. Export
On the Products card, choose All, Published only or Drafts only. Press Export, then Download CSV or Download Excel. The other cards export the same way.
Step 3. Get the sample file
On the Products card, press Sample CSV beside the import button for your kind of product, Physical products or Digital products. Fill one row per product and keep the header row as it is.
Step 4. Check the file
Press Import Physical products or Import Digital products. Choose your file and press Check the file. The line in the window says CSV only, up to 5 MB and 2,000 rows. Nothing is saved yet.
Step 5. Read what will happen
Three tabs show the result:
- Will be created: each new product, marked Ready to publish, or Needs: with what it still lacks.
- Duplicates: rows that match a product you already have, with what they Matched on. They are skipped.
- Errors: the Row, the Column and the Reason. Fix them in your file and press Choose another file.
Products with variants arrive without them. Add the variants in the product form later.
Step 6. Import
Press Import with the number of rows. The message tells you how many were imported, how many were skipped as duplicates and how many had errors.
If you see Another import is already running for your shop., wait for it to finish and try again.
Step 7. Check the history and your drafts
Import history lists every import with its Date, Who, File, Created, Skipped, Errors and a Report. Every imported product arrives in Drafts. Open each one, check it and publish it.
Result
Your products are in Drafts, ready to check and publish, and you have a file of your data whenever you need one.