Hyperspace includes numerous Data Import tools. These tools enable you to update, import and append data directly in Lightspeed You can use the Inventory import tool to update existing stock by store in Lightspeed. You are able to import stock for different stores using this tool. It is important the you import your file in a .CSV format. If you are not sure how to save an excel file as a .CSV, please watch the video below.
1. Your file must be a .csv. It cannot be .xls.
2. If using custom sku, the sku must be capitalized the same. You cannot have lowercase letters in your file and uppercase in Lightspeed.
IMPORTANT: If your file contains a lot of items with 0 stock and the products in Lightspeed already have 0 stock, it is recommended that you remove the line items from your import file that have 0 stock. The update will run much faster. It will not need to update 0 stock items with 0 stock.
First login to your Hyperspace account. At the top of the screen click on the Data Import Tools button.
You will see numerous green buttons at the bottom of the screen.
Locate the button on the right called 'Update Inventory'
When you click on this button a pop-up will appear.
It will show 2 file formats that you can choose and each one has a sample you can download. You can choose to import inventory updates by SYSTEM ID or Custom SKU.
For example, if you choose to use Custom SKU you will need to provide a .CSV that has the Lightspeed Retail Custom SKU in 1 column and the stock level in the other. See example below.
IMPORTANT: Be sure to put the store name in the stock column exactly how it is spelled and capitalized in Lightspeed Retail. If your store name is Ace Hardware 55, you need to put Ace Hardware 55 in the column header for column B (See example above). Do not put ACE HARDWARE55. It does need to be exactly the same as it is in Lightspeed Retail.
Once your file is ready you can click on the Choose File button and select the file on your computer.
Once you have selected the file, click the IMPORT button.
Your file will begin importing and updated Lightspeed Retail in real-time. A progress bar will appear showing the status of the import.
Note: If you lose your internet connection don't worry, the import is still running. If your internet should drop and the progress bar does not seem to be moving, it is likely that you briefly lost your internet connection in your office. Rest assured, the import is still running and processing.
It is important the you import your file in a .CSV format. If you are not sure how to save an excel file as a .CSV, please watch the video below.