Hi. How can we help?

Importing items

To import inventory items via our Retail Imports team, please refer to this article.

In Lightspeed Retail POS, you can add or update items and images in a number of different ways. In many cases, however, importing them in an XLSX or a CSV file is the fastest. This is especially true if:

Importing items

  1. Format your item import file to import your items into your Lightspeed Retail POS inventory.
  2. From the main menu, click Inventory > Import Items.Screen_Shot_2019-10-02_at_10.52.png
  3. If the Welcome to Item Imports modal displays, read the import information and click Continue.
  4. Click + New Import.
  5. Under SELECT FILE, drag and drop your import file. Alternatively, click Browse and select your import file. Screen_Shot_2019-11-14_at_12.10_1.png
  6. Select an import method (e.g. Create new items only).
  7. If you're updating existing items, select which field (e.g. System ID) in your item import file that your Retail POS account will match on to update your existing items correctly.
  8. Optionally, include your email address to be notified once your import file is reviewed and your import is done.
  9. Under MAP COLUMNS, your Retail POS account will automatically map the columns in your import file that it recognizes as compatible with Lightspeed Retail. If you have invalid columns in your import file, select compatible columns from the drop-downs.Screen_Shot_2019-11-14_at_12.10_1__1_.png
  10. Select the Skip checkbox of columns you don't need to import.
  11. Click Review import. Your account will start reviewing your import file for formatting errors.


    If you have errors in your import file, please see Fixing errors in item import files.

  12. Review the inventory data under REVIEW IMPORT and ITEM PREVIEW:
    • NEW ITEMS: Number of items that will be created.
    • UPDATED ITEMS: Number of items that will be updated.
    • NEW VENDORS: Number of new vendors that will be created.
    • NEW BRANDS: Number of new brands that will be created.
    • NEW CATEGORIES: Number of new categories that will be created.
    • ITEMS WITH INVENTORY: Number of new items that will be created and will have inventory to be added.
    • TOTAL QUANTITY: Total quantity of inventory that will be added to these new items.
    • TOTAL COST: Total cost of the inventory that will be added to these new items.


  13. If the inventory data looks correct, click Import items. Your items will start importing and the Import report will display once your import is done. Screen_Shot_2019-11-14_at_2.23_1.png

Your items should now be created or updated in your inventory. To make sure your inventory was imported correctly, we recommending reviewing your items and scanning them under Inventory > Item Search.

Adding labels to the queue

If you imported a QOH for your new items, you can click the Add Labels to queue for Items with Inventory button to create a label queue. This way, you can simply print your label queue from Inventory > Print Labels, glue the labels on your new items and start selling them. For more information, please see Printing labels.mceclip0.png

Upload item images

If you imported the file names of your item images, you need to upload the image files to your Retail POS account to officially add them to your items. For more information, please see Importing images.

Download the item import file

For your record-keeping, the file that used for the import is stored in your Retail POS account. This way, you can download it at any time should you need to refer back to it for your business needs.

Was this article helpful?

1 out of 2 found this helpful