Migrating from Lightspeed to Shopify

If you're using Lightspeed Retail or Lightspeed eCommerce, then you can migrate your products to Shopify. You need to install your eCom store and export your data from Lightspeed, and then you can import it to Shopify using the Store Importer app.

Step 1: Export your store data from Lightspeed

The first step to migrate your Lightspeed store to Shopify is to export your store data from Lightspeed in CSV format. There are four separate CSV files that you can export:

Before you begin your export, make sure that you've installed Lightspeed eCom.

Export product data from Lightspeed eCommerce

You can download product information such as product variants, title, description, images, price, collections, and tags with the Lightspeed eCommerce products CSV file.

Steps:

  1. Log in to your Lightspeed eCommerce account.

    Lightspeed eCommerce Inventory

  2. In the sidebar, click Tools and then click Exports.

    Lightspeed eCommerce Exports

  3. On the Exports page, click Add export.

  4. Select Products from the drop-down menu, then click Export.

  5. On the Exports page, click Download next to the Inventory export.

  6. When prompted, save the Lightspeed eCommerce products CSV file to your computer.

Export online customer data from Lightspeed eCommerce

You can download information for your online customers such as the customer name, email, and address with the Lightspeed eCommerce customers CSV file.

Steps:

  1. From your Lightspeed eCommerce sidebar, click Tools and then click Exports.

  2. On the Exports page, click Add export.

  3. Select Customers from the drop-down menu, then click Export.

  4. On the Exports page, click Download next to the Customers export.

  5. When prompted, save the Lightspeed eCommerce customers CSV file to your computer.

Export barcode and inventory data from Lightspeed Retail POS

You can download additional product data such as the Lightspeed product barcodes, collections, and product inventory (including multi-location inventory) with the Lightspeed Retail POS items CSV file.

If you don't need need barcode or inventory data, then you can skip this file export.

Steps:

  1. Log in to your Lightspeed Retail POS account.

    Lightspeed Retail POS Inventory

  2. In the sidebar, click Inventory and then click Item Search.

  3. If you have multiple locations, then make sure that you’re retrieving inventory for all of your locations. In the search toolbar, click Advanced. Select the Show All Locations checkbox. In the Shops dropdown menu, select the All Shops.

    Lightspeed Retail POS Inventory

  4. Click Search. Inventory for all of your locations appears in the items list.

  5. Click Export

  6. When prompted, save the Lightspeed Retail POS items CSV file to your computer.

Export retail customer data from Lightspeed Retail POS

You can download information for your retail and omnichannel customers such as the customer name, email, and address with the Lightspeed Retail POS customers CSV file.

Steps:

  1. From your Lightspeed Retail POS sidebar, click Customers and then select Customers from the available options.

    Lightspeed Retail POS Custtomers

  2. Click Export

  3. When prompted, save the Lightspeed Retail POS customers CSV file to your computer.

Step 2: Import your store data into Shopify

After you export your product data from Lightspeed, you need to import your CSV files into Shopify.

An import containing the Lightspeed Retail POS items CSV file must also include the Lightspeed eCommerce products CSV file. The Lightspeed eCommerce products CSV file contains mandatory information about product variants, and must be included in your data import.

The Store Importer app supports importing products, inventory, and customer data from Lightspeed, but you can't import historical orders. If you have both the Online Store channel and the Point of Sale channel installed for your Shopify store, then the products that you import are available to both channels.

Steps:

  1. From your Shopify admin, click Apps > Store Importer.

  2. On the Store Importer page, select Lightspeed from the drop-down menu.

If the platform mentioned on the Store Importer page is not your store's platform, then scroll down to the bottom of the page and click Select a different platform. You can then select Lightspeed from the drop-down menu.

  1. To upload your files, click Add file and then select your files, or drag and drop your files onto the Add file area.

  2. Click Continue import > Import.

Known limitations for Lightspeed product data

The following columns appear in the exported CSVs from Lightspeed, but aren't imported into Shopify because the standard data model can't support them:

  • UPC
  • EAN
  • Manufact. SKU
  • Vendor/Supplier
  • Season
  • Department
  • MSRP
  • Tax class
  • Stock_Min
  • Stock_Alert
  • Volume
  • Colli
  • Size X/Y/Z
  • Size_Unit
  • Buy_Min/Max
  • US_Meta_Keywords
  • Custom Fields

If you want to store any of this data in Shopify, then you need to create metafields for your store and add the values to the metafields manually.

Product variant images are mapped to the parent product.

Lightspeed categories and subcategories are imported as individual product collections.

Known limitations for Lightspeed customer data

The following columns appear in the exported CSVs from Lightspeed, but aren't imported into Shopify:

  • Customer type
  • Discount
  • Date of Birth (DOB)
  • Title
  • Created At
  • Multiple Phone Numbers (Home, Work, Fax, Pager, Mobile)
  • Website
  • Email2

While Lightspeed lets merchants create custom fields on customer profiles, these aren't supported in Shopify’s data model. If you want to store this data in Shopify, then you need to install a loyalty app that supports these additional fields.

Customers who have only a company listed and no other contact information are imported with their company name as their first name.

Step 3: Review and update your imported data

If your data import was successful, then your product and customer data is available in your Shopify admin. If some of your products or customers didn't import successfully, then you can add them manually.

The currency for product prices is determined by the Shopify store currency.

Steps:

  1. In your Shopify admin, review your product, inventory, and customer data to verify that all the data was imported.

  2. If some of the data was not imported, then add missing products or missing customers records manually.

Troubleshooting data import errors

If you encounter errors when you import your data with the CSV file, review the solutions to common product CSV import problems.

If you notice that your data did not import as expected, review the following solutions.

Import was successful with changes

When your import is finished, the import summary page shows you the details of your import. Review the messages in the review section of the import summary for any errors. You can edit your imported information manually by clicking View items next to these messages.

Some products or customers records failed to import

If some of your products or customers didn't import, then you can add a product or add a customer.

Any customers with the same email address or phone number aren't included in an import. If two or more customers share an email address or phone number, then only the most recently created customer entry is imported.

Limits on product variant creation

If your store has more than 50,000 product variants, then you're limited to creating 1,000 product variants per day.

Multi-location inventory failed to import

To import multi-location inventory, you first need to create the locations in Shopify. The names in Shopify need to match the names in Lightspeed exactly. You can find the names of their locations in the column headers of the Retail POS items CSV file between the Qty and Price columns.

If you attempt to import multi-location inventory before the locations have been created in Shopify, then the inventory fails to import.

Barcodes are set to Lightspeed's 13-digit barcodes

The Store Importer app sets product and variant barcodes to the 13-digit printed barcode (based on system ID). If you're using 8-digit printed barcodes or other barcodes (UPC/EAN/SKU) as your scannable barcode, then you need to manually input this data. To do this, first import your product data with the Store Importer app, and then you can bulk-edit the barcodes field to manually enter the right barcode data.

Product variants with the exact same name are imported, but their barcodes/inventory aren't imported

If duplicate products exist, then the barcodes and inventory can't be matched to the product variants. The product variants import successfully, and are flagged during the import. You need to add barcodes and inventory for those variants manually.

Product variants with variable prices across sales channels will be imported with a price of 0

Shopify doesn't support pricing per sales channel. Products that have variable pricing are imported, but the product remains unpublished and is unavailable for sale in any sales channel. Affected products are flagged with an error message in the Store Importer app. To change the prices and availability, click the link provided to access the product. If you have many variable price errors, then you may want to use the bulk editor or generic product CSV to make multiple edits at one time.

Duplicate customers

In Shopify, customers can't share the same email or phone number. If two or more customers share the same email address or phone number, then only the most recent customer entry is imported and the other customers are skipped.

Import data on top of an existing import

If you think you missed something in your previous import, then you can import your store data again on top of your current import by clicking Start new import.

  • If your Shopify store or previous import already contains customers, then they are updated. The customers are first matched by email address, and then telephone number if no email address match is found. If a match is found, then the existing record is updated as follows:

    • Tax exempt and marketing subscription statuses are overwritten.
    • Tags, addresses, and notes from the import are added.
    • If the first name, last name, or telephone number fields are empty in the existing record and included in the imported customer record, then they are added.
  • If an import contains products that are already on your Shopify store, then the matching products in the import are skipped and not imported. A list of the skipped products is shown in the Import summary after the import is complete.

Delete a store data import

If you’re unsatisfied with a data import, then you can delete it. For example, if your data import contains many failed items, then it might be helpful to remove that import and try again. You can delete only your latest import. Wait for the data to delete completely before you start another import.

Steps

  1. On the Import complete page, click Delete import.

  2. On the Delete import dialog, click Delete import.

After all your imported files are deleted, click Start new import to start another import.

Considerations for customer passwords

Because passwords are encrypted, you can't migrate customer passwords from another platform to Shopify. As a result, only customer records are migrated to Shopify instead of customer accounts.

Ready to start selling with Shopify?

Try it free