Hold a specification for each product
Keep the current information for everything a recipe can use: ingredients, sauces, breads, drinks, garnishes and frying oil.
The matches the product on the shelf today, from the supplier who delivered it.
A generic entry for soy sauce covers three brands, and only some contain wheat.
Buy only ingredients with a known . include sub-ingredients. are recorded exactly as the supplier made them and kept apart from ingredients.