The four failure classes we see most
Across store migrations and supplier uploads, import errors almost always fall into one of these categories:
Common Scenarios:
- Encoding corruption: files saved as ANSI/GBK/Shift-JIS contain invisible bytes that Shopify renders as mojibake or rejects outright.
- Unescaped quotes and commas: description text with a stray " or comma shifts every column to the right (column drift).
- Header mismatch: translated or abbreviated headers (Price vs Variant Price) silently map to the wrong field.
- Broken variant rows: Option1 Name filled in but Option1 Value empty, or duplicate SKUs across different handles.
Fix it in seconds with client-side validation
ShopTools runs the same checks locally in your browser: header mapping, quote/encoding repair, variant and SKU validation. No file ever leaves your machine, and the repaired CSV is written back in clean UTF-8.
Features:
- Header auto-mapping: Matches Price, SKU, Image and 40+ aliases to the official Shopify columns.
- Quote & encoding repair: Closes broken quotes and re-exports everything as UTF-8.
- Variant & SKU checks: Detects handle collisions, duplicate SKUs and orphan option rows.