Skip to main content

How to Import My Products from a CSV

  1. Navigate to Products and click Import (or go to Products > Import).
  2. You will see two tabs: Products and Variations. Select Products to import new products.
  3. Select your CSV file, or drag it onto the upload area. If you picked the wrong file, click Replace CSV.
  4. 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 ----.
  5. Review the preview of the mapped data underneath to check each column lines up correctly.
  6. Click Import Products to begin the import. Don't leave the page while it is running.
  7. 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:

ColumnNotes
nameThe product name. Rows without a name will fail.
typeThe product type, using one of the values below. Rows with a missing or unrecognised type will fail.
note

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:

ValueProduct type
simpleSimple product
variableVariable product
digital_simpleDigital simple product
digital_variableDigital variable product
addonAdd-on product

Everything else is optional. You can leave a column out, or map it to ----, and the product is created with a default.

ColumnIf left blank
priceSet to 0. We strongly recommend always including a price.
skuNo SKU is saved. The SKU is also used to match existing products (see below).
statusSet to draft. Accepted values: draft, disabled, active.
quantitySet to 0
stockStatusSet to in_stock. Accepted values: in_stock, out_of_stock.
currencyLeft empty. Use a 3 letter currency code, for example AUD
description, shortDescriptionLeft empty
featuredImage, imagesNo images. Use image URLs, separated by commas for multiple images.
trackInventory, taxable, incTax, globalShipping, isCustomisableUse true or false
shippingCost, shippingWeight, shippingLength, shippingWidth, shippingHeightSet to 0. If you don't give a shipping cost, the product uses your global shipping settings.
taxAmountLeft empty
syncIdLeft empty
storefrontsNot added to a storefront. List storefronts separated by commas.
locationsNot 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:

ColumnNotes
parentProductIdentifierIdentifies the parent product: its UUID, name, SKU, or sync ID
priceThe variation's price
qtyThe stock quantity
stockStatusin_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.