How to import products in bulk
To import products in bulk, go to Settings → Import / Export and choose Import Data. Pick Products, upload your CSV or Excel (.xlsx) file (the first row must be column headers), map each file column to a field, preview the changes, and run the import.
Before you begin
Prepare a CSV or Excel (.xlsx) file of your products, with column headers in the first row (the importer reads the headers to map your data). You'll need permission to manage products / import data.
How to import products
In the Merchant Hub, go to Settings → Import / Export and choose Import Data.
Choose what to import: select Products.
Upload your file: a CSV or Excel (.xlsx) file. Drop the file here or choose one. The first row must contain column headers. (You can also paste rows copied from Excel or Google Sheets.)
Map your columns: match each File Column to the matching field in your store, then continue. If you've imported before, you can apply a saved column mapping.
Preview the changes: review the Changes Preview and resolve any duplicates (for example, fill empty fields from the import into existing records). You can run a Dry run (preview only) to check the outcome without saving.
Run the import: start it. A progress screen shows the status (you can cancel mid-way), and you'll see Import Complete with the results when it finishes.
Imported products are created as sold By the piece. If a product sells by weight, length, volume or pack, open it after the import and set Sold in on the product; see How to set up unit-based products and packs.
Step by step
- 1
Open Import Data
In the Merchant Hub, go to Settings → Import / Export and choose Import Data.
- 2
Choose what to import
Select Products as the resource to import.
- 3
Upload your file
Upload a CSV or Excel (.xlsx) file. Drop the file here or choose one. The first row must contain column headers. (You can also paste rows copied from a spreadsheet.)
- 4
Map your columns
Match each File Column to the matching field in your store, then continue. If you've imported before, you can apply a saved column mapping.
- 5
Preview the changes
Review the Changes Preview and resolve any duplicates. You can run a Dry run (preview only) first to check the result without saving.
- 6
Run the import
Start the import. A progress screen shows status (you can cancel it), and you'll see Import Complete with the results when it's done. Imported products are created as sold By the piece; set Sold in afterwards on any that sell by weight, length, volume or pack.
Frequently asked questions
What file types can I import?
CSV or Excel (.xlsx). You can also paste rows copied from a spreadsheet.
My columns weren't detected.
Make sure the first row of your file contains column headers.
Can I preview before importing?
Yes. Review the Changes Preview, and use Dry run (preview only) to check the result without saving.
What happens with duplicates?
The wizard helps you resolve duplicates, including filling empty fields from the import into existing records.
Can I reuse a column mapping?
Yes. Apply a saved column mapping to your file so you don't have to remap each time.
Can I import products sold by weight or in packs?
The import creates every product as sold By the piece. After importing, open the product and set Sold in to the unit it sells by (pound, metre, glass or a pack size you define). See How to set up unit-based products and packs.