Step 2: Give the file name such that it contains the word “Magento” and a word “Customers”

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

customer_20181113_142219.csv

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

magento_customers_20181113_142219.csv

Step 3: Upload to the Excelify app

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

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

Step 4: 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:

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.

Press the “Import” button.

Step 5: Download Import Results file and check that all Customers are as you need them

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

You will have the Excel file like this with one sheet (tab) in it: Customers:

Here you can see, review and change any of the values in that Excel file.

Note the “Tags” column – those contain customer information from your Magento store, that does not have special field in the Shopify, for example, Gender:Male, Magento Group:4, etc. This information can be useful, but you also can delete it if it is not needed.

There are also two Metafileds columns: Metafield: dob – that contains customer Date of Birth, and Metafield: vat_id – for VAT. These data is easier to operate with, when it is in the separate columns. Again, you can delete those columns, if it is not needed.

Step 6: 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.

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 Customer failed. Then you can fix that issue and re-import just those failed and fixed rows again.

For example, here the error is: Failed. Phone: is invalid

How you can fix it?

One way is to correct the number in the Excel sheet, if you know, what is the correct one, and import the file again.

Another option is to delete the phone number from the column Address Phone. You can put into column Note, so that it is not lost. And then import the 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

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 v1 Exported 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

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:

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.

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:

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

Products

Smart Collections

Products sheet:

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.

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.

Smart Collections sheet:

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.

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:

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.

Zip those CSV files into one single zip file, and make sure the zip file name includes a word “magento” in it, like “Magento_Orders.zip”.

Upload that Magento zip file to the Excelify app.

When it’s done analyzing, check the checkbox “Dry run” under the Options – to generate the Excelify Excel file but not import just yet.

Download the Import Results Excel file – you will have it in the Excelify Orders template format.

Inspect that file, make any checks and data cleanup or adjustments as you need.

Import the ready Excel file using the Excelify app.

It works if you are migrating from Magento version 1.x. If you need to convert from another version, please, contact us about that.

Each of the steps to migrate Orders from Magento to Shopify in details:

1. Export Orders data tables from the Magento database to CSV files

When you connect to the Magento database, you will see many tables there.

You need to use the database tool to export the following tables with their data to the CSV files – each table goes to its own CSV file with the exact names:

Table Name

Required CSV File Name

sales_flat_order

sales_flat_order.csv

sales_flat_order_item

sales_flat_order_item.csv

sales_flat_order_address

sales_flat_order_address.csv

sales_flat_order_payment

sales_flat_order_payment.csv

sales_flat_shipment_track

sales_flat_shipment_track.csv

2. Zip those CSV files into one single zip file, and make sure the zip file name includes a word “magento” in it, like “Magento_Orders.zip”

Put all those CSV files in the same folder, and give that folder a name, like “magento_orders”. It’s important that the zip file name should include the name “magento” in it. That’s how the app will know you are having the Magento data in that file.

And zip that folder into the zip file, like “magento_orders.zip”.

3. Upload that Magento zip file to the Excelify app

When you will upload that Magento zip file to the Excelify app, you should see that the app recognized it as Magento format, and runs through the Analyzing process to count how many Orders it finds in those files.

4. When it’s done analyzing, check the checkbox “Dry run” under the Options – to generate the Excelify Excel file but not import just yet

Press the “Options” button and click the “Dry run – just generate the Results file without importing” checkbox.

That will not do any real import just yet – it will just run through our data transformation engine to simulate the import, and as a result, you will get the “Import Results” Excel file which is in the Excelify “Orders” import template format.

Press the “Import” button. Don’t worry – if the Dry run is on, there will be no changes done to your shop data just yet.

5. Download the Import Results Excel file – you will have it in the Excelify Orders template format

When the “dry import” is finished, you will see the Download button.

Press it and download the “Import Results” file of your test Orders import – it will be in the Excelify Excel file format.

The file will contain all of the Orders, their customer data, line items, shipping cost, refunds, fulfillments, and financial transactions.

6. Inspect that file, make any checks and data cleanup or adjustments as you need.

You might want to look at the total amounts, check the currencies, transactions.

Maybe improve the data of some of your customers, check that their phone prefixes are correct, as Shopify requires international phone codes for all phone numbers.

Also, you might want to check the totals for line items, and Orders themselves, and the Taxes, tax codes, etc.

You can do all of those changes in the Excel file. Or… in the Magento system, and then re-export that data to CSV files again, and repeat the process until you are satisfied with what you are about to import.

7. Import the ready Excel file using the Excelify app.

Also, you might want to try importing just 1-2 Orders from that file first, to look how they look in Shopify.

Once you feel ready, grab the prepared Excel file and import that by uploading again using the same Excelify app import section.

When importing, be patient – there is a lot of stuff going on under the hood to construct your Orders, so it might take a while to complete, but it should be worth the wait.

Good to know

If you feel like a kamikaze, you can skip the whole “Dry run” part, and just import the Orders zip file directly, without looking at the Excelify Orders format file.

If you see that some Orders import is showing as Failed, don’t worry – you can import the “Import Results” file of that import, and at the last columns you will see the comments for why those failed. Then you can resolve those issues, and re-import just the Failed rows.

If the import speed is important to you, the higher plan you upgrade to, the quicker the import will be, as for example, Enterprise Plan essentially spins off 10 parallel import processes, achieving the effect as if 10 apps would import your data in parallel.

If you have the error like this: “Missing or stray quote in line …” – please, make sure that your CSV files escape the quotes inside the texts as “” not as \”.

If you feel stuck with something, our Support is willing to help you – just reach out to us.

This website uses cookies

We use cookies to analyse our traffic. We share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you’ve provided to them. You consent to our cookies if you continue to use this website. See Cookie Policy here