Support article

How to Import Products to Shopify Using CSV

Import products to Shopify with a CSV file. Prepare the format, upload a test file and check common import errors.

Importing products to Shopify with CSV starts with a spreadsheet containing details such as the title, price and image URLs. Save it as a CSV file and upload it in your Shopify admin.

This support article is a short checklist for completing your first manual import. It focuses on preparing, uploading and checking one file.

Step 1 - Prepare your CSV file

Your CSV file contains all your product information.

Each row is one product or one product variant.

Each column is one type of information, such as Title or Price.

Common columns include:

  • Handle (a unique name for your product, used in the product URL)
  • Title
  • Price
  • Variant options (like size or color)
  • Image URLs (links to your product images)

You can create your CSV using Excel, Google Sheets or similar tools.

Save your file as a CSV (UTF-8) file to avoid issues.

Step 2 - Use the Shopify CSV format

Shopify expects your CSV file to follow a specific format.

This means the column names and structure must match what Shopify uses.

The easiest way to get this right is to export your existing products from Shopify and use that file as a template.

This helps you:

  • Use the correct column names
  • Include all required fields
  • Avoid import errors

If you want to understand the format in more detail, see Shopify CSV format explained.

Step 3 - Import your CSV in Shopify

Once your CSV file is ready:

  • Go to Products in your Shopify admin
  • Click Import
  • Upload your CSV file
  • Start the import

Shopify will process your file and create or update your products.

Step 4 - Review your imported products

After the import finishes, check your products:

  • Are titles and descriptions correct?
  • Are prices correct?
  • Do variants look right?
  • Are images showing?

If something is wrong, it is usually caused by a small mistake in the CSV file.

Common issues with Shopify CSV imports

Small CSV mistakes can cause problems.

Common issues include:

  • Missing columns
  • Wrong column names
  • Incorrect variant setup
  • Image links not working

If your import fails, check your CSV file first.

One common issue is with barcodes (EAN or ISBN).

Spreadsheet tools like Excel or Google Sheets may change long numbers into scientific notation.

For example:

  • 8712345678901 → 8.71235E+12

If this happens, the barcode becomes incorrect and may not import properly.

To avoid this:

  • Format the column as Text before pasting values
  • Or add an apostrophe before the number (for example: '8712345678901)

For a full list of problems and fixes, see Fix Shopify CSV import errors.

When Shopify’s built-in import is enough

Shopify’s built-in CSV import works well if:

  • You have a small number of products
  • Your CSV already matches Shopify’s format
  • You only need to import once

In these cases, you may not need an app.

When to use a CSV import app

If you work with larger product lists or update products often, a CSV import app can save time.

The Simple CSV Shopify app is built for product imports and updates.

It can help you:

  • Import products and variants with their images
  • Update existing products and inventory
  • Use ready-made CSV templates (empty or based on your store)
  • Schedule automatic imports from a file URL on Pro and Scale

After Mapping, open Choose products. On Pro and Scale, including trials, set conditions on file columns to import or update only matching products. Free continues with the whole file. Unselected products stay unchanged. While conditions are set, out-of-feed cleanup is disabled. Then continue to AI Rewrite and Preview.

The preview catches mapping mistakes before the data reaches your store.

If AI Rewrite rewrites the first product’s title, description or product type, Preview offers Show original text. It switches all three fields to the source text for comparison. The import still publishes rewritten copy. Choose Show rewritten text to switch back. The button is hidden when none of these fields were rewritten. To import your source text, return to AI Rewrite and skip or change that step.

When an Import or Update uses AI Rewrite, its status page lists the fields being rewritten, target language and tone. It confirms brand voice and protected terms when set, without showing your answers or terms. Reload the page after the run finishes to see “were rewritten” instead of “are being rewritten”. When rewriting starts, the activity log adds one Info line with the same summary. Individual product lines do not list rewritten fields. With AI Rewrite off, neither the section nor the summary line appears.

With AI Rewrite on, Full file dry run rewrites only the first 5 data rows. Remaining rows keep their source text. The whole file is still checked without changing Shopify. The status section and log summary explain this limit.

In Simple CSV, Full file dry run checks the whole file without changing Shopify. On Pro and Scale, Run first 100 rows makes real Shopify changes for a small portion, including complete products at the cutoff. This is separate from Free’s file limit. Read how to use a limited live run and avoid duplicates.

Common questions

Do I need a CSV template?
No, but it helps a lot. A template makes sure your file is correct.

Can I update existing products?
Yes. If the handle is the same, Shopify will update the product instead of creating a new one.

Why did my import fail?
Most of the time, this is caused by a small mistake in the CSV file.

Can I import images?
Yes. You can add image links (URLs) in your CSV file.

Run a small test

Start with a CSV containing five rows and check every imported product.

If your source columns do not match Shopify’s format, the Simple CSV Shopify app can map them before import.

For the full native workflow, including product fields, variants, inventory, metafields and error fixes, read the Shopify product CSV field and troubleshooting guide.