Turn any supplier spreadsheet into a Shopify-ready product CSV

Because Shopify’s product CSV encodes three different things in one flat table: products, their variants, and their images. A product with four variants and three images is eight rows, where most columns must be blank on all but the first. Supplier files almost never arrive in that shape, so the work is reshaping rows, not renaming columns. That reshaping is exactly what this tool does.

Extra images go on extra rows that carry only the URL handle plus the image columns, with Image position counting up from 1. If your supplier packs all URLs into one cell separated by semicolons, commas or pipes, pick the “split image list” formula on Product image URL and those rows are generated for you.

Usually because the handle changed between rows that were meant to be the same product. Shopify groups rows by URL handle, so a trailing space, a different capitalisation, or a per-row slugified title produces several products instead of one. This tool slugifies once per product group and repeats that exact handle on every related row.

One row per variant. Option names (Size, Colour) appear only on the product’s first row; option values appear on every variant row; price, SKU, barcode, weight and inventory are per-variant columns. Variant-specific images go in Variant image URL on the variant’s own row, which is a different column from Product image URL.

Two variant rows of the same product carry the same option combination — often because a parent row was exported alongside its variations, or because one variant is missing a value for an option the product declares. The validator flags both cases with the row numbers before you upload.

Shopify’s price columns accept digits and a dot only. A euro sign, a thousand separator, or a decimal comma all break them. European sheets are the common case: “€1.234,50” has to become “1234.50”. Price cells are normalised automatically and anything unparseable is reported rather than silently zeroed.

Shopify stores one integer value in grams, plus a separate display unit. Tell the tool which unit your source column uses and the conversion to whole grams happens on export. A cell that carries its own unit, like “1.5 kg”, is read correctly regardless of that setting.

Nothing stops you, but handles are generated per file, so two chunks that share a product title produce two different handles and Shopify creates duplicates. Variants of one product split across chunks do not merge either, and the duplicate-SKU and option-uniqueness checks only see the chunk in front of them. The free tier exports 25 products per file; Pro converts the whole catalogue in one pass, which is the only way those cross-file checks can work at all.

Shopify rejects a product CSV above 15 MB. Exports are kept under 14 MB and split into numbered parts when needed, and a product is never split across two parts — all of its variant and image rows stay together, because rows are tied to their product only by the handle.