Start Free Trial
Start Free Trial

Migrate Orders from Lightspeed C-Series to Shopify

featured - Migrated Orders Lightspeed to Shopify bulk import export excel csv|1 - Set up Lightspeed Orders export|1.1 - Download Lightspeed exported Orders file|2 - Rename Lightspeed exported Orders file|3 - Excelify import upload file section|3 - Upload Lightspeed Orders CSV file to Shopify using Excelify|4 - Excelify import lightspeed magento dry-run option|5 - Download Excelify Import Resutls file finished job lightspeed|6 - Excelify generated Shopify Lightspeed Orders import migrate file|7 - Disable migration staff order notifications shopify admin

This tutorial will help you to migrate your Lightspeed Orders into Shopify with ease.

Note: This tutorial is for migration from Lightspeed C-Series.
To migrate data from other lightspeed platforms you would need to manually convert your file data to Matrixify template column headers and structure.

Quick summary to migrate your Orders:

  1. Export your Orders from Lightspeed.
  2. Give the file name such that it contains the word “Lightspeed” and a word “Orders“, e.g. “lightspeed-orders-export-2019-08-06-16-29-18.csv”.
  3. Upload to the Matrixify app.
  4. Under Options, choose “Dry run” – to not import just yet.
  5. Download Import Results file and check that all Products look as you need them.
  6. Make your corrections.
  7. Disable staff order notifications in Shopify Admin Settings so that you don’t receive notifications about the newly imported Orders.
  8. Import the finalized Excel file.

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

1. Export your Orders from Lightspeed

To export your Orders from Lightspeed, you would need to go into your Lightspeed store Admin -> Tools -> Exports.
In this page, click on the “Add export” button.

A popup will appear where you can select to export “Orders” and choose a date range to filter what Orders will get exported.

1 - Set up Lightspeed Orders export

Press the “Export” button in the pop-up to start the Export and once completed press the “Download” button to download the file.

Download Lightspeed exported Orders file

2. Rename the exported file

Once you have downloaded the file, you do not need to open and edit it.

Find the file in your computer and rename it to contain words “Lightspeed” and “Orders“.

The simplest way to do so is just to add the word “Lightspeed” at the beginning of the file name.

2 - Rename Lightspeed exported Orders file

3. Upload to the Matrixify app

Now you can go into the Matrixify app and upload the file in the Import section of the app.
You can drag and drop the file in this Import section or click on the “Add File” button to upload the file.

Import Section Matrixify

As soon as you have uploaded the file, the app will open a separate window for this import job where the app will analyze the file.

Make sure that the app recognizes the import as “Lightspeed” format and that you are importing “Orders”.

Lightspeed Orders dry-run Import

4. Select “Dry-run” option

In the Import job view, you also have a lot of different “Options” to select for your imports.
You can leave all the default options selected as they are, and select the option “Dry Run – convert the file and test as far as possible without actually importing anything“.

That will not do any real import just yet – it will 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 Matrixify “Orders” import template format for importing to Shopify.

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.
While the app is generating the data, you are free to close the app and browser. You can later find this job in “All Jobs” page of the app, and you will also receive an e-mail from Matrixify when the file is converted.

Options Sections with dry-run arrow

5. Download Import Results file

When the “dry import” is finished, you will see a green “Import Finished” label with “Download Import Results” button.

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

The file will contain all of the Orders, their customer data, line items, shipping cost, refunds, fulfillments, and financial transaction that the app was able to gather from the Lightspeed exported data.

Lightspeed Orders Import completed dry-run

6. Make any corrections 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.

If you wish to send out a receipt to the customer for some orders, then you can update the column “Send Receipt” to the value TRUE for your orders – but by default, it will not send any e-mails to your customers.

6 - Matrixify generated Shopify Lightspeed Orders import migrate file

7. Disable staff order notifications in Shopify

If you as the store owner don’t want to receive e-mail notifications from Shopify for creating each Order, go to Admin -> Settings -> Notifications, and disable the “Staff order notifications“.

Disable Staff Notifications

8. Import the finalized Excel file

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 Matrixify Import Results file and import that by uploading again using the same Matrixify app import section.
When you have uploaded this file, make sure that “Dry-run” option is no longer selected to actually import the Orders to your Shopify store.

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