Shopify CSV import guide
Shopify's product CSV import is strict about a handful of things: every row needs a title and SKU, SKUs can't repeat, prices have to be plain numbers, and a few other fields have exact formats. This guide covers the errors that most often stop an import, one page per error, with what it means and how to fix it.
If you'd rather have these checked automatically, upload your file to Supplier Data Ops and it will flag every row with one of these problems before you import.
Common import errors
- Shopify CSV duplicate SKU error
Why Shopify rejects a CSV with the same SKU on two rows, and how to find and fix every duplicate before you import.
- Shopify product handle invalid characters
Shopify handles must be lowercase words joined by hyphens. Here's what breaks that, why it matters for URLs, and how to clean it up.
- Shopify CSV missing required field
Title and Variant SKU are required on every row. Here's what happens when a row is missing one, and how to find the gaps fast.
- Shopify CSV price format error
Currency symbols, thousands separators and stray text in the price column all make Shopify reject the row. Here's the format it expects.
- Shopify barcode invalid on CSV import
Shopify's barcode field expects a UPC, EAN, or GTIN of a specific length. Anything else is flagged, not silently accepted.