Odoo v8: Relationship between product.product and product.template tables

Question

Hi All,
Could someone explain me which is the relationship between the tables product_product and product_template?
Is possible to have records in product_template tables that has no reference in product_product?
If a product has only 1 variant, and I remove the flag active from the variant , should the product be deactivetd too or it could remain with none active variant ?

Axel Mendoza · Accepted Answer

The product.template is used as a base for product variants that are product.product and for a product.template record you will get at least 1 product.product variant that it's actually what you use to store, sell, buy... product.product records

Elisa Pagliuca · Answer

Hi,
So, products with no variants are not allowed by Odoo?
What happens when I deactivate a variant?
Kind regards
Elisa

le_dilem · Answer

Hi
In
the table you product_product key product_tmpl_id 'many2one'
product_template The fact of creating a recording that automatically
creates product_template in product_product
if you have several alternatives you're not going to have fun a modified field by one.

Related Posts	Replies	Zobrazenia
i cant add Variants to my products in my storage variant	1 júl 25	1044
how to use product_variant_multi? variant	1 mar 15	4878
Remove Attribute (Variant List) variant attributes	1 nov 25	508
Need some configurator guidance; V18 Configurator\Variants selection issue variant configurator	1 sep 25	794
Is it possible to easily assign one image to multiple product variants? product variant	3 máj 25	2467

This question has been flagged

Enjoying the discussion? Don't just read, join in!