Shopify's product import fails per-row, not per-file. One bad price or a mismatched Option1 Name three thousand rows in can mean re-uploading and waiting through the whole import again just to find a single cell. This checks a product CSV against Shopify's actual column rules before you upload it, and names the exact row and column behind each problem.

When you'd use this

Before any bulk import or re-import, and especially with catalogs exported from another platform, since column names and formats (delimiter, price formatting, boolean values) rarely match Shopify's on the first try.

It also catches the relational mistakes a spreadsheet won't warn you about on its own: variant rows that don't share their parent's Handle, duplicate SKUs scattered across the file, or Option1/2/3 Name values that drift between rows meant to belong to the same product.

Common errors

Errors, shown in red, mean the import will fail outright for that row: a missing required column, a price with a currency symbol in it, an invalid barcode. Warnings mean the import will succeed and produce a wrong result, like a compare-at price that sits below the actual price.

A semicolon-delimited file, common from European spreadsheet exports, is detected automatically. If your file still looks garbled after that, it's usually an encoding issue, and this tool flags the character patterns that indicate a UTF-8 file was saved or re-opened as Latin-1 somewhere along the way.

Frequently asked questions