Migration guide

Import Magento Products to Shopify

Magento 2 (Adobe Commerce) exports products with one row per SKU and configurable products linked by a configurable_variations column. Rebuild those links as Shopify variants and the rest maps cleanly.

1. Export your products from Magento

  1. In Magento admin, go to System → Data Transfer → Export.
  2. Set Entity Type to Products and the file format to CSV.
  3. Click Continue. Magento generates the file in the background. Download it from the export grid.

2. Map Magento columns to Shopify

Shopify's importer only reads its own column names. Copy each Magento column into the matching column of the Shopify product CSV template.

Magento → Shopify CSV column mapping
Magento columnShopify columnNote
url_keyHandleKeep it so redirects are simple
nameTitle
descriptionBody (HTML)
skuVariant SKU
priceVariant PriceOr Compare At when special_price is set
special_priceVariant PriceMove price to Compare At
qtyVariant Inventory Qty
weightVariant GramsConvert to grams
configurable_variationsRows with the same HandleOne row per child SKU
configurable_variation_labelsOption1 Name, Option2 Name…
base_image + additional_imagesImage SrcFull URLs, one row per image
meta_title / meta_descriptionSEO Title / SEO Description
product_online (1 / 2)Status (active / draft)
categoriesTags or Product Category

3. Import the file into Shopify

  1. Remove simple products that are only children of configurable products. They become variant rows instead.
  2. Turn each configurable product into one Shopify product with a row per child SKU.
  3. Prefix image paths with your media URL so Shopify can download them.
  4. Check the file, then import it under Products → Import.
  5. Add 301 redirects from each Magento URL (often ending in .html) to /products/{handle}.

4. Common Magento migration problems

  • Image columns hold paths relative to your media folder, such as /m/u/mug.jpg. Add your store's media URL in front.
  • Child simple products in Magento must not be imported as separate Shopify products.
  • Magento attributes beyond three variant options need to become tags or metafields.

FAQ

Magento to Shopify: FAQ

Still stuck? Email contact@ecomfusion.net.

Can 1Click migrate Magento products?

No. 1Click imports from Amazon, AliExpress, eBay and Shopify stores you manage. Use the Magento export and Shopify's CSV import.

How do configurable products map to Shopify?

Each configurable product becomes one Shopify product. Each of its child SKUs becomes a variant row with the same Handle, and the configurable attributes become Option1, Option2 and Option3.

Keep adding products after you move

1Click imports from Amazon, AliExpress, eBay and your other Shopify stores, with AI rewriting. Free for 3 imports.