How to Import My Products from a CSV
- Navigate to Products and click Import (or go to Products > Import).
- You will see two tabs: Products and Variations. Select Products to import new products.
- Select your CSV file, or drag it onto the upload area. If you picked the wrong file, click Replace CSV.
- On the Map CSV Columns to Product Fields screen, match each of your CSV column headers to the right product field (see the tables below). Fields marked "(optional)" can be left on
----. - Review the preview of the mapped data underneath to check each column lines up correctly.
- Click Import Products to begin the import. Don't leave the page while it is running.
- When it finishes, you'll see how many products were imported. Any rows that failed are listed with the reason. You can click Import another csv or Go to Jobs List to check the import's status.
What every row needs
Each row in your CSV must have:
| Column | Notes |
|---|---|
| name | The product name. Rows without a name will fail. |
| type | The product type, using one of the values below. Rows with a missing or unrecognised type will fail. |
On the mapping screen you must map type, and at least one of name or sku, before you can continue. However, each product row still needs a name and a type to import successfully. We recommend always mapping both.
Accepted product types
Type values must be entered in lowercase exactly as shown:
| Value | Product type |
|---|---|
simple | Simple product |
variable | Variable product |
digital_simple | Digital simple product |
digital_variable | Digital variable product |
addon | Add-on product |
Recommended and optional columns
Everything else is optional. You can leave a column out, or map it to ----, and the product is created with a default.
| Column | If left blank |
|---|---|
| price | Set to 0. We strongly recommend always including a price. |
| sku | No SKU is saved. The SKU is also used to match existing products (see below). |
| status | Set to draft. Accepted values: draft, disabled, active. |
| quantity | Set to 0 |
| stockStatus | Set to in_stock. Accepted values: in_stock, out_of_stock. |
| currency | Left empty. Use a 3 letter currency code, for example AUD |
| description, shortDescription | Left empty |
| featuredImage, images | No images. Use image URLs, separated by commas for multiple images. |
| trackInventory, taxable, incTax, globalShipping, isCustomisable | Use true or false |
| shippingCost, shippingWeight, shippingLength, shippingWidth, shippingHeight | Set to 0. If you don't give a shipping cost, the product uses your global shipping settings. |
| taxAmount | Left empty |
| syncId | Left empty |
| storefronts | Not added to a storefront. List storefronts separated by commas. |
| locations | Not added to a location. List locations separated by commas. |
If a storefront or location in your file can't be found, the product is still imported but that row is listed as a failure with the names that weren't found.
How existing products are handled
If a row matches a product you already have, that product is updated instead of a duplicate being created. A row matches an existing product when:
- its sku matches an existing product's SKU, or
- its name and type match an existing product's name and type (not case sensitive)
Within a single CSV file, each SKU, and each name and type combination, can only appear once. Duplicates are listed as failures.
An example row
name,description,sku,type,price,quantity,stockStatus,status
Organic Honey Jar,Pure organic honey from local beehives,HON-001,simple,24.99,100,in_stock,active
Importing variations
To import variations for existing variable products, use the Variations tab. Each row needs:
| Column | Notes |
|---|---|
| parentProductIdentifier | Identifies the parent product: its UUID, name, SKU, or sync ID |
| price | The variation's price |
| qty | The stock quantity |
| stockStatus | in_stock or out_of_stock |
Optional columns are sku, syncId, and attributePair, which lists the variation's attributes as Attribute:Option pairs separated by semicolons, for example Size:Large;Colour:Red.