Shopify’s product CSV format, as these tools read it

These are the rules Import Checker, Supplier CSV Converter and Catalog Audit work from. They follow Shopify’s supported product CSV format; Shopify’s own help pages are the final word.

The rules

One row per variant
Each row is a variant, or an extra image. Rows that belong to one product share the same handle and sit together.
Handle groups the product
Use lowercase letters, numbers and hyphens, like canvas-tote. Shopify’s newer files call this column URL handle; both names are read.
Product fields on the first row
Title, description, vendor, type and tags go on the first row of a product. Later rows of the same handle carry only variant or image data.
Options define the variants
Up to three options. Each variant row needs its Option1 Value (and Option2, Option3 if used), and no two variants of a product can share the same values.
Products without variants
Use Title as the option name and Default Title as the value.
Prices are plain numbers
Digits and a decimal point, like 24.00. No currency symbols or thousands separators.
Images are full web addresses
Starting with http:// or https://, one image per row, with an optional position number.
Older and newer column names
Shopify has renamed several columns (Variant SKU is now SKU, Image Src is now Product image URL). These tools read both and write the older names.

Sample files

  • A valid product CSV

    Two products: one with two color variants and two images, one without variants.

  • Header row only

    The columns these tools write, ready to paste your own rows under.

The sample products are made up. Each job also has its own sample: Import Checker, Supplier CSV Converter and Catalog Audit.

Guides to import errors and store moves

All guides on imports, supplier sheets and store moves