Products
Import products from CSV
The supported columns, how variants and prices in several currencies are given, and how to test an import.
Products › Import takes a CSV file with one row per product or per variant.
Columns
| Column | Contents |
|---|---|
title, description, slug | Basics. The slug is created from the title if missing |
sku, price, compare_at_price | Per row. Price in the base currency |
price_EUR, price_NOK … | Explicit price in another currency, one column per currency |
tax_category | standard, reduced, reduced_alt, super_reduced, zero |
weight_grams, length_cm, width_cm, height_cm | Shipping |
inventory_qty | Stock quantity |
option1_name, option1_value … | Variant options |
images | Image URLs separated by ` |
categories | Category slugs separated by ` |
tags | Tags separated by ` |
Rows with the same slug but different options become variants of the same product.
Workflow
- Download the template from the import page and fill it in Excel or Google Sheets. Save as CSV in UTF-8.
- Upload. The preview shows how many products and variants will be created or updated, and rows with errors.
- Run the import. Existing products are matched on slug or SKU and updated.
Always run a small test file first. Import updates prices and stock on existing products when the columns are present.