Skip to content

How to import or update products with Excel

Download the template or export your products, edit them in Excel and upload them again to create or update in bulk.

To add many products at once or change prices and stock in bulk, use Products › Products › Export (or Import products › Excel / CSV › With the template).

Steps

  1. Click Download template (an Excel file with your categories, VAT, units, attributes and price lists in drop-down lists) or Export to Excel to start from your current products.
  2. Fill in or edit the rows and save the file.
  3. Upload it (Excel or CSV, up to 10,000 rows).
  4. Choose what to do If the product already exists (same SKU or barcode): create new ones and update existing ones, only create new ones, or only update existing ones. Also decide whether to Create missing categories.
  5. Click Check file. You will see how many rows are new, updated, unchanged, skipped or have errors. Nothing has been saved yet.
  6. If everything looks right, click Import. Rows with errors can be downloaded as an Excel file, fixed and uploaded again.

Keep in mind

  • An existing product is recognised by its SKU or barcode. Rows without SKU or barcode whose name matches a product you already have are skipped as possible duplicates.
  • To update products you also need the product edit permission.
  • Your plan may limit the number of active products; the check warns you before importing.
  • There is also Settings › Products and data › Import data, with templates for products, customers and suppliers (up to 5,000 rows per file).
  • If you come from another program (Shopify, Holded, Odoo…) or want to create products from photos, see the article on AI import.
Back to the help centre