Skip to Content
This question has been flagged
crmimportcustomersduplicate
4 Respostes
10634 Vistes
Avatar
Ronald Luna

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?

Avatar
Descartar
Avatar
Denis Baranov
Best Answer

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

Avatar
Descartar
Avatar
Abhishek
Best 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.

Avatar
Descartar
Avatar
Ronald Luna
Autor Best Answer

Understood. Thanks!

Avatar
Descartar
Avatar
Simplify it!
Best 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

Avatar
Descartar
Related Posts Respostes Vistes Activitat
How to add a contact to an existing contact which is also a contact of another contact
crm customers
Avatar
0
d’ag. 24
196
Odoo 11 - Import Sales/Customer or Contacts Won't Map Company Name
import customers
Avatar
Avatar
2
d’abr. 18
6877
What is the structure of the CVS to import as customer in to openERP?
crm import
Avatar
Avatar
1
de març 15
4019
Prevent duplicate importing bank statement
import duplicate bankstatement
Avatar
Avatar
1
de nov. 23
2767
Excel update records audit trail
crm import Excel
Avatar
0
de des. 21
2950