Shopify Inventory CSV Mapper — SchemaMap

Step-by-step process

1. Export your inventory CSV or prepare your source file

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

• Existing Shopify inventory export (Products → Export → CSV)
• Warehouse management system exports
• Supplier inventory feeds
• Manual inventory spreadsheets

2. Open the mapper

Open the Shopify Inventory 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:

4. Review errors (negative available quantities, missing SKUs)

The validator will check for common issues:

• Required fields missing: Variant SKU, Available
• Invalid quantities: Available must be numeric (can be negative for adjustments)
• Missing SKUs: Each row must have a variant SKU
• Invalid costs: Cost must be numeric if provided

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 inventory management systems
• 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-inventory --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:

• Reddit: Problems with Product Import CSV
• Stack Overflow: Cannot import .CSV product list to Shopify
• Stack Overflow: Shopify Products Import CSV Validation error invalid file