Get Excelify now
Get Excelify now

Migrate Products from Magento to Shopify

Migrate Products from Magento to Shopify|Magento 1.9 Admin Panel Login to export to Shopify|Magento 1.9 menu to export to CSV for Shopify migration|Magento 1.9 Export Settings Products to CSV|Enter Magento store URL to migrate images to Shopify|Dry run conversion from Magento CSV to Shopify|Dry run convert from Magento CSV to Shopify|Dry run Magento CSV to Shopify conversion finished - download converted file|Magento store sample to migrate to Shopify|Magento converted Products to Shopify import format|Magento converted categories to Shopify automated collections import|Importing Magento Products to Shopify|Migrated Products from Magento to Shopify|Upload-exported-Magento-CSV-file-to-start-Shopify-import-products

The Excelify app makes your migration from Magento to Shopify easier. This import will convert your Magento Products into Shopify Products and put them into Smart Collections.
The app will also automatically create Redirects for your Products and Collections from the old Magento URL to the new Shopify URL.
All your exported Magento Custom fields for the Products will be created as Metafields for your Shopify Products.

While the tutorial is demonstrated on the Magento 1.9, this migration works with Magento 1.x and Magento 2.x versions the same way.

Without bragging, let’s just see how you can take your Magento Products data file and get it into Shopify.

Quick summary to migrate your Products

  1. Export your Products from Magento to CSV file using the standard Magento CSV export.
  2. Give the file name such that it contains the word “Magento” and a word “Products“, e.g. “Magento_Products-2018-11-08.csv”.
  3. Upload to the Excelify app.
  4. Fill in your Magento URL in the text box – so that we can migrate your images from Magento to Shopify.
  5. Under Options, choose “Dry run” – to not import just yet.
  6. Download Import Results file and check that all Products and Smart Collections are as you need them.
  7. Make any other corrections you need.
  8. Import that corrected Excel file.
  9. See your Magento Products and Smart Collections in Shopify.

Now let’s go thoroughly through each step to do that migration.

In this tutorial, we will work with the Magento sample data store with all the default settings in it:

Magento store sample to migrate to Shopify

1: Export your Products from Magento to CSV

Log in to your Magento Admin Panel:

Magento 1.9 Admin Panel Login to export to Shopify

Go to menu: System -> Import/Export -> Export

Magento 1.9 menu to export to CSV for Shopify migration

In the Export Settings choose:

  • Entity Type: Products
  • Export File Format: CSV

Magento 1.9 Export Settings Products to CSVNo need to fiddle with any of the other checkboxes.

Press the Continue button at the bottom of the page.

This will download your all Magento Products as a CSV file.

2: Rename the file to contain the words “Magento” and “Products”

When you download your exported CSV file from Magento, it will be called something like this:

catalog_product_20181108_015149.csv

For Excelify to know that this is Magento file, you need to change that file name so that it contains “magento” and “products”. For example:

magento_products_20181108_015149.csv

3: Upload to the Excelify app

Import Magento products category collections redirects migration shopify csv excel Excelify

Right away, after Excelify analyzed the file, you will see how many “Products” and “Smart Collections” are found in that file.

Note that it should say that it recognized the file as the “Format: Magento CSV

The Smart Collections are the Categories which will get converted to Automated Collections in your new Shopify store.

4: Fill in your Magento URL

See, there is a text box “Magento shop URL” – enter your current Magento store main domain name. For example:

https://yourstore.com

Enter Magento store URL to migrate images to Shopify

This will allow the app to generate full image links from your Magento store and when importing, your product images will get migrated to Shopify products.

That will work, assuming that you haven’t changed the media folder in Magento to anything different.

If you have your media location changed to something else, no worries – you will be able to adjust those image paths in your Excel file before actually importing those products to Shopify.

If you don’t enter anything here, that’s also ok – still, in the generated Excel file you will see columns “Image File” and “Image Path” as they are on your Magento server, and you will be able to construct your own “Image Src” column values precisely to point to the URLs where your images are located.

5: Under Options, choose “Dry run”

If you want to import without adjusting anything, you can skip this step.

We suggest you to first do the Dry run and check your import file – clean up the data and then do the actual import.

To set the Dry run, click on the Options button, and check the “Dry run” checkbox:

Dry run convert from Magento CSV to Shopify

Doing the Dry run will just run through the file conversion process and will generate you the “Import Results” file in the Excelify format – as if you imported it, but it will not actually import anything just yet.

Don’t worry about the time estimate here – that is shown approximate time it would take to actually import them, but the dry run will take just a few seconds.Upload-exported-Magento-CSV-file-to-start-Shopify-import-products

Press the “Import” button.

6: Download Import Results file and double-check the sheets

After the Dry run is finished, download the “Import Results” file:

Dry run Magento CSV to Shopify conversion finished - download converted file

If you have less than 1 000 000 rows in the file then the app will return Excel XLSX file, if you have more rows then it will return ZIP file with CSV files in it.
This is because due to Excel limitations, files over 1 million rows are returned broken.

You will have the Excel/CSV file like this with three sheets (tabs) in it:

  • Products
  • Smart Collections
  • Redirects

Products sheet

Magento Excelify Excel products sheet Shopify migration

Here you can see, review and change any of the values in that Excel file. Any image links in the “Image Src” column, Options for Variants, prices, etc.

Product Handle

By default, the Handle is generated from the Magento parent product SKU because this is the only field which is guaranteed to be unique in Magento.

In the converted Excel file, you have the “Magento Key” column which is taken from the Magento parent producturl_key“. That one is not guaranteed to be unique, but you can still use it for the Handle in Shopify. To use url_key as Handle, copy the “Magento Key” column values into the “Handle” column values.

Tags

Note the “Tags” column – those contain the categories from your Magento store. They are in the format with _ (underscore) because some Shopify Themes recognize those as group filters which will result in nice Category filters.

The same Tags are used in the automated collections to fetch products into those Collections.

Additional Product Fields

There are, of course, more fields you can import for the Products – for that, please, look into the Excelify template or read the Products fields documentation.

Inventory Quantity

In Magento exported file a field “manage_stock” tells the app if we should set stock or not in the Shopify after migration.

If “manage_stock” will have been “1” (true) then:

  • Variant Inventory Qty will be set to quantity as listed in the Magento exported file
  • Variant Inventory Tracker will be set to “shopify” so Shopify tracks inventory

If “manage_stock” will have been “0” (false) then:

  • Variant Inventory Qty and Variant Inventory Tracker will not be set
  • Just so you do not lose the information, the quantity from Magneto will be set in metafield – “Variant Metafield: magento.quantity” if needed you can use quantity listed in this column to set it for your items

Smart Collections sheet

Magento Excelify Excel collections category sheet Shopify migration

As you can see, there are all the same Categories which you had in Magento, converted to the Shopify automated collections – with rules to automatically include the right products by their Tags.

This will produce the result where all the Magento products will be in the same Shopify Collections as they were in Magento categories.

The same as with Products sheet – you can change anything you like here. Also, there are more fields you can import for the Smart Collections – for that, please, look into the Excelify template or read the Smart Collections fields documentation.

Redirects sheet

Magento Excelify Excel redirects sheet Shopify migration

Since Shopify has different URL construction for Products and Collections than Magento, then the Excelify will have generated URL Redirects for your Shopify store.

In the “Redirects” sheet you will see columns “Path” which would be old URL and “Target” indicating a new target URL.
You can find a detailed explanation of each column in our Redirects sheet documentation.

You will have Redirect for:

  • old product URL to new product URL
  • old collections URL to the new one
  • each collection/product combination to the new URL for the collections that each product is in

If you are editing Product or Collection Handles in the dry-run generated file for migrated items to have different Handles than originally in Magento, then you would also need to update the Redirects.

If you do wish to update Handles, then we would suggest first importing Products, Collections with the Handles as generated, so you do not need to manually edit the Redirects.
Once data is migrated you can follow our tutorial on “How to bulk update Handles” to update them after the migration.
The benefit here is that, by default, when updating Handles for in Shopify existing Products or Collections, the app will automatically generate Redirects.

Read more about Redirects in your Shopify here.

Conversion comments

In each sheet there is a column “Conversion Comments” – the app writes there any comments it wants to tell you if there was something worth your attention during the Magento file converstion process.

7: Import updated Excel file

Take the Excel file which you have updated and prepared for the import, and upload it again to the Excelify app.

And just press the “Import” button.

Wait for the import to run:

Import magento products collection category in Shopify excelify csv excel

If you see any Failed items, then after the import has finished, you can again download the Import Results file and look into the “Import Comment” column. It will tell why the particular product failed. Then you can fix that issue and re-import just those failed and fixed rows again.

You can close the app and/or browser once the import is started and while it is running as everything is happening in our servers.

On the app Home page, you can see the last 5 completed or running jobs. You can click on the job to open it and see more details.

Import Magento products category collections redirects migration shopify csv excel Excelif Home pagey

You can also go into “All Jobs” page of the app to see all your future (scheduled), running and past jobs where you also can click on them to see more details.

Shopify Excelify import schedule magento migration products collections category redirects

8: See your Magento Products and Smart Collections in Shopify

Open your Shopify store page and prepare to be silent or loud – depending on how expressive you are.

Migrated Products from Magento to Shopify

Where to go from here?