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.
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).
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
A Simpler Product Import Workflow
StoreSync guides you through a structured four-step import process.
-
1
Upload
Upload your CSV or XLSX file.
-
2
Map
Map spreadsheet columns to Shopify fields.
-
3
Validate
Review your data before importing.
-
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).
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.
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.
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.
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.