---
title: "Shopify product CSV format rules — Catalog Bench"
description: "The rules these tools check product CSVs against: headers, handles, variant rows, options, prices and images, with sample files to download."
url: "https://catalogbench.com/shopify-csv-format"
---

# 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](https://catalogbench.com/import-checker), [Supplier CSV Converter](https://catalogbench.com/supplier-csv-converter) and [Catalog Audit](https://catalogbench.com/catalog-audit).

## Guides to import errors and store moves

- [Shopify Product CSV Format: Columns and What They Mean](https://catalogbench.com/articles/shopify-product-csv-format-columns-and-what-they-mean?utm_campaign=turn_8df4bf6751a2443ab816163ea511a73c)

[All guides on imports, supplier sheets and store moves](https://catalogbench.com/articles?utm_campaign=turn_8df4bf6751a2443ab816163ea511a73c)
