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	6234
What is the structure of the CVS to import as customer in to openERP? crm import	1 3月 15	3289
Prevent duplicate importing bank statement import duplicate bankstatement	1 11月 23	2006
Excel update records audit trail crm import Excel	0 12月 21	2336

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！