
Since it is a bakery, he wants to have a centralized ingredient inventory. I will use a few examples to demonstrate what he wants.
Centralized Inventory -
Sugar = 5 kg
Icing = 5 kg
Flour = 10 kg
Chocolate Shavings = 1 kg
Oil = 2 Litres
Cherries = 200 pcs
Now, a product on the site, "Black Forest Cake" in size "1 kg", requires 0.75kg flour, 0.25kg icing, 0.25kg sugar, 0.1kg shavings, 120ml of oil and 10 cherries.
Another product, "Dutch Truffle" in size "500 gm" has slightly different requirements.
Now, how can this sort of a system be set up? When someone buys a "Black Forest Cake", ingredients are deducted from the centralized inventory accordingly.
A report needs to be generated on a daily or weekly basis to keep track of how much Flour, Oil, etc. is still left and what all needs to be purchased.
Further, if, say, Oil is low on stock, the store admin should get a notification (how doesn't matter. It could be email, a back end popup or something else) and once "Oil" is over, all products that need "oil" to be made should be unavailable, somehow.
Is this possible? Does it exist? Suggestions / Solutions?