Start building

Last updated

Import and export products

Products

Import and export products

Use a spreadsheet to add hundreds of products at once, or to change prices and stock in bulk. Open Products → Product Import/Export.

Export

  1. On the Export tab, tick the fields you want under Select Fields to Export (basic information, pricing, inventory, shipping, content, SEO, relationships). Field Presets → Save Preset remembers your choice.
  2. Under Filters & Format, narrow by Status, Vendor or Category if you like, and pick an Export File Format: Excel (.xlsx), CSV or XML. For CSV, also choose the number style:
    • International (comma, period decimal) — 49.90, best for Google Sheets and most spreadsheet apps;
    • Regional (semicolon; comma decimal) — 49,90, for Excel in countries that write decimals with a comma.
  3. Click Export. An Excel export has the same columns as the import file, so you can edit it and import it straight back.

You can also tick products on Products → Products and export just those.

Import

  1. Click Download Excel template (or Download CSV template) for a sample file with the right column headings and example rows. The Excel template also has an Instructions sheet explaining every column, and drop-down lists for columns such as status. Fill in the first sheet (one row per product, or per variation).
  2. On the Import tab, upload your CSV or Excel file (or use Import from URL).
  3. Choose the Import Strategy:
    • Create & Update All — new SKUs are added, existing ones updated;
    • Create New Only — existing products are left alone;
    • Update Existing Only — only changes products you already have. Products are matched by SKU.
  4. Map Fields — match each column in your file to a product field. Columns with the same name are matched for you; choose Skip this column for anything you don't need. At minimum Name must be mapped.
  5. Optional Data Modifier on a column, for example Increase by % on price for a price rise.
  6. Click Validate & Preview. Check Will Create and Will Update and the first rows.
  7. Tick Test Import (preview only) for a dry run, or click Import Now. Keep the window open while it runs.

Prices are in your store currency in both CSV and Excel: 499 means 499.00 and 49.90 means 49.90.

Every import and export appears under History. If rows were skipped, click Download Errors to see why.

Excel files

  • Only the first sheet is read (an Instructions sheet is always skipped). Keep the header row as it is.
  • Dates, prices like 1,25,000.00 and TRUE/FALSE cells can stay in Excel's own formats; they are read as plain values. Formula cells import their result.
  • To keep leading zeros (SKUs, pincodes, phone numbers), type them as text or use a zero-padded format; the Excel template already formats its columns as text.
  • Up to 200,000 rows per file. Old .xls files are not supported — save as .xlsx (or CSV) first.
  • Error reports give the spreadsheet row number, so row 5 in the report is row 5 in your file.

The same Excel support applies to categories, features and brands under Settings → Import / Export.

Images in bulk

Settings → Import / Export → Bulk Image Import (ZIP): put images in a ZIP file named by SKU (for example TSHIRT-RED-M.jpg; for more images use TSHIRT-RED-M (2).jpg) and upload it. Each image is attached to the product with that SKU. Or put an Image URL column in your import file.

Tips

  • Import 5–10 products first to check the result, then the rest.
  • Keep SKUs unique; they are how updates find the right product.
  • Set all quantities to zero before import is useful for a full stock count: products not in your file end up with zero stock.
PreviousFeatures, specifications and filtersNextStorefront search