Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
2 ตอบกลับ
6905 มุมมอง
อวตาร
Zakaria Al-Hakeem

We have products with several variants created on our database as "individual products". We have done several transactions on them as well (Purchase, Receipt, Transfer, SO, Invoices...etc.)

Is it possible to switch these products into "Product Variants" and group them together, without losing the data or at least messing up the previous process?

 

Example:

Our products look like this at the moment:

Product 1: Speaker123-Color Red (Product_Template_1), Barcode:10

Product 2: Speaker123-Color Black (Product_Template_2), Barcode:11

Product 3: Speaker123-Color Blue (Product_Template_3), Barcode:12

 

We need to convert it to:

Product 1: Speaker123

                Product Variant 1:  Speaker123-Color Red  (Product_Template_1), Barcode:10

                Product Variant 1:  Speaker123-Color Black (Product_Template_1), Barcode:11

                Product Variant 1:  Speaker123-Color Blue (Product_Template_1), Barcode:12

 

Is there any way to do this either with an app or without? 

Thanks
อวตาร
ละทิ้ง
George Mountanos

Please let me know if you figured this out!
Thanks in advance

Cycles Treize

Hello,

I want to achieve the same thing here (v16).

But i can't find how to re-import old variants with the new created parent model.

What fields do i need ?


Thanks a lot

อวตาร
Ermin Trevisan
คำตอบที่ดีที่สุด

I did not try it, but maybe it gives you an idea:

Create the necessary attributes and the attribute values.


Each product.template record also automatically creates a product.product record (variant), even if no variants are created explicitely. You may want to create a new product template with  the  corresponding  variants , then go to the corresponding newly created product variants and export them to  see  the  External  ID  of  the  corresponding  product  template and the  fields  for  the  attribute  values . 

Also export the product variants of the old product templates. Then in the  product  variant  records  replace the External ID of the product template with the External ID of the newly created product template,  add the  attribute  fields  and  reimport  the  product  variants. Then delete  the  automatically  created  product.product  records  of  the  new  product  template.  Maybe it works.

But make a database backup before!

อวตาร
ละทิ้ง
Gross Ricardo

Nice solution but, if I try to import (Odoo v15), in my case 3 variants, I get an import error:
"new row for relation "ir_model_data" violates check constraint "ir_model_data_name_nospaces" DETAIL: Failing row contains"
If I import only one variant, it works!
How to solve this error?

อวตาร
Zakaria Al-Hakeem
ผู้เขียน คำตอบที่ดีที่สุด

This solution worked perfectly!
I'm keeping an eye to see if there are any future hidden consequences. But so far all went well. Thanks a lot.

อวตาร
ละทิ้ง
Rabbit Trade

Did it work well for you, I wnt to try it but I'm bit worried it would ruin my db