I need to move my accessory products to alternative products. I've been trying to do this inside of Odoo with no luck. Eventually I came up with these SQL commands which seem to do the trick, but I was wondering if this might be harmful to run on production or if anyone knew a cleaner way?
TRUNCATE product_alternative_rel;
INSERT INTO product_alternative_rel SELECT DISTINCT src_id,product_tmpl_id AS dest_id FROM product_accessory_rel, product_product WHERE dest_id = product_product.id;
TRUNCATE product_accessory_rel;
Any advice appreciated.