CSV format
The CSV of products must contain the following columns to be a valid CSV and every product variation needs to be a new row in the CSV file.
- Product ID (required)
- Variant ID (required)
- Title (Specified on the first row)(required)
- Body (Specified on the first row)(required)
- Vendor (Specified on the first row) (required)
- Product Type (Specified on the first row) (required)
- Tags (Specified on the first row)
- Published (Specified on the first row)
- Option1 Name (Specified on the first row)
- Option1 Value
- Option2 Name (Specified on the first row)
- Option2 Value
- Option3 Name (Specified on the first row)
- Option3 Value
- SKU
- Barcode
- Grams
- Price (required)
- Compare At Price
- Requires Shipping
- Taxable
- Image Src (Required in the first row)
- Image Alt Text (Specified on the first row)
- Weight Unit
- Cost per item
- Status (Specified on the first row)
- Qty
The CSV first row is not processed as it is expected to be the headers.
The CSV can have empty cells for the information that does not apply to the product.