Documentation
Fix Shopify inventory CSV errors
Find and fix common Shopify product CSV errors — missing SKUs, invalid quantities, duplicate handles, and bad column mapping — before you import.
Shopify product and inventory CSV imports fail when a single row breaks Shopify's rules. This guide covers the most common Shopify CSV errors, how to spot them quickly, and how to fix them across your whole file — not just the rows you can see in a spreadsheet.
Common Shopify inventory CSV errors
| Error type | Typical cause | Why Shopify rejects it |
|---|---|---|
| Missing SKU or handle | Empty required column after export/edit | Shopify cannot match or create the product |
| Invalid quantity | Text in a number field, negative stock where not allowed | Import parser fails on the row |
| Duplicate SKU | Same SKU on multiple rows | Updates conflict or create duplicates |
| Wrong column headers | File columns do not match Shopify's template | Fields map to the wrong attributes |
| Invalid price or barcode | Letters in numeric fields, bad formatting | Row-level validation failure |
Supplier files rarely match Shopify's template out of the box. Teams usually merge catalog data, stock counts, and min/max files in Excel — which is where duplicate SKUs, stray formulas, and blank required fields appear.
Why spreadsheets make this painful
In Excel or Google Sheets you only see a slice of the file at once. Common problems:
- Hidden rows still export and break the import
- Find & replace can fix visible cells but miss filtered rows
- No per-cell error report tied to Shopify's rules
- Manual spot checks do not scale past a few hundred SKUs
A 5,000-row Shopify CSV can contain dozens of errors scattered across the sheet. Fixing them cell by cell is slow and error-prone.
A better workflow with Import Ready
Import Ready is built for inventory import files (CSV and Excel). The workflow:
- Upload your file — CSV or Excel, including Shopify-oriented exports
- Match columns — map headers to SKU, quantity, price, and other fields
- Review validation issues — see every error and warning per cell
- Bulk edit — fix matching rows across the entire dataset, including rows you have not scrolled to
- Download Shopify product CSV — export a corrected file ready for Shopify Admin
Tip: Resolve all errors before export. Warnings are worth reviewing but may not block your process.
Step-by-step: fix Shopify CSV errors
1. Upload and map columns
Upload your product or inventory file. On the match-columns screen, align your headers with Import Ready fields (SKU, product name, stock quantity, min, max, etc.). Wrong mapping is a frequent source of "mysterious" Shopify errors — the data is present but in the wrong column.
2. Open import preview and read the issues panel
Open import preview. Click View issues to list every problem by type. Use Jump to issue to land on the exact cell instead of scrolling manually.
3. Bulk-fix repeated mistakes
If the same error appears on many rows (empty brand, wrong quantity format, duplicate SKU pattern), use bulk edit:
- Filter rows by error type or column
- Apply one correction to all matching rows
- Revalidate to confirm the issue count drops
This is the main advantage over Excel: you fix the whole file, not just what is on screen.
4. Export Shopify product CSV
When errors are cleared and changes are saved, choose Download CSV → Shopify product CSV. Test with a small batch in Shopify Admin before importing a full catalog.
Checklist before uploading to Shopify
- Every row has a unique SKU (or handle, depending on your process)
- Quantity and price columns contain numbers only
- Required fields are filled for every row
- Column headers match what Shopify expects in the export format
- You saved all edits and downloaded the latest export