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.

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
i cant add Variants to my products in my storage variant	1 heinäk. 25	685
how to use product_variant_multi? variant	1 maalisk. 15	4405
Need some configurator guidance; V18 Configurator\Variants selection issue variant configurator	1 syysk. 25	275
Is it possible to easily assign one image to multiple product variants? product variant	3 toukok. 25	1802
Pros and Cons of creating product variants Instantly or Dynamically or Never Ratkaistu product variant	3 marrask. 24	8657

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!