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.