Importing your weight and dimensions into Lightspeed Retail

Lightspeed Retail does not provide a solution to import weight or dimensions into the Web Store Tab.  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 weight/dimension 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.

Screen_Shot_2019-05-14_at_3.03.24_PM.png

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-05-14_at_3.06.23_PM.png

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

Screen_Shot_2019-05-14_at_3.06.33_PM.png

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.

A. Do not change the names in the column headers.

B. Do not re-order the columns.

C. Do not add new columns.

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-05-14_at_4.34.07_PM.png

At the bottom, click the button called:  Update Dimensions/Weight

Screen_Shot_2019-05-14_at_4.34.16_PM.png

Choose the file on your computer and select Import. 

Screen_Shot_2019-05-14_at_4.34.23_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