Import products from Excel
Bring a whole catalog in one file — SKUs, variants, prices and opening stock.
5 min read · Products & inventory
Sign-in required — we'll send you straight to the right screen.
Adding hundreds of products by hand isn't the job — the importer takes an Excel or CSV file and creates the whole catalog in one pass.
Import steps
- Open Products → Bulk import.
- Click Download template — it gives you the exact column layout the importer expects.
- Fill it in Excel and save (
.xlsx,.xlsor.csv— first row must stay as the header row). - Drop the file in, review the preview, and fix any flagged rows.
- Confirm — products, variants and opening stock are created together.
What the file can carry
- Name, SKU, barcode, category
- Variant options and values (size/color rows for the same product)
- Cost and selling price
- Opening stock quantities
Tip: Barcodes in Excel get mangled when treated as numbers — format the barcode column as Text before pasting, or leading zeros silently disappear.
After the import
New products created by the import log a purchase stock movement — your stock ledger stays consistent, not just the counts. Opening balances land as opening stock so accounting can tell them apart from real purchases.
If some rows fail
The result reports which rows had errors and why — fix those rows in the file and re-import only the failures. See import errors for the common ones.
Sign-in required — we'll send you straight to the right screen.
Related guides
Product variants (size, color…)
One product, many options — each with its own SKU, barcode, price and stock.
Import errors
Rows that failed to import — the usual causes and how to re-import just the failures.
Categories & collections
Categories keep the back office tidy; collections merchandise the storefront.
Didn't find what you needed? Press Ctrl K to search all guides, or ask your admin to open the ? menu in the app.