Importing custom fields for products into Lightspeed Retail

Lightspeed Retail does not provide a solution to import custom fields created under products.  Hyperspace offers tools that can append existing products in Lightspeed Retail with this information.

The first step is to get an export of all product data that exists in Lightspeed Retail Point of Sale. The product custom fields import requires that you have the SYSTEM ID as the first column for the import.

Simple products and children products in Lightspeed all have a SYSTEM ID.

Often the easiest way to get a list of all products you want to update is through Lightspeed Retail's own export. If you login to Lightspeed Retail and go to Inventory > Item Search you will see a list of all products and you can even narrow down the list. 

Screen_Shot_2019-06-06_at_5.44.53_PM.png

Click the Export tab on the far right to export your selection to a .csv. Open this file in excel to edit.

Download this file and copy and paste the SYSTEM ID and Product title from your Lightspeed export into this sheet.  Fill out the other columns as needed.

Screen_Shot_2019-06-06_at_5.50.22_PM.png

Important: Be sure that the column header in your file perfectly matches the custom field name in Lightspeed. Spelling, capitalization and spacing are all important. Also make sure your file is saved as a .csv before importing.

When you are done, save the sheet as a .csv.

Login to your Hyperspace account and click on the Data Import tab at the top. 

Screen_Shot_2019-06-06_at_5.44.04_PM.png

At the bottom, click the button called:  Update Custom Fields

 Screen_Shot_2019-06-06_at_5.43.47_PM.png

Screen_Shot_2019-06-06_at_5.43.55_PM.png

Choose the file on your computer and select Import. 

 Screen_Shot_2019-06-06_at_5.44.20_PM.png

Screen_Shot_2019-06-06_at_5.44.25_PM.png

Depending on the total number of rows in your file, it could take minutes or several hours for the update file to finish importing all of your data.

 

Was this article helpful?
0 out of 0 found this helpful