StoreSync logo StoreSync
Product Import

Import Shopify Products in Bulk

Upload product data from CSV or Excel and add or update products without manually entering every product in Shopify. StoreSync simplifies large Shopify product imports with field mapping and validation. Each row is matched to a product by its handle, so existing products are updated and new handles create new products. Variants, images, tags, inventory and metafield columns can all go in one file of up to 50 MB.

Built for Shopify CSV & XLSX import
01
Quick answer

How do I import products into Shopify from a CSV or Excel file?

Open File Import in StoreSync and upload a CSV or XLSX file (up to 50 MB). Map your columns to Shopify product fields and metafields, review the preview, then import.

Each row is matched to a product by handle: existing products are updated, and new handles create new products. Variants come from the Option and Variant columns (SKU, price, compare-at price, barcode, weight, image and inventory quantity).

StoreSync File Import: three steps (Upload, Map Columns, Preview), a drop zone for CSV or XLSX files up to 50 MB, and the required data format table
File Import walks through upload, column mapping and a preview before anything reaches your store.
02
Overview

The Problem

Adding hundreds or thousands of products manually can take days. Common problems include:

  • Incorrect product fields
  • Missing information
  • Spreadsheet formatting issues
  • Duplicate data
  • Manual entry errors
  • Difficult updates
03
Workflow

A Simpler Product Import Workflow

StoreSync guides you through a structured four-step import process.

  1. 1

    Upload

    Upload your CSV or XLSX file.

  2. 2

    Map

    Map spreadsheet columns to Shopify fields.

  3. 3

    Validate

    Review your data before importing.

  4. 4

    Import

    Apply your product data to Shopify.

CSV and XLSX imports are available on every plan (the Free plan has import limits). Unlimited imports and automatic field mapping start on the Basic plan ($19/month).

04
Workflow

What Can You Import?

Depending on your workflow, you can work with:

Products & Variants

Products, variants, prices, SKUs, and barcodes.

Inventory & Tags

Inventory levels and tags. To assign products to collections, use the Collection Products column in a collections file.

Metafields

Custom structured product information and metafields.

Images & Pages

Product images and Shopify pages.

05
Workflow

Best For

StoreSync's product import is ideal for these scenarios.

New Shopify Stores

Quickly populate a new store without manual data entry.

Catalog Migrations

Move products from another platform or system into Shopify.

Supplier Product Uploads

Import supplier spreadsheets directly into your store.

Large Catalog Updates

Apply bulk changes to existing product data via spreadsheet.

Agencies & B2B

Handle client catalog imports and B2B product data efficiently.

06
Example

Example: a product import file

This is the product sample file. custom.subtitle is a product metafield column:

handle,resource_type,Title,Body (HTML),Vendor,Type,Tags,Published,Variant SKU,Variant Price,Image Src,custom.subtitle
heritage-wool-coat,products,Heritage Wool Coat,<p>Classic winter coat crafted from heritage wool.</p>,Acme Apparel,Outerwear,"winter,coats",true,COAT-001,249.00,https://cdn.shopify.com/…/sample-image-1.jpg,Classic winter coat
canvas-tote-bag,products,Canvas Tote Bag,<p>Durable everyday canvas tote.</p>,Acme Apparel,Bags,"bags,everyday",true,TOTE-001,39.00,https://cdn.shopify.com/…/sample-image-2.jpg,Everyday essential

Download the product sample CSV to start from a file that already has the right headers.

StoreSync History: list of import jobs with status and progress, and an import summary showing 37 records, 36 successful and 1 failed, with an Export Results button
After the import, History shows successful and failed rows. Export the results to fix failed rows and re-import them.
07
FAQ

Frequently asked questions

Does StoreSync update existing products or create new ones?

Both. Each row is matched to a product by its handle: existing products are updated, and a handle that does not exist yet creates a new product. Empty cells are skipped, so they never overwrite existing values.

Which file formats and sizes can I import?

CSV and XLSX files up to 50 MB. On the Pro plan you can also import from a Google Sheet shared as Anyone with the link → Viewer.

How many products can I import for free?

The Free plan includes up to 50 product and file imports and unlimited metafield imports. The Basic plan ($19/month) makes product imports and exports unlimited and adds automatic field mapping.

What happens if some rows fail?

The import continues and History shows how many rows succeeded and failed. Export the failed rows, fix them and import just those rows again. Each failed row lists the reason, such as a malformed JSON value or a wrong date format.

Ready to Import Your Catalog?

Upload your spreadsheet and let StoreSync handle the bulk work.