Hello everyone,

We are newcomers to the Odoo world.

We're setting up the environment to manage a wine business.

Our item repository (Products in Odoo) must meet the following constraint:

A product, a wine, can exist in n vintages: 2019, 2020, 2021...

A product-vintage can exist in n capacities (units in Odoo): 37.5, 75, 150 cl....

We therefore have Product>Millennium>Capacity.

How do you recommend structuring the product database to enable a "logical descent" from product to vintage to container?

The structure adopted should facilitate search and filtering-grouping by Product, Vintage, Container.

Ultimately, it should enable e-Commerce.

Finally, and ideally, we'd like to optimize reference creation. Once a product has been created, if I reference a new vintage and/or a new container, the other information won't change. So I need to be able to produce a declination.

Key point: the price for a Product>Millennium>Content doesn't follow any logical rule. Clearly, the Variant approach doesn't work and causes problems.

Thank you all in advance for your feedback.