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.

Post Terkait	Replies	Tampilan
i cant add Variants to my products in my storage variant	1 Jul 25	1162
how to use product_variant_multi? variant	1 Mar 15	5041
Remove Attribute (Variant List) variant attributes	1 Nov 25	731
Need some configurator guidance; V18 Configurator\Variants selection issue variant configurator	1 Sep 25	922
Is it possible to easily assign one image to multiple product variants? product variant	3 Mei 25	2707

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!