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?