"After upgrading to version 9, we decided not to use variants any more. In version 8, we attached product information to variants, and we want these now attached to the product template"
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
1
Reply
4464
Views
Run this SQL in the database to move the attachment from the variant to the template:
update ir_attachment set res_model = 'product.template', res_id = p.product_tmpl_id
from product_product p where p.id = res_id and res_model = 'product.product';
Do you think this would work on Odoo 10 Enterprise?
Odoo staff are being particularly unhelpful even though we have the Enterprise version.
I don't have access to version 10 in order to test. If you do you can make a copy of your database, or limit the query to a specific product template. We publish our long term support at https://www.odoo.com/page/odoo-long-term-support and have not supported version 10 since the end of 2019.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
3
Sep 15
|
5185 | ||
|
5
May 23
|
15343 | ||
|
2
Dec 23
|
5332 | ||
|
1
May 22
|
2536 | ||
|
|
0
Apr 22
|
1998 |
