Tracking Inventory Using ItemShop (API)
I'm currently using the FiveTran integration with LightSpeed to create tables for reporting and analytics. At this point I'm trying to utilize the ItemShop fields (called item_shop_history via FiveTran) to create a daily Inventory Snapshot for ongoing reporting.
In building out the Snapshot table, I've noticed that the timeStamp associated with these records is not updated daily (or as items are sold). It appears that it may be updated with manual Inventory counts, however that is unclear at this point.
Am I misinterpreting the purpose of ItemShop - does it not contain the current quantity on hand for each item per shop, plus the aggregate (shop 0)?
I've reviewed this similar thread, but not sure if the issue described here aligns with my issue: https://community.lightspeedhq.com/en/discussion/1486/inventory-count-api-issue
Thanks in advance!