Better stock tracking

[wolflu05]

Is your feature request related to a problem? Please describe.

Currently its only possible to mark certain ingredients as "in stock", but you cannot see how much flour you have, when your milk expires or if your frozen pizza is stored in the kitchen or basement freezer.

Describe the solution you'd like

Add the following resources:

1. Stock locations - ideally this is a tree which can represent sub-... locations, maybe django-mptt can be used here
2. Food item - represents one specific food item from a specific brand and with a specific amount which can be linked to an 1. ingredient and later maybe also a supermarket . That way varying data like GTIN, nutritional values, ... can be stored individually
3. Stock Item - which links a Stock Location, Food item and an amount together and represents the actual stock of this food item at a specific location

That way we can have the following possibilities:

• See what food items are near their expiry date/are already expired. This can help a lot to reduce food items that are just thrown away, because you have forgotten that you bought them. Maybe also a dedicated what meal can I cook with those food items dialog can be build
• If we are away from home and want to cook something specific, but don't know if we have all ingredients, just look it up and see what we still need to buy
• A barcode scanner in combination with a GTIN database like open food facts can be used to quickly generate the food items and auto link them to ingredients if their name matches.
• The barcode scanner could be used to to keep the stock in sync. Ideally this is a dedicated device which lives in the kitchen with a display and a knob for adjusting the amount. Then if we take a product, just scan it and adjust the amount and press the knob.

Please let me know what you think about this approach and if you think the concept with the food items which can be linked to ingredients is to complex for tandoor and think that linking ingredients directly to stock items is better, but then we loose the information about the GTIN and specific nutrition values, ....

Describe alternatives you've considered

Using external specific stock tracking solutions like inventree.

Additional context

No response

[vabene1111]

Hi, thanks for he issue and concept provided. Stock keeping is something tandoor might include in the future. I have not yet looked into technical concepts but they will be oriented by stock keeping systems for logistics purposes.

Regardless of the implementation there will be no stock keeping until more pressing issues of usability and performance are fixed so I recommend anyone from refraining to open any PRs on this. Still anyone should feel free to post technical concepts if they are familiar with existing stock or logistics systems and want to work out a proper concept.