I am working on a project with my son, and we would like to track real time sales in order to better manage inventory. I believe we must do this because the POS square app does not tell us when an item is sold out, this means we can potentially sell something we are out of stock with and a customer is not happy. This has become a big problem because 60% of our sales occurs online and our store is open only one day a week, so we must make sure that we are not over selling items to walk up customers during our one day sale. For example, 66% of inventory is sold during the week, and the rest is sold on Saturday through POS transactions. We are generally extremely busy and do not have the resources to dedicate a worker manually tracking low inventory items.
Our concept is a dashboard that allows us to tally units sold of any item we wish to track on the dashboard. Ideally the dashboard would have a moderate refresh rate of every 30 seconds. Perhaps we could use an api that collects the transaction history and a simple algorithm could decipher how that is displayed via our concept dashboard?
Are there API hooks that would enable this kind of a dashboard?