CATALOGFIX FIELD NOTES · SHOPIFY CSV
All guidesFix supplier CSV problems before your Shopify import
A file can look fine in Excel and still contain values that need attention. Here is a small example you can inspect and fix yourself.
Practice with two intentional problems
Download the fictional CSV with two issues, or open the sample directly in the app. The second and third data rows contain problems: one repeats a SKU; another uses “on request” where a numeric price is expected.
| Source row | Finding | Practice correction |
|---|---|---|
| 3 | Duplicate SKU: DEMO-AZ-S | Use DEMO-AZ-M for the blue, size M variant |
| 4 | Price: on request | Enter 21.90 as a fictional numeric price |
Duplicate SKU: establish which item it identifies
CatalogFix blocks repeated non-empty SKUs so you can review them before exporting. In the practice file, the blue S and blue M variants accidentally share DEMO-AZ-S. Select Fix SKU on source row 3 and give the M variant its own reference.
For a real catalog, confirm the correct identifier with your source data. Do not append random characters just to dismiss a warning: the same reference may be used in orders or inventory systems. A duplicate can also reveal a row that should not be there.
Non-numeric price: do not invent a selling price
Text such as “on request” is not a numeric selling price. Select Fix price on source row 4, enter the fictional amount 21.90 and check again. For a live product, obtain the actual price before exporting.
Keep prices separate from currency labels. Check that a comma or period has not changed the intended amount. The number you export should match your store's pricing decision, not merely satisfy the file checker.
Other values worth checking
- Missing product name: add the intended title and check whether its variant rows use the same grouping.
- Repeated variant combination: inspect rows with the same color and size. They may be duplicates or need a different product grouping.
- Missing stock: if you map a stock column, provide a quantity for every relevant row. Use zero when stock is actually zero.
- Unexpected columns: review the mapping rather than assuming every supplier heading is recognized.
How to know the corrections worked
- Apply both practice corrections and run the checks again.
- Confirm that the two findings are resolved and the product preview becomes available.
- Compare each variant's SKU, price and stock against the source.
Checking, correcting and previewing are free. You only pay €9.90 total if you choose to download the corrected export. Paid download access lasts 24 hours.
For Shopify's own format requirements, see its CSV documentation. Use a small test before a full import; CatalogFix does not connect to or validate your live store.
Try fixing the practice catalog
Preparing a file from scratch? Read the supplier Excel to Shopify CSV guide.