Check your supplier CSV before you import it into Shopify
Free, row-level report: encoding, delimiter, headers, prices, variant grouping, duplicate option combinations, image URLs and spreadsheet-formula prefixes. No account needed.
The validator produces the report, a preview and a free sample. If you want the complete Shopify CSV, it is a $12 one-time download from the same job — see pricing.
Rules we apply
- Price is required per row, must be ≥ 0 with at most 2 decimals; the decimal separator is set by you and never guessed. Currency symbols and thousands separators are reported, not stripped. Zero prices need confirmation.
- Compare-at price must be greater than price. Duplicate SKUs are warned and need acknowledgement.
- Variants: option combinations must be unique inside a parent; product-level fields (title, vendor, description, type, tags) must match inside a group. Conflicts are reported by row, never merged silently.
- SKU and barcode stay text — leading zeros are preserved.
- Handles are deterministic:
cp-<slug>-<hash>. We do not check handles that already exist in your store; never enable overwrite when importing. - Cells starting with
=,+,-,@are rejected as possible spreadsheet formulas unless you choose to prefix them with an apostrophe. - Image URLs must be absolute https:// URLs. We never download them; the report marks them
not_checked. - Descriptions are imported as escaped plain text with paragraphs and line breaks — never as raw HTML.
- Nothing is dropped silently: blank, short and extra-column rows are listed in the report.
Rule pages: invalid header, duplicate option combination, invalid price.
Supported and unsupported
Supported
- One CSV; each row is a simple product or a variant
- Comma, semicolon or tab delimiter; UTF-8, UTF-8 BOM, UTF-16LE BOM
- Title, plain-text description, vendor, type, tags, SKU, price, compare-at price, barcode
- Up to 3 option columns (e.g. Color, Size); up to 5 product image URL columns; optional variant image
- Explicit parent/product ID column for variant grouping
- Up to 10 MiB, 5,000 rows, 80 columns; all products created as draft
Not supported
- XLSX/XLS, multiple sheets, archives, embedded images
- Inventory, locations, weight/shipping, metafields, tax/category, Google/Markets columns
- Updating existing products or stock; store migration; handle checks against your store
- HTML descriptions from the source (plain text is converted safely)
- Remote fetching of image URLs, custom formulas, AI mapping, accounts or subscriptions