Start Free Trial
Start Free Trial

Migrate Products from Lightspeed C-Series to Shopify

|1 - Export Lightspeed Products|1.1 - Export Lightspeed Products - download exported file|2 - rename your lightspeed exported file|3.1 - upload file to the Excelify app see import details|3.1 - upload file to the Excelify app see import details|4 - select dry-run and import file||5 - downlaod generated excel file|6 - make corrections to the excel file lightspeed products csv|7 - import Lightspeed products into Shopify excel csv Excelify|7 - import Lightspeed products into Shopify excel csv Excelify|8 - migrated Lightspeed products in the Shopify|8 - migrated Lightspeed products in the Shopify

In this tutorial, we will look into how you can easily migrate your Products from Lightspeed to Shopify.

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.

Steps to migrate your Products:

  1. Export your Products from Lightspeed admin.
  2. Rename the exported CSV file name to contain words “lightspeed” and “products“, e.g.”lightspeed-products-export-2019-09-11-11-11-02.csv”.
  3. Upload the file to Matrixify app.
  4. Select “Dry-run” option to generate Matrixify template file.
  5. Download the dry-run generated file.
  6. Double-check the data and make your corrections.
  7. Upload and Import corrected Excel file into Matrixify app.
  8. Enjoy your Lightspeed Products in the Shopify.

Now let’s go thru each step in detail.

1. Export Products from Lightspeed

Exporting from Lightspeed is quite easy.

You will need to go into your Lightspeed Admin -> Tools -> Export.

Here you can click on “Add Export” button to create new export.

1 - Export Lightspeed Products

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

1.1 - Export Lightspeed Products - download exported file

2. Rename the exported file

Once the CSV file is downloaded you can rename the file name to include words “Lightspeed” and “Products” – so that Matrixify knows those are Lightspeed Products.

By default, the exported file will have a similar name like this – “products-export-2019-09-11-11-18-42.csv”. You can just add the word “Lightspeed” to the file name, e.g. “lightspeed-products-export-2019-09-11-11-18-42.csv”.

2 - rename your lightspeed exported file

3. Upload the file to Matrixify app

Now you can go into the Matrixify app and in the home page of the app, you can find the “Import” section.

To upload your file you just need to click on “Add file” button and select the file from your computer, or you can drag and drop the file into the “Import” section.

Import Section Matrixify

As soon as you have selected the file, the app will upload it to our servers and start analyzing it.

If the Lightspeed file has been exported and renamed correctly, then you should see that the app recognizes the file as “Lightspeed” format and the “Sheets” section shows that you are importing “Products“.

Lightspeed Products Import page

4. Select “Dry-run” option

In this same page, you can see the “Options” section for the import.

You only need to select “Dry-run” checkbox – if you want to touch the data before actually importing it to your Shopify store.

This will make sure that the app only generates the Matrixify template “Products” Excel file with the data that you can easily edit and inspect.

Once “Options” looks good, you can press the “Import” button. Items will not yet be imported as the app only generated the Matrixify template file.
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.

You can also see the progress of the “dry-run” import on this page.

Options Sections with dry-run arrow

5. Download generated file

Once the import has been finished you can download the “Import Results” file, which is the “dry-run” generated file.

Press the “Download Import Results” button to download the file.

Lightspeed Products dry-run Import Completed

6. Make your corrections

In this Excel file, you can now easily look over the data. You may wish to clean up some Titles, SKUs or other data of the file.

All fields that do not have a specific place in the Shopify will be set as Metafields in the generated file. You can look into Shopify manual on the Metafields and also save our tutorial on how to bulk manage Metafields if you need to edit them later in bulk.

The app will also bring over images for the Product and create Shopify Custom Collections (manual collections) based on the categories that products are in.

6 - make corrections to the excel file lightspeed products csv

7. Upload and import Products file

Now you can head back to the Matrixify app and again in the “Import” section upload the file.
Once analyzed you can click on the “Import” button to import the file without the “dry-run” option.

Since now you are uploading and importing Matrixify template Products file, then the app will not say that is importing “Lightspeed” format, but that you are importing “Matrixify” format.

Completed Lightspeed Products Import

8. Enjoy your migrated Products

After finishing the import can go into your Shopify Admin and enjoy your migrated Products.

Check also Collections that have been created with the Products in them!

Good to know