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:
- Export your Products from Magento to CSV file using the standard Magento CSV export.
- Give the file name such that it contains the word “Magento” and a word “Products“, e.g. “Magento_Products-2018-11-08.csv”.
- Upload to the Excelify app.
- Fill in your Magento URL in the text box – so that we can migrate your images from Magento to Shopify.
- Under Options, choose “Dry run” – to not import just yet.
- Download Import Results file and check that all Products and Smart Collections are as you need them.
- Make any other corrections you need.
- Import that corrected Excel file.
- 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:
1: Export your Products from Magento to CSV
Log in to your Magento Admin Panel:
Go to menu: System -> Import/Export -> Export
In the Export Settings choose:
- Entity Type: Products
- Export File Format: CSV
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:
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:
3: Upload to the Excelify app
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:
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:
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 Products and Smart Collections
After the Dry run is finished, download the “Import Results” file:
- Smart Collections
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.
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 product “url_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.
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
Smart Collections sheet:
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.
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:
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.
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.