Migrate Orders from Magento to Shopify

Migrate Orders from Magento to Shopify

So you decided to migrate your Orders from Magento to Shopify.

This is how you do it using the Excelify app:

  1. Export Orders data tables from the Magento database to CSV files.
  2. Zip those CSV files into one single zip file, and make sure the zip file name includes a word “magento” and “order” in it, like “Magento_Orders.zip”.
  3. Upload that Magento zip file to the Excelify app.
  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.
  5. Download the Import Results Excel file – you will have it in the Excelify Orders template format.
  6. Inspect that file, make any checks and data cleanup or adjustments as you need.
  7. 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 following names:

Table Name (Magento v1.x) Table Name (Magento v2.x)
sales_flat_order.csv sales_order.csv
sales_flat_order_item.csv sales_order_item.csv
sales_flat_order_address.csv sales_order_address.csv
sales_flat_order_payment.csv sales_order_payment.csv
sales_flat_shipment_track.csv sales_shipment_track.csv

CSV file format requirements:

  1. Include column headings.
  2. Column separator: ,
  3. Quotes symbol:
  4. Escape symbol:
  5. Newline symbol: \n
  6. NULL values to be empty.

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”.

Magento Orders import file to Shopify3. 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.

Analyzing Magento Orders import to Shopify

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.

Import Orders from Magento to Shopify - dry runThat 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.

Download import results file after dry run of Shopify Orders import from MagentoThe 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.

Check customer address data, their countries, cities, regions, streets.

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.
  • Read about all the fields you see in the Orders Excelify template Excel file.
  • If you see that some Orders import is showing as Failed, don’t worry – you can downlaod 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 are prepared according to the requirements stated on this tutorial.
  • If you feel stuck with something, our Support is willing to help you – just reach out to us.