Shopify troubleshooting
Common Shopify CSV errors and safer fixes
A CSV can change hundreds of products at once. Use this checklist before an import, and always keep an untouched export as your recovery copy.
Before editing
Never test a bulk change on your only copy.
Export the current products, leave that file untouched, and edit a duplicate. The Catalog Readiness Checker is a preflight; it never writes changes back to Shopify.
Six frequent problems
What to inspect first
Headers do not matchShopify expects supported column names with the correct spelling and capitalization. Compare your file with Shopify’s current sample before importing.
Quotes or commas break a rowProduct text can contain commas, quotation marks, and line breaks. Save as UTF-8 CSV and make sure quoted fields use straight, correctly paired quotation marks.
Variants become disconnectedRows for sizes, colors, or images can depend on their order and shared handle. Avoid sorting an exported Shopify CSV unless you understand the relationships.
Required dependent columns are missingRemoving a column can affect another field. Shopify specifically warns that omitting option columns can create a default variant and remove existing variants.
Images fail to attachUse public image URLs and verify that image rows still belong to the intended product and variant.
The file is too large or changed unexpectedlyWork on a copy, keep the original export, and split large jobs into smaller batches when necessary.
A cautious workflow
Export, duplicate, inspect, then import.
- 1Export the current products
Keep the original file unchanged.
- 2Edit a duplicate
Make one understandable group of changes at a time.
- 3Run a local preflight
Review flagged rows and confirm the facts against Shopify.
- 4Import a small test when possible
Confirm the result before applying a large update.
Important boundary
The checker cannot simulate Shopify’s importer.
It catches supported structural and content risks, but Shopify remains the authority on its current template and import behavior. Review Shopify’s import preview and official error message before changing source data.
Practice safely
Try the fictional file before using store data.
Common product CSV import problems · Importing products · Exporting products
Shopify is a trademark of Shopify Inc. This independent checker is not affiliated with or endorsed by Shopify.