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

관련 게시물	답글	화면
How to add a contact to an existing contact which is also a contact of another contact crm customers	0 8월 24	196
Odoo 11 - Import Sales/Customer or Contacts Won't Map Company Name import customers	2 4월 18	6877
What is the structure of the CVS to import as customer in to openERP? crm import	1 3월 15	4018
Prevent duplicate importing bank statement import duplicate bankstatement	1 11월 23	2765
Excel update records audit trail crm import Excel	0 12월 21	2950

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!