Importing products

One row per size, which is what every platform exports. Rows sharing a handle become one product.

The columns

Your file can name its columns any of the ways shown: the importer matches them whatever their case or spacing. Columns it does not know are left out.

Column	Also read from	Notes
Handle `handle`	`slug` `parent sku` `product handle` `group id` `item group id` `style code`	What ties the sizes of one garment together. Rows sharing a handle become one product.
Product title (required) `title`	`name` `product name` `item name` `post title`
Description `description`	`body html` `body` `long description` `post content` `short description`
Brand `brand`	`vendor` `manufacturer` `make`
Category `category`	`categories` `product category` `product type` `type`
SKU (required) `sku`	`variant sku` `item code` `code` `article number`	The variant code. Must be unique, and is what a re-import matches on.
Barcode `barcode`	`gtin` `ean` `upc` `isbn`
Price (required) `price`	`variant price` `retail price` `selling price` `regular price`
Sale price `salePrice`	`sale price` `discounted price` `special price`	WooCommerce and others put the reduced price in its own column. Where there is one, it becomes the price and the ordinary price becomes the was-price.
Was price `compareAtPrice`	`compare at price` `rrp` `list price` `msrp`
Cost price `costPrice`	`cost` `cost per item` `buy price`
Option 1 name `option1Name`	`option1 name` `attribute 1 name`
Option 1 value `option1Value`	`option1 value` `attribute 1 value` `attribute 1 values`
Option 2 name `option2Name`	`option2 name` `attribute 2 name`
Option 2 value `option2Value`	`option2 value` `attribute 2 value` `attribute 2 values`
Weight (grams) `weight`	`grams` `weight g` `shipping weight`
Stock `quantity`	`inventory quantity` `qty` `stock` `stock level` `on hand` `variant inventory qty`	Goes to the shop's main location, which has to exist first. Leave the column unmapped to import the catalogue without touching stock.
Page title `metaTitle`	`seo title` `meta title` `page title` `search title` `title tag`	What a search result says. Left empty, the product title is used.
Meta description `metaDescription`	`seo description` `meta description` `search description` `description tag` `metadescription`	The sentence under a search result. Left empty, the subtitle or the description is used.
Country of origin `countryOfOrigin`	`origin` `made in` `country of manufacture` `manufacturing country`	Where the garment was MADE, as a two-letter code. Not where it is posted from — customs read it as origin, and getting it wrong loses the customer a lower tariff they are entitled to.
HS tariff code `hsCode`	`hs code` `tariff code` `commodity code` `harmonised code` `harmonized code`	The customs classification. Without it a parcel leaving the EU can be held while somebody classifies it for you.
Collection `collection`	`collections` `tags` `product tags`
Status `status`	`published` `active` `visible`
Old address `oldUrl`	`old url` `permalink` `product url` `product page` `url`	The product's address on the old shop. Each becomes a redirect to its page here, so links and search results keep working.

Questions it asks

The photographs in the file

Fetched from the addresses in the file once the products are in, as an import of their own — so they can be undone without undoing the products.

Import them too (the default): Each photograph is attached to its product once, in the order the file lists them.
Products only: The photographs can be imported later from the same file, as Product images.

A template to start from

The template has every column and a few example rows. The examples show the things most often got wrong on a first go.

Handle,Product title,Description,Brand,Category,SKU,Barcode,Price,Sale price,Was price,Cost price,Option 1 name,Option 1 value,Option 2 name,Option 2 value,Weight (grams),Stock,Page title,Meta description,Country of origin,HS tariff code,Collection,Status,Old address
harbour-parka,Harbour Parka,"Waxed cotton, taped seams, two-year guarantee.",Marin & Co,Coats,HARB-PARKA-S,5012345678900,189.00,,229.00,92.00,Size,S,,,1200,4,"Harbour Parka — waxed cotton, two-year guarantee","A waxed cotton parka with taped seams, guaranteed for two years.",PT,6201,Autumn,active,https://old-shop.example/product/harbour-parka/
harbour-parka,Harbour Parka,"Waxed cotton, taped seams, two-year guarantee.",Marin & Co,Coats,HARB-PARKA-M,5012345678917,189.00,,229.00,92.00,Size,M,,,1200,7,"Harbour Parka — waxed cotton, two-year guarantee","A waxed cotton parka with taped seams, guaranteed for two years.",PT,6201,Autumn,active,https://old-shop.example/product/harbour-parka/

Download the template (product-import-template.csv)