Why it happens
- Typos and spacing: "Varient Price", "Variant SKU", "image src".
- Supplier or marketplace exports with their own vocabulary: Name, Price, SKU, Barcode, Image URL.
- Columns renamed in a spreadsheet to make them "nicer" before import.
Broken example
handle,Title,Vendor,Option1 Name,Option1 Value,Variant SKU,Varient Price,image src
oak-table,Oak Table,Acme,Title,Default Title,TAB-1,249.00,https://example.com/table.jpgCorrected file
Handle,Title,Vendor,Option1 Name,Option1 Value,Variant SKU,Variant Price,Image Src
oak-table,Oak Table,Acme,Title,Default Title,TAB-1,249.00,https://example.com/table.jpgCheck your own file in seconds
The fixer corrects wrong capitals in one click, suggests the right name for a close misspelling (you confirm the rename), and flags a missing Handle. Supplier names that are not typos ("Price", "EAN") are listed as unknown columns: rename them with the table above.
Supplier column → Shopify column
| In your supplier file | Shopify header |
|---|---|
| Name / Product name | Title |
| Description | Body (HTML) |
| Brand / Manufacturer | Vendor |
| Category | Type (or Product Category) |
| SKU / Reference | Variant SKU |
| Price / Retail price | Variant Price |
| RRP / Was price | Variant Compare At Price |
| EAN / UPC / GTIN | Variant Barcode |
| Weight (g) | Variant Grams |
| Image / Image URL | Image Src |
How to fix it
- Start from Shopify's product CSV template and copy its header row exactly, capitals included.
- Rename supplier columns using the mapping above; leave out columns you do not need.
- Make sure Handle exists: it is the only column Shopify cannot do without.
- Columns that are not in the template (notes, internal codes) can stay: Shopify ignores them.
Shopify documents the expected format in its common product import issues page. Checking is free and your file never leaves your browser; applying fixes and downloading the corrected file take CSV Viewer Pro or a one-time 2,99€ 24-hour pass.