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.

関連投稿	返信	ビュー
i cant add Variants to my products in my storage variant	1 7月 25	465
how to use product_variant_multi? variant	1 3月 15	4223
Is it possible to easily assign one image to multiple product variants? product variant	3 5月 25	1456
Pros and Cons of creating product variants Instantly or Dynamically or Never 解決済 product variant	3 11月 24	8202
Bill of Material/Operation(Work Order) on different Variants operation variant	2 8月 24	1647

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！