Import products from a spreadsheet
Bring many products into Inventory at once from a CSV file, and fix any rows that need it before they're imported.
- What you'll achieve: Your products imported, with their SKUs, prices and categories, and no half-filled rows.
- Who can do this: Inventory: Create (and Update to change existing products)
- Time: about 4 minutes
Before you start
- Your products in a CSV file with a header row. Select Download CSV template for the column names.
- The categories you use exist, or are written exactly as you want them created.
Steps
1. Open Products
In the sidebar, open Inventory and select Products.
2. Start the import
Select Import.

3. Get the template
Select Download CSV template to get a file with every column and example rows. Fill it in with your products and save it as CSV.
Tip: Products from a supplier's invoice or price list? Choose the Supplier first, and paste the rows under Paste rows from a spreadsheet. Columns such as Item, Qty and Rate are recognised without renaming.

4. Choose your file
Select Choose CSV file and pick your file.
5. Review the rows
Check each row. The message at the bottom says how many products will be created and how many existing ones updated. A product whose SKU already exists is updated, not duplicated.

6. Fix a row
A cell marked in red needs fixing, such as Name required. Type straight into the cell. To leave a row out, select the bin at the end of the row.

7. Check again
Select Re-check. Any rows still with problems are listed with their row number.
8. Import the products
Select Import (it shows how many rows). The result lists each row as created, updated, skipped or an error. Select Download error report to fix any errors and import that file again.

9. Close the window
Select Close. Your products are in the product list, ready to stock and sell.
Tip: New products imported as draft stay hidden from sales until you set them to Active.
Troubleshooting
"Could not parse the CSV file"
Save the file as CSV (comma separated) with a header row, then choose it again.
"Product limit reached — nothing was imported"
Your plan's product limit would be passed. Remove some rows, or upgrade your plan, then import again.
A variant product comes in as several products.
Give every row of the same product the same handle, and fill option1_name and option1_value (for example Colour and Blue).
