Odoo Help


How to remove duplicate products from the system without affecting sales orders for those duplicate products ?

on 5/14/13, 5:10 AM 3,857 views

I have a system where there are duplicate copies of products and also sales orders for those duplicate products. I need to remove duplicate entries of products without affecting a single sales order that depend on those duplicate product. I cannot do it manually because there are 1500 products and 1000 sales orders.

Igor MF
On 6/30/14, 11:10 AM

Have you tried an app called Product Merge? It doesn't work, however, if the duplicates are in different UOMs...

Otherwise, you'd have to uncheck "Active" in the duplicate you want to deactivate and leave it hidden...

On 5/14/13, 6:22 AM


if the order is validated you can not change it.

and you can not remove products while other records still reference it.

so I think the only solution is to make SQL requettes in postgresql.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 5/14/13, 5:10 AM
Seen: 3857 times
Last updated: 3/4/17, 1:26 PM