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:
Paste your own Magento configurable_variations & domain (live converter)
02 / THE 4 MAGENTO 2 CSV TRAPSWhy raw Magento System → Export files corrupt Shopify catalogs.
- Child
simplerows precede the parentconfigurablerow with uniqueurl_keyslugs: Magento exports child SKUs (visibility = Not Visible Individually) with individualurl_keyvalues likealpine-boots-black-42, and only declares their relationship at the bottom inside the parent’s pipe-separatedconfigurable_variationscolumn! You must rewrite child handles to match the parent’surl_keyand delete the standalone container row. - Relative
/a/b/filename.jpgimage paths: Magento’sbase_imageand comma-separatedadditional_imagesomit your domain and media folder. Prependhttps://your-magento-store.com/pub/media/catalog/product(or/media/catalog/producton Nginx roots configured insidepub/) so Shopify’s importer can fetch every photo (see multi-image continuation rows). - Expired
special_pricevalues still sitting in the database: Magento leaves historicalspecial_pricenumbers populated forever afterspecial_to_datepasses. If you mapspecial_pricewithout checkingspecial_to_date, 3-year-old Black Friday discounts suddenly reactivate across your Shopify store (see sale & compare-at rules)! - Key-value
additional_attributes&product_online = 1 / 2: Custom EAV attributes (brand=Salomon,material=Gore-Tex) are packed into one comma-delimitedadditional_attributescell, and Magento usesproduct_online = 2(not0orfalse) for disabled items!
03 / HEADER DICTIONARYMagento 2 / Adobe Commerce to canonical Shopify column reference.
| Magento 2 export header | Shopify CSV header | Required transformation |
|---|---|---|
Parent url_key | URL handle (Handle) | Copy parent configurable url_key onto all linked child variant and image rows. |
Parent name | Title | Emit on Row 1 of each handle; leave blank on child SKU rows 2..N. |
description | Body (HTML) | Strip Magento PageBuilder data-pb-style comments or widget shortcodes ({{media ...}}) if present. |
categories (Default Category/Men/Boots) | Type / Tags | Extract deepest leaf category for Type and map hierarchy segments to Tags. |
configurable_variations | Option1..3 name & value | Split | records, then parse sku=...,color=...,size=... key-value pairs onto each child SKU. |
price + active special_price | Price + Compare-at price | Invert only when special_to_date is empty or in the future; otherwise use price alone. |
qty + is_in_stock | Inventory quantity | Round decimal 14.0000 Magento quantities to clean integers (14). |
base_image + additional_images | Product image URL | Prepend 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.
- 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. - Bind Child Simples via
configurable_variations& Clean Dates: Group child variants under their parent’surl_key, round.0000inventory decimals, and drop expiredspecial_pricemarkdowns. - 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.00prices before touching Shopify Admin. - Map
.htmlSuffix 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?
Item Type = Rule [ADD]/[FIXED] prices and strip [RB]/[CS] tags.
Lightspeed Retail
Lightspeed R/X → Shopify Converter
Group Matrix Description sets and protect leading-zero 12-digit UPC barcodes.
WooCommerce
WooCommerce → Shopify Merger
Invert Regular vs. Sale prices cleanly and separate simple vs. variable rows.
Ready to preflight your Magento-2-to-Shopify CSV?
Audit configurable handles, full HTTPS media URLs, and variant prices locally in your browser.
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 ↗