If your Shopify CSV import is not working, it is usually caused by a small issue in your CSV file.
This guide helps you find and fix the most common problems.
Start with a simple check
Before looking deeper, check the basics:
- Are all required columns included?
- Do the column names match Shopify exactly?
- Is your file saved as CSV (UTF-8)?
Many import issues are caused by small formatting mistakes.
Missing or incorrect columns
If a required column is missing, the import may fail.
To fix it:
- Use a Shopify export as a template
- Make sure column names match exactly
Variants not importing correctly
If variants are not set up correctly, products may be duplicated or missing options.
To fix it:
- Use the same handle for all variants of one product
- Make sure each variant has its own row
Images not importing
If images are missing, the image URLs may not be correct.
To fix it:
- Use direct image links (ending in
.jpg,.png, etc.) - Make sure the images are publicly accessible
Barcodes (EAN/ISBN) are incorrect
Spreadsheet tools may change long numbers into scientific notation.
8712345678901→8.71235E+12
This breaks the barcode.
To fix it:
- Format the column as Text
- Or add an apostrophe before the number
Products are duplicated instead of updated
This usually happens when the handle does not match an existing product.
To fix it:
- Make sure the handle is exactly the same
- Check for extra spaces or differences in spelling
When to use a CSV import app
If you keep running into issues, a CSV import app can map non-Shopify headers before the import starts.
The Simple CSV Shopify app can:
- Map your columns to Shopify fields
- Preview five example rows before the import
- Update existing products with exact SKU, barcode, handle or Shopify ID matches
Simple CSV ignores letter case and surrounding spaces when it compares SKU, barcode and handle values. Prefix matches do not update a product. If an exact SKU or barcode matches several products, the row is skipped and the import log reports how many products use that identifier.
More help
If you are not sure how your CSV should look, see Shopify CSV format explained.
The How to import products to Shopify using CSV guide covers the full workflow.
For detailed troubleshooting and Shopify’s full CSV field reference, read the complete Shopify CSV import guide.