CATALOGFIX FIELD NOTES · SHOPIFY CSV

All guides

Fix 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.

Updated 22 November 2026 · By CatalogFix

These are CatalogFix's preparation checks, not an exhaustive list of Shopify import errors. If Shopify rejects a file, read its specific error message as well.

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.

What to change in the practice catalog
Source rowFindingPractice correction
3Duplicate SKU: DEMO-AZ-SUse DEMO-AZ-M for the blue, size M variant
4Price: on requestEnter 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

How to know the corrections worked

  1. Apply both practice corrections and run the checks again.
  2. Confirm that the two findings are resolved and the product preview becomes available.
  3. 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.