Shopify Products CSV Mapper — SchemaMap

Quick Start

Skip the reading and start mapping your CSV right now:

Try Sample Products CSV

Step-by-step process

1. Export your CSV or prepare your source file

You can map any CSV with product data. Common sources include:

  • Existing Shopify export (Products → Export → CSV)
  • Inventory management system export
  • Supplier product catalogs
  • Manual spreadsheets

💡 Pro tip

Don't have a CSV to test? Download our sample file:

Download sample CSV

2. Open the mapper

Open the Shopify Products mapper and upload your CSV. The tool will:

  • Parse your file in the browser (never uploaded to our servers)
  • Auto-detect column mappings using smart fuzzy matching
  • Show you a preview of mapped fields

3. Check the auto-mapped fields; fix any unmapped ones

Review the mapping table. Required fields are highlighted in red if unmapped. Common mappings our tool recognizes:

Target FieldCommon Source Names
Titlename, product title, product name
Handleslug, url handle, product handle
Variant SKUsku, product sku
Variant Priceprice, cost, amount

4. Review errors (price not numeric, missing SKU)

The validator will check for common issues:

  • Required fields missing: Title, Handle, Status, Published, Variant SKU, Variant Price
  • Invalid status: Must be 'active', 'draft', or 'archived'
  • Invalid published value: Must be 'TRUE' or 'FALSE'
  • Non-numeric price: Prices must be numbers ≥ 0
  • Invalid inventory policy: Must be 'deny' or 'continue'

⚠️ Common fixes

  • TRUE/FALSE required for Published. Convert yes/no, 1/0, or similar values.
  • Status must be active/draft/archived. Map from published/unpublished or similar.
  • Remove currency symbols from price fields ($, €, etc.)
  • Handle should be URL-friendly (lowercase, hyphens instead of spaces)

5. Download the validated CSV and import to Shopify

Once validation passes, download your clean CSV. You can then:

  • Import directly to Shopify via Products → Import
  • Use it with other e-commerce platforms
  • Save the mapping.json file to reuse with similar data

Advanced usage

Save and reuse mappings

If you regularly import similar CSV files, download the mapping.json file. You can then use our CLI tool for automated processing:

schemamap map --schema shopify-products --mapping mapping.json < input.csv > output.csv

Bulk processing

For files larger than 2,000 rows, use the CLI tool which has no size limits and processes files locally.

Need help?

Check out these community discussions about Shopify CSV import issues: