Fixing Shopify CSV Errors Before Black Friday

The Shopify CSV Errors That Actually Break Imports

• Missing or mismatched Handle: every row needs a Handle, and variant rows must repeat the parent's Handle exactly.
• Wrong delimiter: a CSV saved from a European copy of Excel uses semicolons; Shopify expects commas.
• Smart quotes: straight quotes turned into typographic quotes after a round trip through Word or Google Docs, and the parser chokes.
• Encoding: Windows-1252 files turn é into é and £ into £.
• Prices as text: 1.299,00 or $19.99 will not import as a number.
• Duplicate products: multi-channel exports contain "Blue Shirt" and "blue-shirt" as separate items, splitting your stock.

Step 1: Start From a Real Shopify Export

In Shopify admin, export all products. This is your source of truth for the exact columns and order Shopify wants. Make your changes against this file, not a spreadsheet you built by hand.

Step 2: Repair the Structure

Run Auto Fix. It standardizes the delimiter, converts smart quotes to straight quotes, fixes line endings, and normalizes the header row so the file parses cleanly.

Step 3: Fix the Encoding

Convert the file to UTF-8, then check a product with an accent or a currency symbol to confirm the characters survived.

Step 4: Remove Duplicates

Run fuzzy deduplication on Title and Variant SKU. Merge the near-duplicates before they reach Shopify and split your inventory across two records.

Step 5: Validate the Numbers

Every Variant Price, Variant Compare At Price, and Variant Inventory Qty must be a valid non-negative number, and every row must have a Handle. Fix any that fail before importing.

Step 6: Import a Small Test Batch First

Import 10 to 20 rows, confirm they look right in admin, then run the full file. If you want a last human review, open a clean copy as XLSX in a spreadsheet without touching the master CSV.

Black Friday Price-Update Pattern

1. Export current products.
2. Keep only Handle, Variant SKU, Variant Price, Variant Compare At Price.
3. Put the current price into Variant Compare At Price and the sale price into Variant Price.
4. Validate every price is a positive number.
5. Import just those columns. Shopify updates only what you send.

Your Store Data Never Leaves Your Computer

Every step above runs in your browser. Your product and inventory CSVs are parsed and transformed locally, never uploaded, never stored. No account required.

Doing This in How To CSV

• Shopify toolkit for product, inventory, and order files
• Auto Fix for delimiter, smart quotes, and structure (Step 2)
• Change Encoding to convert to UTF-8 (Step 3)
• Fuzzy Dedupe for near-duplicate products (Step 4)
• CSV to XLSX for a safe last review (Step 6)

Frequently Asked Questions