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	Besvarelser	Visninger
i cant add Variants to my products in my storage variant	1 jul. 25	498
how to use product_variant_multi? variant	1 mar. 15	4243
Is it possible to easily assign one image to multiple product variants? product variant	3 maj 25	1501
Pros and Cons of creating product variants Instantly or Dynamically or Never Løst product variant	3 nov. 24	8266
Bill of Material/Operation(Work Order) on different Variants operation variant	2 aug. 24	1673

Dette spørgsmål er blevet anmeldt

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