How Variants Should Look in a Shopify Product CSV
One row per product looks obvious until variants arrive, and then the same handle has to repeat without creating duplicate products.
Why it happens
- The built-in editor covers a handful of fields, so anything else becomes a spreadsheet round trip.
- A CSV round trip recreates variants instead of updating them when the handle or option columns drift.
- Nobody owns the catalog, so small errors accumulate until an import fails.
Fix it in four steps
- Decide which fields actually change often: price, stock, tags, images.
- Export, edit only those columns, and leave handle and option columns untouched.
- Test on five products and check the storefront before running the rest.
- Record the column meaning somewhere a future you will find it.
Questions people ask
Why does "shopify csv variants format" happen in the first place?
The built-in editor covers a handful of fields, so anything else becomes a spreadsheet round trip.
Can I fix it inside Shopify?
The importer validates the file; it does not repair it. The fix always happens in the spreadsheet or before the export.
How do I stop it happening again?
Record the column meaning somewhere a future you will find it.