Shopify CSV Import Made Simpler
Import and update Shopify data using CSV without manually entering records one at a time. StoreSync turns spreadsheet data into a streamlined Shopify import workflow: upload a CSV or XLSX file of up to 50 MB, map its columns to Shopify fields and metafields, check the preview and import. It works for products, collections, pages, blog posts, customers, orders, metaobjects, translations and more, and every job is recorded in History.
How do I import a CSV file into Shopify with StoreSync?
Upload the file in File Import, map the columns, check the preview and import. StoreSync accepts CSV and XLSX files up to 50 MB.
Supported resources are products, collections, pages, blog posts, customers, companies, orders, draft orders, discounts, menus, URL redirects, files, metaobjects and translations.
Import Shopify Data From CSV
CSV files are useful for:
- Product catalogs
- Supplier feeds
- Pricing updates
- Inventory data
- Metafields
- Collections
- Catalog migrations
But preparing and importing large CSV files can be difficult. StoreSync helps simplify the process.
How Shopify CSV Import Works
Before your data reaches your Shopify store, you can review the import workflow and identify problematic data.
-
1
Upload
Upload your CSV file to StoreSync.
-
2
Map
Connect spreadsheet columns to Shopify fields.
-
3
Validate
Catch data issues before they become store problems.
-
4
Preview
Review your data before importing.
-
5
Import
Apply your data to Shopify.
StoreSync's current product supports row-level validation and import/export history.
Why Use StoreSync?
Field Mapping
Connect spreadsheet columns to Shopify fields.
Validation
Catch data issues before they become store problems.
Bulk Processing
Work with large amounts of catalog data.
History
Review previous import/export operations and error information.
Use Cases
Supplier Catalog Import
Bring supplier product information into Shopify.
Price Updates
Update thousands of product prices.
Inventory Updates
Import inventory information in bulk.
Catalog Migration
Move structured product information into Shopify.
File format rules and sample files
- The first row must be a header row, and column names are case-sensitive.
handleandresource_typecolumns are required.- Metafield columns use
namespace.keyformat, for examplecustom.subtitle. - Booleans are
trueorfalse(lowercase); dates useYYYY-MM-DD; JSON values must be valid JSON. - Empty cells are skipped, so existing values are kept.
- Importing metaobjects? Import the metaobject entries first so references resolve before you import products, collections or pages.
Start from a sample file with the right headers: products, collections, pages, blog posts, companies, orders, menus, metaobjects, translations, files.
Frequently asked questions
Which columns does a StoreSync import file need?
The first row must be a header row, and column names are case-sensitive. The handle and resource_type columns are required, and each metafield gets its own namespace.key column, for example custom.subtitle.
Will empty cells overwrite my existing data?
No. Empty cells are skipped, so a partial file only changes the fields and metafields you fill in. Export a backup first if you are unsure.
Can I import Excel (XLSX) files as well as CSV?
Yes. File Import accepts CSV and XLSX files up to 50 MB, and the Pro plan can also import from a shared Google Sheet.
In what order should I import metaobjects?
Import metaobject entries first, so their references resolve when you then import the products, collections or pages that use them.
Your Shopify Catalog Starts in a Spreadsheet.
Turn it into a Shopify-ready catalog with StoreSync.