Food nutrition database

[wp.rauchholz]

Good day.

we want to use ofbiz for a food related business.
For tyhat we need to setup a database of ingredients and their nutritional properties.
Is this best done hrough the 'Attributes' in the item master or is there a better way?
Underneath an example of the data model for an apple.

Component              Value Unit Source
Proximales
alcohol (ethanol)      0        g 310
fat, total (total lipid) trace g 258
protein, total                0.3        g 258
water (moisture)     85.7   g 258
Hidratos de Carbono
carbohydrate         12      g 258
sucrose                   2.4      g 341
fibre, total dietary     2      g 258

Thanks, Wolfgang

[marcopaul]

You’ll want to use Features which already has units support built in.

Add a broad feature Type for Nutrition
https://demo-trunk.ofbiz.apache.org/catalog/control/EditFeatureTypes <https://demo-trunk.ofbiz.apache.org/catalog/control/EditFeatureTypes>

And define the specific Nutrition things as features which live in Feature Categories:
 https://demo-trunk.ofbiz.apache.org/catalog/control/EditFeatureCategories <https://demo-trunk.ofbiz.apache.org/catalog/control/EditFeatureCategories>

Then you can manage specific features in the per-product features:
https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductFeatures?productId=WG-9943 <https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductFeatures?productId=WG-9943>


--P
----------
Paul Mandeltort,  Marco Specialties, Inc.  [phone]  [hidden email]

> On Feb 18, 2019, at 3:51 AM, [hidden email] wrote:
>
> Good day.
>
> we want to use ofbiz for a food related business.
> For tyhat we need to setup a database of ingredients and their nutritional properties.
> Is this best done hrough the 'Attributes' in the item master or is there a better way?
> Underneath an example of the data model for an apple.
>
> Component              Value Unit Source
> Proximales
> alcohol (ethanol)      0        g 310
> fat, total (total lipid) trace g 258
> protein, total                0.3        g 258
> water (moisture)     85.7   g 258
> Hidratos de Carbono
> carbohydrate         12      g 258
> sucrose                   2.4      g 341
> fibre, total dietary     2      g 258
>
> Thanks, Wolfgang

[wp.rauchholz]

Thanks for pointing me to this solution. That works really great!

Quesiton I still have; what is the best usage of the tab 'Attributes'?

Wolfgang



On Mon, 2019-02-18 at 09:39 -0600, Paul Mandeltort wrote:

> You’ll want to use Features which already has units support built
> in.
>
> Add a broad feature Type for Nutrition
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditFeatureTypes
> <https://demo-
> trunk.ofbiz.apache.org/catalog/control/EditFeatureTypes>
>
> And define the specific Nutrition things as features which live in
> Feature Categories:
>  
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditFeatureCategories
>  <
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditFeatureCategories
> >
>
> Then you can manage specific features in the per-product features:
>

https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductFeatures?productId=WG-9943

>  <
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductFeatures?productId=WG-9943
> >
>
>
> --P
> ----------
> Paul Mandeltort,  Marco Specialties, Inc.  [phone]  
> [hidden email]
>
> > On Feb 18, 2019, at 3:51 AM, [hidden email] wrote:
> >
> > Good day.
> >
> > we want to use ofbiz for a food related business.
> > For tyhat we need to setup a database of ingredients and their
> > nutritional properties.
> > Is this best done hrough the 'Attributes' in the item master or is
> > there a better way?
> > Underneath an example of the data model for an apple.
> >
> > Component              Value Unit Source
> > Proximales
> > alcohol (ethanol)      0        g 310
> > fat, total (total lipid) trace g 258
> > protein, total                0.3        g 258
> > water (moisture)     85.7   g 258
> > Hidratos de Carbono
> > carbohydrate         12      g 258
> > sucrose                   2.4      g 341
> > fibre, total dietary     2      g 258
> >
> > Thanks, Wolfgang
>
>

[herniya]

Looking for the perfect pick me up? The 7 Brew menu Price USA 2024 offers a wide range of delicious coffee drinks, flavors, and treats that cater to every taste. You are craving a rich cup of brew coffee with a sweet shot of Irish cream or something indulgent like white chocolate. They have it all like seven original coffees, infused 7 Energy drinks, 7 Fizz, shakes, smoothies, and teas. Quality is great with 100% Peruvian coffee beans that undergo a light roast.