Fields that silently break the import
These are the columns that look fine in Excel and break in Shopify:
Common Scenarios:
- Parent linkage: without re-attaching variation rows to their product, Shopify imports them as orphaned products.
- Regular price vs Variant Price: WooCommerce uses two price columns; Shopify's importer reads Variant Price and Compare At Price.
- Stock fields: Stock (numeric), Stock status (instock/outofstock) and Backorders need to collapse into one Variant Inventory Qty column.
Join and map in the browser
ShopTools converts WooCommerce product and variation files into one Shopify-ready CSV - parent-child rows rebuilt, prices and stock collapsed into the columns Shopify reads. All local, no upload.
Features:
- Product-variation join: Two WooCommerce files become one Shopify CSV
- Price field collapse: Regular/Sale price map to Variant/Compare At Price
- Stock normalization: Stock, status and backorders collapse to inventory qty
The safe mapping sequence
- Join the product and variation exports using the Parent column.
- Map Regular price to Variant Price and Sale price to Compare At Price.
- Merge Images into one comma-separated Image Src column.
- Map Stock to Variant Inventory Qty and drop Stock status and Backorders.
Before and after
- Before: WooCommerce: Type=variation, Parent=123, Regular price=29.00, Stock=15 After: Shopify: Handle=product-123, Variant Price=29.00, Variant Inventory Qty=15
- Before: Images: https://cdn.com/1.jpg, https://cdn.com/2.jpg (already one column) After: Image Src: same value, valid for Shopify
Who needs this map
- WooCommerce stores leaving WordPress: Keep products, variants and inventory in the move
- Agencies migrating clients: Repeatable, correct conversions across stores
Frequently Asked Questions (FAQ)
- Does WooCommerce export one file or two?
- Two: products and variations, linked by a Parent column. You must join them or the variations import as separate products.
- What happens to Sale price?
- Map it to Compare At Price so the strikethrough shows on Shopify, or drop the column if you do not use sales.
- Can I keep categories and tags?
- Categories can be mapped to a Tags column (semicolon-separated); WooCommerce tags have no direct Shopify CSV column.
- Is the conversion really local?
- Yes. Everything runs in your browser and the converted CSV downloads directly - nothing is uploaded.