Hello Bubble community,
I am building a CRM web app to track business customers, orders, items, and sales. I am now looking to add stock tracking to the system so that when a sale occurs, the stock will decrease and when there is a purchase of stock, the actual stock will increase.
The user interface for this feature is already finished, but I am seeking guidance on how to organize my database to enable these calculations. I would appreciate any advice on what plugins would be best to use and any other tips on how to set up this feature. The data types involved in this operation are orders, items, and stock.
Thank you in advance for your help.