"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 management
- MRP
This question has been flagged
1
Reply
3459
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.
