StoreSync logo StoreSync
CSV Import

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.

Built for Shopify CSV & XLSX import
01
Quick answer

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.

StoreSync File Import upload step with Upload File and Google Sheets URL options, a CSV or XLSX drop zone (max 50 MB) and the required data format rules
The upload step lists the required data format and offers sample CSVs to download.
02
Overview

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.

03
Workflow

How Shopify CSV Import Works

Before your data reaches your Shopify store, you can review the import workflow and identify problematic data.

  1. 1

    Upload

    Upload your CSV file to StoreSync.

  2. 2

    Map

    Connect spreadsheet columns to Shopify fields.

  3. 3

    Validate

    Catch data issues before they become store problems.

  4. 4

    Preview

    Review your data before importing.

  5. 5

    Import

    Apply your data to Shopify.

StoreSync's current product supports row-level validation and import/export history.

04
Workflow

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.

05
Workflow

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.

06
Example

File format rules and sample files

  • The first row must be a header row, and column names are case-sensitive.
  • handle and resource_type columns are required.
  • Metafield columns use namespace.key format, for example custom.subtitle.
  • Booleans are true or false (lowercase); dates use YYYY-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.

StoreSync History showing import and export jobs, filters for imports, exports, completed and failed jobs, and an import summary with successful and failed row counts
Every import is recorded in History with its successful and failed rows.
07
FAQ

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.