Hi,

This is a classic use case for selling products in different units and packages, but still drawing from a single central stock. Out of the box, Odoo doesn’t let multiple product variants share the same stock quantity; each variant is treated as its own stock-keeping unit (SKU). That’s why Odoo support told you it’s not possible without customization. However, there are ways to achieve your workflow with the right setup.

For your loose tea, you need one stock of bulk tea (in grams or kilograms), and then define different “sales units” or packaged options (50 g, 100 g, 250 g bags, or loose weighed amounts) that all consume from that bulk stock. This can be managed in Odoo using Units of Measure (UoM) instead of variants. You define your product “Green Tea (bulk)” with stock in grams (e.g., 2000 g). Then, create UoMs like 50 g, 100 g, 250 g, and even 1 g for custom weights. When you sell using those UoMs, Odoo automatically converts back to grams and deducts from the same stock. For price breaks (e.g., cheaper per gram above 100 g), you can set up pricelists instead of separate variants.

For the ready-made bags (50 g, 100 g, 250 g), you can either:

    Treat them as the same bulk product with different UoMs (preferred if you pack on demand).

    Or define them as separate products (bags) but link them with a Bill of Materials (BoM) to the bulk tea. For example, selling “Tea Bag 100 g” automatically consumes 100 g from bulk stock. This keeps reporting clearer if you want to track packaged sales separately.

For the eShop, you can simply publish the fixed-quantity options (bags) and hide the loose “Vrac” UoMs. Odoo website lets you choose which products/variants to publish. This way, POS operators can sell any weight in-store, while online customers see only prepacked sizes.

So, in summary:

    Manage stock in bulk (grams/kilos).

    Use Units of Measure or BoMs to handle loose vs. packaged sales.

    Apply pricelists for bulk discounts.

    Publish only relevant items to the eShop.

This setup lets your 2000 g inventory reduce properly, whether you sell 47 g loose in-store or 2 × 100 g bags online, and it avoids duplicating stock between variants.

For more information:

* https://www.cybrosys.com/blog/how-to-configure-products-product-variants-in-odoo-18-pos

* https://www.youtube.com/watch?v=afMyzJIKVw8

Hope it helps

Managing stock for multiple variants from a single central stock in Odoo requires a slightly different approach than the standard variant management.

  Consider using a single product with different pricing based on quantity using Odoo's pricelist functionality. This avoids managing separate variants for each weight.

  Create a single "Loose Green Tea" product. Define pricelists with different unit prices based on quantity ranges (e.g., <100g, 100-250g, >250g). This accurately reflects your POS pricing.

  For pre-packaged teas (50g, 100g, 250g), create separate products. These will have their own stock levels but can be linked to the main "Loose Green Tea" product for reporting purposes (e.g., using custom fields or reports). This allows you to track both loose and packaged tea stock.

  Use Odoo's stock management features to track the overall quantity of "Loose Green Tea". When a sale occurs (regardless of variant), deduct the weight from the central stock. You can achieve this through custom development or using Odoo's existing features creatively.

  For your eShop, only display the pre-packaged tea products. This simplifies the online ordering process and avoids confusion.

Resources: While we don't have exact matches for your specific scenario, our blog and website offer many resources on Odoo inventory management. Check them out for further learning.

For personalized assistance:
https://www.pragtech.co.in/contact.html