Delete duplicate customer

Question

Is there a way to delete all duplicates entries form the CRM customer table?
I imported a csv file into customers but at the end of the process it throw me an error so I tried again. When I looked into my customer directy they were all there but duplicate. is there a way to delete the duplicate or empty the table and start do a new import?

Denis Baranov · Answer

It seem that this module - https://apps.odoo.com/apps/modules/9.0/crm_duplicates/ - would be of use

Abhishek · Answer

Hi,
I think it will better open pgadmin and look your duplicate customer

*SELECT name FROM res_partner GROUP By name HAVING ( COUNT(*) > 1 )*

then you will find all the customer which is more then one in entry in customer table, and after this go in relevant python file of customer and put _*sql_constraint* for name or name or code combination so next time when you upload or create the same entry it will give a pop-up and will be not allowed to enter duplicate customer name.

Ronald Luna · Answer

Understood. Thanks!

Simplify it! · Answer

You have to do it manually or if you have access to postgresql you can make a SQL sentence to delete all the table

Related Posts	Replies	Views
How to add a contact to an existing contact which is also a contact of another contact crm customers	0 Aug 24	196
Odoo 11 - Import Sales/Customer or Contacts Won't Map Company Name import customers	2 Apr 18	5161
What is the structure of the CVS to import as customer in to openERP? crm import	1 Mar 15	2499
Prevent duplicate importing bank statement import duplicate bankstatement	1 Nov 23	837
Excel update records audit trail crm import Excel	0 Dec 21	1423

This question has been flagged

Enjoying the discussion? Don't just read, join in!