A Shopify product CSV can fail for reasons that are hard to spot by eye. The error message may point to one row while the same issue appears elsewhere in the file.
Before importing again, I check these five things:
- Duplicate handles and duplicate variant combinations
- Incomplete Option1, Option2, or Option3 name/value pairs
- Invalid status, price, and boolean values
- Image URLs that are malformed or attached to the wrong row
- Delimiter, quoting, and encoding problems
The useful output is not a vague pass/fail score. It is a row-level issue table, a repaired CSV, and a change log that keeps the original value beside the replacement.
I turned that workflow into a small manual service for Shopify product CSVs. It is $19 for one file and does not require store access or customer data.
You can try the browser-only preview first. The file stays on your device: https://csv-preflight-demo.smagnezi8.workers.dev/
Service details: https://csv-preflight-site.smagnezi8.workers.dev/
(AI assisted with editing this post; I built the checker and service.)
