Avoid duplicate contacts

Question

Hello,
I have a problem in my community odoo 13 version, I want to avoid typing duplicate contacts.
If a contact already exists, that if we want to create the same contact, it blocks.
Does anyone know how I can do this?
King regards

Josep Anton Belchi Riera · Answer

You can create an automated action to prevent duplicates. The point is to know when a record is a duplicate (same reference, same name?)
Here is a good example  https://odootricks.tips/automated-action-to-prevent-duplicates/ [1]

[1] https://odootricks.tips/automated-action-to-prevent-duplicates/

Thomas Guénard · Answer

you can create an automated action (using studio for instance)* there you setup the filters which suits your needs* anf finally you add the following code within the python window* exists = env['res.partner'].search([('name' , 'ilike' , object.name),('supplier','=',True),('id','!=',object.id)])
if exists:
raise Warning('ce fournisseur "' + object.name + '" a déjà un enregistrement!')
*

Yeison X · Answer

Hi,
I want to avoid the duplication using the Identification Type Number and the Identification Number. But when I create a "child" contact of a contactad that I already have, Odoo tell me that I am duplicating because this new contact receive the same tax id.

Equick ERP · Answer

Hello
You may like our apps for remove duplicate data from table.
https://apps.odoo.com/apps/modules/11.0/eq_merge_duplicate_data_extended/

This question has been flagged

you can create an automated action (using studio for instance)

there you setup the filters which suits your needs

anf finally you add the following code within the python window

exists = env['res.partner'].search([('name' , 'ilike' , object.name),('supplier','=',True),('id','!=',object.id)])
if exists:
raise Warning('ce fournisseur "' + object.name + '" a déjà un enregistrement!')

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