Mass update stock count


We have a CSV stock count file with manufacturer SKUs and on hand quantity for all items (about 13.000 of them) in a shop and need to update Lightspeed stock. My current best guess it to request (GET with limit of 100 per request) all the inventory in a staging table storing there manufacturerSku, itemID and also itemShopID, qoh for the shopID we working with, then put CSV data to a staging table. Then compare stock difference and for each item where stock count differs send a PUT request to update on hand quantity. But this can be about 1.000 requests per shop. According to rate limiting this can take about 2 hours per shop and this does not looks optimal. Is there a better strategy of mass stock count update that the one I found?

1 comment

  • VanessaDVanessaD Moderator, Lightspeed Staff Posts: 194 moderator

    Hey @maxim_retailit

    As it is, this is the best practice we offer when working with 3rd party Inventory Counts that need to be imported into Lightspeed.

    Considering that this is something that is currently still a feature request that we're working on, we'll need to utilise a workaround to zero out your inventory and then re-add quantities while maintaining the historical data of these items. 

    To do so, you'll start by processing an inventory count. 

    • Go to Inventory > inventory Count 
    • Create a new count 
    • Go to the MISSED tab 
    • Zero out all the items by slice of 100 each 
    • Once you're done, reconcile your count with 0 values on all your items

    When this is done, you'll work on adding the item quantities back into the system through a Purchase Order. 

    • Open the inventory > Purchase Order section of Lightspeed
    • Create a new Purchase Order
    • Use a vendor that you'll create for this purpose, we usually suggest something like "InvCount Import"
    • Save the changes 

    An import tab will appear on the left-hand side of the PO. You'll need to create a Purchase Order Import CSV spreadsheet by adding the system IDs and Count detail columns. The system will be able to lock-on to the items using the system ID and add quantities to it using the Quantity on Order column. 

    You'll break this up into 500 line slices and import them using the PO import tool. When you're done, you'll add the items to the received list and add them to your inventory! 

    We usually suggest the PO with the limit of 500 lines per import since the quantities cannot be updated when the items are given a System ID.

    Otherwise there are integrators like Accumula who offer to import the data for a fee!


    If you have any further questions Please do not hesitate to contact LightSpeed support or check out our Support Page.


    Vanessa D.

    Lightspeed Retail Support

    866-932-1801 ext. 2 (Toll-Free)

    514-907-1801 ext. 2 (Montreal)

Sign In or Register to comment.