15 Common Shopify CSV Import Errors & How to Fix Them

If you've ever tried to import products into Shopify via CSV, you know the frustration: cryptic error messages, rows that silently fail, and hours wasted debugging a spreadsheet. Shopify's built-in importer is strict, and its error messages don't always tell you what's actually wrong.

Here are the 15 most common Shopify CSV import errors, what they really mean, and how to fix them.

1. Invalid Handle Format

ERROR "Handle contains invalid characters"

The Handle column is Shopify's internal URL slug for each product. It must be lowercase letters, numbers, and hyphens only. No spaces, no underscores, no Chinese characters, no special characters.

Wrong: My Product Name, Product_Name, 产品-001

Correct: my-product-name

2. Missing Required Columns

ERROR "Missing required column"

Shopify requires at minimum Handle and Title. For variant products, you also need Variant Price and Variant Inventory Qty. If your CSV is missing any of these, the entire import fails.

3. Duplicate Handles

ERROR Rows silently skipped

Every product needs a unique Handle. If two rows share the same Handle, Shopify treats them as variants of the same product — which can cause unexpected behavior if they're actually different products. This is one of the most common "silent failure" scenarios — Shopify shows a green success banner but some rows never made it in.

4. Invalid Price Format

ERROR "Price can't be blank" or invalid number

Prices must be plain numbers. No currency symbols ($, €, ¥), no commas as thousand separators, and definitely no text like "TBD" or "ask for quote."

Wrong: $19.99, 1,234.00, N/A

Correct: 19.99

5. Compare-At Price Lower Than Price

WARNING No sale badge shown

The Compare-At Price is the "original" price that shows a strikethrough with a sale badge. If it's lower than the actual Price, Shopify won't display the sale — and your customers won't see any discount.

6. Boolean Fields Not TRUE/FALSE

ERROR Invalid boolean value

Fields like Published, Variant Requires Shipping, Variant Taxable, and Gift Card must be exactly TRUE or FALSE. Values like yes, no, 1, 0, Y, N will fail.

7. Image URL Not Downloadable

ERROR "An error occurred while trying to download the image"

Shopify tries to download every image URL during import. If the URL returns a 404, requires authentication, is behind a firewall, or isn't a valid image format, the import fails — even if everything else is perfect.

Image URLs must start with https://, be publicly accessible, and point to an actual image file (.jpg, .png, .gif, .webp).

8. Leading or Trailing Whitespace

WARNING Matching failures

Extra spaces before or after cell values are invisible in Excel but cause Shopify to treat values as different. "Nike " and "Nike" become different vendors. This is especially problematic for Handles and SKUs where exact matching matters.

9. Duplicate SKUs

ERROR Duplicate variant SKU

Every Variant SKU must be unique across your entire store. Duplicate SKUs cause inventory tracking conflicts and can lead to wrong products being shipped.

10. Invalid Inventory Policy

ERROR Invalid inventory policy value

Variant Inventory Policy must be exactly deny or continue. Typos like denied, Deny, or leaving it blank will fail.

11. Option Name/Value Mismatch

ERROR Option inconsistencies

If you have Option2 Name set to "Color", you must have Option2 Value filled in for every row. An Option Name without a corresponding Value — or vice versa — breaks the variant structure.

12. Column Header Case Sensitivity

WARNING Column not recognized

Shopify column headers are case-sensitive. handle won't work — it must be Handle. variant price won't work — it must be Variant Price. Always use Shopify's exact capitalization.

13. Non-Numeric Inventory Values

ERROR Invalid number format

Variant Inventory Qty, Variant Grams, and Cost per item must be valid numbers. Text values like "In Stock" or "∞" will fail.

14. File Size Over 15MB

ERROR File too large

Shopify's CSV import limit is 15MB. Large catalogs with many image URLs or HTML descriptions can exceed this. Split the file into smaller batches.

15. Whitespace-Only Rows

WARNING Confusing import results

Empty-looking rows that actually contain spaces or tabs confuse Shopify's importer. They're invisible in Excel but cause unexpected behavior. Always clean trailing empty rows before import.

Why Shopify CSV Errors Are So Frustrating

There are three reasons Shopify merchants waste hours on CSV imports:

1. Silent failures. Shopify shows a green "Import successful" banner even when individual rows fail. You might not notice missing products for days.
2. Cryptic messages. Error text like "Validation failed: An error occurred" doesn't tell you which row, which column, or what to do about it.
3. No undo. There's no built-in way to preview what will happen before you import — or roll back if something goes wrong.

That's exactly why we built CSVPreflight: validate before you import, see exactly what's wrong, fix it, and then upload with confidence.