Shopify CSV import silent failure troubleshooting (nothing shows up)
“Silent” failures are worse than explicit errors because the admin UI offers no obvious stack trace. Shopify may accept a CSV while skipping columns, zeroing inventory fields you thought you set, or attaching only some images. The right response is forensic: compare a handle you control before and after import, and read the follow-up email Shopify sends for many imports (common import issues points to those reports).
Step 1: Re-export and diff one handle
Pick a product you know well. Export the catalog (or just that segment if your workflow allows). Diff the re-exported row against your source file. Columns that disappeared from your intent usually mean the header did not match or the cell was blank when Shopify interpreted overwrite rules differently than you expected.
Step 2: Validate unrecognized columns
Silent skips often trace to headers that look right to humans but not to the parser. Re-read column headers not recognized with your exact header row copied into a plain-text view.
Step 3: Inventory and tracking fields
Inventory columns interact with whether you track inventory, which location you use, and whether inventory is managed by Shopify versus an external system. If an imported quantity disagrees with admin, verify tracking settings on the variant before blaming CSV math.
Step 4: Images that never appear
Public URL accessibility matters. Private buckets, hotlink protection, or typos produce rows that import while media fails. Work through image URLs.
Step 5: Encoding and quoting (again)
Shifting columns late in a row can mis-map trailing fields without tripping a headline error. When numbers land in text columns or vice versa, revisit UTF-8 and quoting.
When to stop using CSV mid-debug
If you loop more than a few hours on the same file, clone the store to a development shop or move a single SKU through a minimal CSV until behavior is predictable. Bulk opacity is a sign you need automation or API-based tooling, not more manual edits.
FAQ
Does Shopify always email results?
Do not rely on memory—check the account email associated with the staff performing the import and spam folders the first time you test a workflow.
Why do line numbers in errors not match my sheet?
Spreadsheet row numbers include headers; parsers count differently. Use the error’s row index as a hint, then search for unique SKUs or titles to find the real record.
Can LaunchCSV help?
It keeps structure closer to Shopify’s expectations by avoiding spreadsheet damage—see without a spreadsheet—but you still need to verify imports in admin.