Migrate Products from Magento to Shopify

Migrate Products from Magento to Shopify

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.

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 from Magento to Shopify:

  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

Step 1: Export your Products from Magento to CSV file using the standard Magento CSV export

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.

Step 2: Give the file name such that it contains the word “Magento” and a word “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

Step 3: Upload to the Excelify app

Upload-exported-Magento-CSV-file-to-start-Shopify-import-products

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.

Step 4: Fill in your Magento URL in the text box

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.

Step 5: Under Options, choose “Dry run” – to not import just yet

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.

Step 6: Download Import Results file and check that all Products and Smart Collections are as you need them

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

Dry run Magento CSV to Shopify conversion finished - download converted fileYou will have the Excel file like this with two sheets (tabs) in it:

  • Products
  • Smart Collections

Products sheet:

Magento converted Products to Shopify import format

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.

Smart Collections sheet:

Magento converted categories to Shopify automated collections importAs 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.

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.

Step 7: Import that 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:

Importing Magento Products to Shopify

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.

Step 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?