Match name plugin
Why do you need it
We've noticed the CRM Duplicate detection doesn't allow for much creativity, you can only create Duplicate Detection Rules with the following condition:
- full string match
- begins with (number of characters)
- ends with (number of characters)
The problem with this is that people or companies aren't always entered in the same format. For instance if you look at our company name we would create the account with the name "Orbit One". Other people might write "Orbit One BVBA" (the bvba part is a
type of business entity)
There are some other examples that come to mind:
"Dell NV" vs "Dell"
"HP Belgium" vs "HP"
"Gaëtan" vs "Gaetan"
"François" vs "Francois"
These exceptions will never be caught by the default CRM Duplicate detection.
How can I fix this?
We added the following attributes and filled the with data:
- on account => new_matchname (contains the accounts name)
- on contact => new_matchname (contains the contacts first + lastname)
- on lead => new_matchcontact (contains the leads first+ lastname)
- on lead => new_matchcompany (contains the lead company name)
The fields are filled with a normalized name. The process is:
- to lower case and trim.
- replace special characters (except parenthesis, a-z, 0-9, special characters like éèàç ..., and spaces) with empty string.
- remove everything between the parentheses eg: "HP (was Compaq)" becomes "HP"
- remove suffixes and prefixes that are type of business entity
- remove all spaces
- replace special characters (eg: é > e, à => a, ç => c, ñ => n, ...)
Next there need to be some new duplicate detection rules.
- full string match on new_matchname for contact
- full string match on new_matchname for account
- full string match on new_matchcontact for lead (add companyname if needed in your specific cases)
The current implemented
type of business entity which will be stripped are:
- nv
- sa
- vzw
- bvba
- cvba
- sarl
- sprl
- scrl
- nvsa
- bv
- llc
- gmbh
- ltd
- ag
- kt
- og
- vof
- cvoa
- commva
- commv
- ebvba
- ez
- belgium
Some screenshots
