How to import products in bulk
Bulk-import products into the Merchant Hub — upload a CSV or Excel file, map your columns to fields, 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. Drag and drop or choose a file. 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.
Frequently asked questions
What file types can I import? CSV or Excel (.xlsx). You can also paste rows 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.
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 — drag and drop or choose a file. 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.
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.