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.
Same options, different SKUs
Why a variant can still be duplicated
Two rows with different SKUs can still describe the same variant. Compare the complete set of option values within the same Handle or URL handle.
| Row | Handle | SKU | Color | Size |
|---|---|---|---|---|
| 2 | camp-shirt | SHIRT-A | Blue | M |
| 3 | camp-shirt | SHIRT-B | Blue | M |
Both rows describe Blue / M. Check your actual products: if row 3 should be Blue / L, correct its size from the source record. If it is the same variant repeated, reconcile the duplicate. Changing only the SKU does not resolve the repeated option combination.
Changing an existing variant’s option values can replace its Shopify variant ID. Verify dependent apps and keep an original export before any import.
Export versus shopping feed
Expected blanks are not always errors.
A Shopify product export and a shopping feed serve different purposes. Shopify prices normally omit a currency code; a feed price needs a verified currency. A product handle also needs conversion to a public product-page URL.
The checker lists those conversion steps separately. A compare-at price is the higher reference price, not a sale-price field. Additional image rows are recognized separately from product and variant rows. Blank Shopify SEO fields use the product title or description as a fallback.
The downloaded action CSV is a checklist of original row numbers and recommendations. It is not a Shopify product import file.
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.
Current CSV fields, images and overwrite behavior · Common product CSV import problems · Importing products
Checked October 5, 2026. Shopify is a trademark of Shopify Inc. This independent checker is not affiliated with or endorsed by Shopify.