Quick Rule Summary · Updated November 2026

Magento 2 exports list child simple SKUs above or separately from their parent configurable row and pack option bindings inside configurable_variations (sku=...,color=...,size=...): before importing into Shopify, overwrite child handles with the parent’s url_key, prepend https://<domain>/pub/media/catalog/product to relative image paths, and drop expired special_price values.

01 / INTERACTIVE MAGENTO-2-TO-SHOPIFY CONVERTERUnpack pipe-delimited configurable_variations, prefix media URLs & check special_price dates.

Click any Magento 2 export scenario below—or open the live field drawer to paste your own configurable_variations string and media domain—and download a clean UTF-8 Shopify CSV:

Source Rows Inside Magento 2 System → Export (.csv)
Paste your own Magento configurable_variations & domain (live converter)

02 / THE 4 MAGENTO 2 CSV TRAPSWhy raw Magento System → Export files corrupt Shopify catalogs.

  1. Child simple rows precede the parent configurable row with unique url_key slugs: Magento exports child SKUs (visibility = Not Visible Individually) with individual url_key values like alpine-boots-black-42, and only declares their relationship at the bottom inside the parent’s pipe-separated configurable_variations column! You must rewrite child handles to match the parent’s url_key and delete the standalone container row.
  2. Relative /a/b/filename.jpg image paths: Magento’s base_image and comma-separated additional_images omit your domain and media folder. Prepend https://your-magento-store.com/pub/media/catalog/product (or /media/catalog/product on Nginx roots configured inside pub/) so Shopify’s importer can fetch every photo (see multi-image continuation rows).
  3. Expired special_price values still sitting in the database: Magento leaves historical special_price numbers populated forever after special_to_date passes. If you map special_price without checking special_to_date, 3-year-old Black Friday discounts suddenly reactivate across your Shopify store (see sale & compare-at rules)!
  4. Key-value additional_attributes & product_online = 1 / 2: Custom EAV attributes (brand=Salomon,material=Gore-Tex) are packed into one comma-delimited additional_attributes cell, and Magento uses product_online = 2 (not 0 or false) for disabled items!

03 / HEADER DICTIONARYMagento 2 / Adobe Commerce to canonical Shopify column reference.

Mapping Magento 2 Data Transfer Export columns to canonical Shopify product CSV headers
Magento 2 export headerShopify CSV headerRequired transformation
Parent url_keyURL handle (Handle)Copy parent configurable url_key onto all linked child variant and image rows.
Parent nameTitleEmit on Row 1 of each handle; leave blank on child SKU rows 2..N.
descriptionBody (HTML)Strip Magento PageBuilder data-pb-style comments or widget shortcodes ({{media ...}}) if present.
categories (Default Category/Men/Boots)Type / TagsExtract deepest leaf category for Type and map hierarchy segments to Tags.
configurable_variationsOption1..3 name & valueSplit | records, then parse sku=...,color=...,size=... key-value pairs onto each child SKU.
price + active special_pricePrice + Compare-at priceInvert only when special_to_date is empty or in the future; otherwise use price alone.
qty + is_in_stockInventory quantityRound decimal 14.0000 Magento quantities to clean integers (14).
base_image + additional_imagesProduct image URLPrepend full HTTPS /pub/media/catalog/product origin and unpivot extra photos onto shared-handle rows.

04 / SAFE MIGRATION STEPSMigrate Magento 2 to Shopify or Shopify Plus in 4 steps.

  1. Export Products Without Excluding Child Simples: In Magento Admin (System → Data Transfer → Export → Products), export your full UTF-8 CSV while keeping your Magento /pub/media/ CDN online until Shopify finishes downloading images.
  2. Bind Child Simples via configurable_variations & Clean Dates: Group child variants under their parent’s url_key, round .0000 inventory decimals, and drop expired special_price markdowns.
  3. Preflight Up to 50,000 Rows Locally in Row & Record: Open the converted CSV inside our browser-local preflight workspace to catch broken image URLs, duplicate handles, or $0.00 prices before touching Shopify Admin.
  4. Map .html Suffix 301 Redirects: Magento product URLs typically end in .html (/alpine-shell-jacket.html → /products/alpine-shell-jacket)—upload your 301 redirect CSV alongside a 5-product pilot import.

Common questions.

How do I convert Magento 2 configurable_variations into Shopify options?

Split Magento’s configurable_variations cell on the pipe character (|) to get each child variant record, parse the comma-separated key=value pairs (such as sku=BOOT-BLK-9,color=Black,size=9), assign the parent configurable product’s url_key as the shared Shopify Handle, and populate Option1/Option2 on each child SKU row.

Why do Magento 2 image URLs fail to import into Shopify?

Magento exports relative paths like /m/b/merino-hoodie.jpg instead of full HTTPS URLs. Prepend your live store’s media base URL—typically https://yourdomain.com/pub/media/catalog/product (or /media/catalog/product)—and verify the URL loads in an incognito browser tab before importing.

Why does Magento product_online = 2 mean disabled instead of enabled?

In Magento 2 EAV status conventions, product_online = 1 means Enabled and product_online = 2 means Disabled. Map 1 to Shopify Status = active and 2 to Status = draft.

How should I handle Magento qty values formatted as 25.0000?

Magento exports stock quantities with four decimal places (e.g., 25.0000). Convert integer-stocked items to whole numbers (25) before importing into Shopify Variant Inventory Qty.

05 / ENTERPRISE & POS MIGRATION HUBConverting from another platform to Shopify?

Ready to preflight your Magento-2-to-Shopify CSV?

Audit configurable handles, full HTTPS media URLs, and variant prices locally in your browser.

Open CSV Preflight Workspace ↗

Verified November 2026 against Magento 2 / Adobe Commerce Data Transfer Product CSV schema and Shopify’s multi-variant Product CSV specification.

Shopify enterprise migration documentationShopify product CSV column referenceRow & Record Chrome Extension ↗