Vtiger now prevents duplicate record creation, and all the awkward situations that come with it

If you’ve wanted to upload data to Vtiger from a CSV file, or integrate it with third party software, but were worried that overlapping data in Vtiger and the external source might generate those dreaded duplicate records – we’ve got good news for you. Vtiger now automatically prevents duplicate record creation.

NOTE: In response to some emails we’ve received, we’d like to clarify that this tool is technically more useful than our existing deduplication tools – it provides 24/7 automatic protection against the emergence of duplicates from all sources. Users can set much more complex rules for determining when a record should be considered a duplicate (ex: a matching first name, last name, & company name), and the tool works continuously in the background to prevent duplicates from any manual or automatic record generation source, not just record imports from a CSV file. It even prevents duplicate records from being created when two different records are later edited to match each other. We actually hope that it outright eliminates the need for deduplication later on.

Duplicate records are among the most well known inconveniences of using software to manage important data. They creep in when people add or upload contacts and deals, synchronize data with third party software, and through basically any process that brings data into a CRM – and they wreak havoc on productivity.

Dealing with those extra records does more than waste peoples’ time. The same Bob Smith appearing twice in a sales pipeline, for example, can result in two sales associates trying to win the same man’s business. But while those sales associates may eventually discover and rectify the discrepancy, many duplicate records go undiscovered, and they almost always flow into important but unfortunately inaccurate reports. If those duplicate records happen to be of a contact or a deal, they can also create a disjointed and painfully confusing customer experience, say, when a loyal customer is treated like a stranger because the incomplete version of their contact record is used as the basis of an email or conversation.


Vtiger lets you set-it, and forget-it, to prevent duplicates

With Vtiger’s March update, we bring you a “set-it-and-forget-it” way to prevent duplicate records. You tell Vtiger what combination of fields are together considered unique, and Vtiger makes sure that only one of those combinations ever exists in the system. Whether you consider a record unique based on a single record number, or on a combination of factors like a first name, last name, and company name, Vtiger will check for duplicates before they are created. This check is also done during sync operations (ex: with Google Contacts, Quickbooks, ..etc), with the ability to set either Vtiger or the external system as the master.

Here how to set up duplicate handling it in Vtiger

  1. Brows to Menu > All Settings > Module Manager > Module Layouts & Fields
  2. Select the desired module from the dropdown menu
  3. Click on the Duplicate Prevention tab
  4. Flip the Enable Duplicate Check switch
  5. In the text-box, add between one and three fields that together make up a unique record. That could be a unique record number, a first and last name, or a first and last name and an organization name.
  6. Set one of three ways that you’d like Vtiger to address any duplicates it finds when records are added to Vtiger
    • Use only the most recent copy
    • Use the internal copy
    • Use the external copy

Vtiger handles duplicates from a single record creation, CSV import, workflow, or a sync from a 3rd party application a little differently, so head on over to our duplicate record handling documentation if you’re interested in the nitty gritty details. Once configured, though, Vtiger prevents duplicates that could come from any source.

Have any questions about duplicate record creation, or want to talk about other challenges that stop you from using your CRM to the fullest? Leave us a comment in the box below, or send us an email at support@vtiger.com. We just might build and feature a solution to your problem in our next blog post!

CRM Trends-06

Key CRM Trends to Improve Business Performance

Customer Relationship Management (CRM) software has evolved drastically - from a file that holds customer information like the Rolodex to a tool that stores customer ...
Contact Management 5 (1)

Track Your Customer Journey and Win More Deals with Vtiger Contact Management

Customers are essential for a business to grow. And the more customers you have, storing and sharing data becomes complicated. Many organizations use multiple tools ...
Contact Management Generic Blog Banner-07

Manage Your Contact Data to Close Sales Deals Faster

Today, businesses are not just aiming for profits but also focusing on creating lasting relationships with customers. Closing a deal is just one aspect of ...
Sales Enablement Blog- Vtiger Specific-01

Boost Conversion Rates with Vtiger Sales Enablement Tools

Due to covid-induced lockdown, many businesses have switched to remote work culture. But has the new work environment changed business dynamics? Yes, employees working from ...
Sales Enablement Blog Banner-02

6 Key Elements to Build Your Sales Enablement Strategy

Every move you make in your business is predominantly based on the revenue you want to earn. And revenues are dependent on achieving forecasted sales ...
One View Blog-02

6 Benefits of Using Vtiger One View

According to Gartner, 14% of organizations have gotten accustomed to a 360-degree feature in a CRM1. There are many reasons why more enterprises are getting ...
Razorpay Integration image 4

Secure your payments with Vtiger – Razorpay Integration

Adopting a digital payment strategy is one of the most valuable solutions for businesses and consumers to improve business performance. From automated invoicing and payment collections ...
Hero Image

5 Reasons to Automate your Business Process with Vtiger Process Designer

“If I had one hour to save the world, I would spend fifty-five minutes defining the problem and only five minutes finding the solution." - Albert ...
Vtiger URL Shortener

Vtiger URL shortener for secure, reliable short links to optimize your campaigns

Every web page will have a URL with various parameters added; however, this can get lengthy. Besides filtering, organizing, and presenting the content to users, ...
Banner Image-02

Save effort & time by using Vtiger – Zoho Sign integration

Every organization's day-to-day operations include a significant amount of paperwork. Several clauses, contracts, and paperwork must be signed. Electronic signatures are the most sophisticated method ...
Copyright 2022 Vtiger | Privacy | Policy & Legal Center