Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
2 Odpowiedzi
6857 Widoki
Awatar
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
Awatar
Odrzuć
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

Awatar
Ermin Trevisan
Najlepsza odpowiedź

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!

Awatar
Odrzuć
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?

Awatar
Zakaria Al-Hakeem
Autor Najlepsza odpowiedź

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.

Awatar
Odrzuć
Rabbit Trade

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