Support article

Fix Shopify CSV Import Errors

Fix failed Shopify CSV imports caused by headers, variants, images or spreadsheet formatting.

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 a full image URL that starts with https:// or //
  • Make sure the images are publicly accessible

Simple CSV skips relative image paths such as /image/catalog/photo.jpg. The product still imports without that image, and the import log says: Skipping image "…" because relative paths are not supported. Use a full URL.

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, first barcode, handle or Shopify ID matches

Simple CSV compares SKU, handle and the first barcode exactly after ignoring letter case and surrounding spaces. Prefix matches do not update a product. If a Shopify variant has several barcodes, Simple CSV checks only the first one. A secondary barcode in the file does not match, so the row is skipped as not found. If an exact SKU or first barcode matches several products, the row is skipped and the import log reports how many products use that identifier. Use SKU or Shopify ID when you can.

Scheduled import completed with zero counters

A Pro or Scale scheduled import may appear as Completed in the import history but show No changes in the file when you open it. This means Simple CSV found the same file and settings as the last fully successful scheduled run. It skipped the file without touching Shopify.

Open the automation and select Run now if you need to apply the same file again. Run now always processes it. This is useful when Shopify changed after the last run, such as when sales reduced inventory or someone deleted a product.

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.