Why native imports fail
Almost every failed native import traces back to one of these file issues:
Common Scenarios:
- Header row is missing columns or has renamed columns.
- Price cells contain currency symbols, commas or spaces.
- Variant rows have SKUs that already exist in the store.
- Image URLs are broken, start with http instead of https, or end in thumbnail suffixes.
Make the native importer work the first time
ShopTools validates the exact format the native importer expects: headers, prices, SKUs, option pairs, image URLs and encoding. Fix the file before upload and you can import products without installing anything.
Features:
- Native-format validation: Checks against Shopify's 51-column schema
- Auto-repair: Fixes quotes, encoding, price formats and duplicate SKUs
- No app required: Use Shopify's free built-in importer
Step-by-step: import without an app
- Build or export a CSV using Shopify's 51-column product template.
- Fill in your products, variants, prices, SKUs and image URLs.
- Run the file through the ShopTools validator and repair any flagged issues.
- In Shopify admin go to Products > All products > Import and upload the repaired CSV.
- Review the import summary email and confirm products, variants and images.
Upload-and-hope vs validate-first
- Before: Upload CSV -> generic error email -> guess the problem -> upload again After: Validate CSV -> fix exact issues -> upload once -> import succeeds
- Before: Currency symbols in price cells -> imports as 0.00 After: Plain numbers -> prices import correctly
Who should use the native importer
- One-time store setups: Free and fast when the file is clean
- Merchants avoiding app bloat: Keep the app list short
Frequently Asked Questions (FAQ)
- Can I really import products without an app?
- Yes - Shopify's native importer is free and built into the admin under Products > All products > Import.
- What file format does Shopify need?
- A CSV file with Shopify's 51-column product header row, UTF-8 encoded, with plain numbers for prices.
- What is the most common reason imports fail?
- File formatting issues: wrong headers, currency symbols in prices, duplicate SKUs or broken image URLs.
- How do I know my file is ready?
- Run it through the ShopTools Shopify CSV validator. It checks the same rules Shopify uses at import time.