The four rules that cover most of it
Every Magento migration we have seen comes down to these four adjustments:
Common Scenarios:
- Lowercase headers: name, sku, price and qty are valid values but Shopify's importer expects Title, Variant SKU, Variant Price and Variant Inventory Qty.
- Semicolon images: Magento separates image URLs with semicolons; Shopify wants commas in a single Image Src column.
- Configurable products: the parent record and its simple variants must be joined into parent-child rows.
- Weight and dimensions: Magento exports weight as a string with units; Shopify needs a plain number in Grams.
Fix headers and joins locally
ShopTools renames Magento's lowercase headers, converts semicolon-separated images to commas and flags configurable products that still need joining - in the browser, with no upload.
Features:
- Lowercase header map: name/sku/price/qty renamed to Shopify columns
- Image separator fix: Semicolon-separated paths become comma-separated URLs
- Weight cleanup: Unit strings converted to plain numbers for Grams