I want to manually clean my database (Odoo V7). Reason: There are some products, I want to get rid of and deleting products is impossible via UI if they are used at least one time. Therefore, I would like to interchange product_id of account_invoice_line with another one. My problem is, that I do not know what are the dependencies to other tables when doing that.
What I have just tried, is do do:
alter table account_invoice_line disable trigger all
update account_invoice_line set product_id = 100 where product_id = 2
I am familiar with SQL, that is not problem - but I do not know if this change is enough as I can estimate the dependencies to other models. Could anybody guide me in clearing my database of undesired products already used?
Have you seen https://www.odoo.com/apps/7.0/object_merger/ - you can create the product you want, select anything you want to have merged into it and the module will correctly navigate through every part of the system, essentially finding all of the old product and replacing them with the new product.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 8/10/14, 4:06 PM|
|Seen: 1402 times|
|Last updated: 3/16/15, 8:10 AM|