{"id":12508,"date":"2021-12-02T13:33:29","date_gmt":"2021-12-02T21:33:29","guid":{"rendered":"https:\/\/www.vtiger.com\/blog\/?p=12508"},"modified":"2021-12-02T13:33:29","modified_gmt":"2021-12-02T21:33:29","slug":"big-little-things-find-duplicates","status":"publish","type":"post","link":"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/","title":{"rendered":"Big Little Things – Find Duplicates"},"content":{"rendered":"

Welcome back to Big Little Things, where we highlight some of the lesser-known and sometimes overlooked features and enhancements in Vtiger CRM that pack a big punch. By taking a deeper look at and exposing some of these features, our goal is to help ensure our users are deriving the most benefits possible while using our CRM.<\/p>\n

This blog highlights the Find Duplicates module. Let\u2019s dive in and discover what the Find Duplicates feature is all about and how it can be used to clean up your database while ensuring that users have the most relevant up-to-date data in their CRM. We will also discuss a few other ways to find duplicates in the CRM using List View searches, One View, and Global Search.<\/p>\n

What Is The Find Duplicates Module?<\/b><\/p>\n

\"Duplicate4\"<\/p>\n

The Find Duplicates<\/a> module is available in all editions of Vtiger and can be found in the Tools App under the Data Management category. It allows users to easily search for and identify duplicate records based on field values in specific modules. After identifying the duplicate records users can then decide how to best manage them.<\/p>\n

Using Find Duplicates<\/b> <\/p>\n

Once the Find Duplicates module is opened, users will be prompted to select a module, list, and field(s) values that they would like to search for to identify duplicate records. Users also have the option to ignore empty field values and check closed records for duplicates.<\/p>\n

\"Duplicate1\"<\/p>\n

After entering in all the criteria and hitting search, the system will quickly identify and present all duplicate records found, in a list view. From there, users can select the relevant records and decide how they would like to manage them, by using either the Delete or Merge options.<\/p>\n

\"Duplicate2\"<\/p>\n

Merging Duplicate Records<\/b><\/p>\n

\"Duplicate3\"<\/p>\n

When using the merge option, users can select up to three records at once to then merge into one. Selected records are displayed in a grid format allowing the user to select individual fields they would like to retain in the final merged record. It\u2019s incredibly helpful to be able to get a clear visual of all the duplicate records with their fields laid out side-by-side. This ensures that users retain the most accurate and up-to-date information from all the duplicate records while also decluttering and cleaning up their database. <\/p>\n

Deleting Duplicate Records<\/b><\/p>\n

\"Duplicate6\"<\/p>\n

Deleting duplicate records is made easy using the Find Duplicates module. Users can simply select the duplicate records they want to delete and with a few clicks delete multiple records at once. Records that are deleted will also be stored in the recycle bin for 30 days before being fully deleted, allowing users to recover any records and their data deleted by mistake.<\/p>\n

Other Ways to Find Duplicate Records<\/b><\/p>\n

There are three other ways to find duplicates in the CRM. I have summarized them further, below:<\/p>\n

One View<\/b><\/p>\n

\"Duplicate9<\/p>\n

After installing Vtiger\u2019s Calculus AI<\/a> Extension, users will be able to see and quickly access duplicate Deal records displayed while viewing a Deal record in One View<\/a>. By default, Calculus AI checks the \u201cDeal Name\u201d field for duplicate text, but will also display duplicate records based on any fields you have set up using Duplicate Prevention<\/a> on the Deals module. <\/p>\n

List View Search<\/b><\/p>\n

\"Duplicate7<\/p>\n

Users can use List View search to find duplicate records by entering unique values into the search boxes. Once duplicate records have been located, users can select multiple records and use List View Actions<\/a> to merge or delete the records. <\/p>\n

Global Search<\/b><\/p>\n

\"Duplicate<\/p>\n

Similar to List View Search, users can enter unique values such as email addresses, phone numbers, etc\u2026 into the Global Search<\/a> search box to find duplicate records. There are limitations on how to handle duplicate records after locating them using Global Search. For example, you cannot merge or delete records using the Global Search feature. You can only access the records individually to delete the records or revert to using the List View Actions or Find Duplicates features to merge or delete multiple records at once. <\/p>\n

<\/p>\n

Take Vtiger for a Test Drive Today<\/b><\/p>\n

Click here<\/a> to sign up for a 15-day free trial or try our forever free Pilot edition.<\/div><\/p>\n","protected":false},"excerpt":{"rendered":"

Welcome back to Big Little Things, where we highlight some of the lesser-known and sometimes overlooked features and enhancements in Vtiger CRM that pack a big punch. By taking a deeper look at and exposing some of these features, our goal is to help ensure our users are deriving the most benefits possible while using… .Big Little Things – Find Duplicates<\/span><\/a><\/p>\n","protected":false},"author":42,"featured_media":12540,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"_ti_tpc_template_sync":false,"_ti_tpc_template_id":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-12508","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-all"],"yoast_head":"\nBig Little Things - Find Duplicates - Vtiger CRM Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Big Little Things - Find Duplicates - Vtiger CRM Blog\" \/>\n<meta property=\"og:description\" content=\"Welcome back to Big Little Things, where we highlight some of the lesser-known and sometimes overlooked features and enhancements in Vtiger CRM that pack a big punch. By taking a deeper look at and exposing some of these features, our goal is to help ensure our users are deriving the most benefits possible while using… .Big Little Things – Find Duplicates\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/\" \/>\n<meta property=\"og:site_name\" content=\"Vtiger CRM Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vtiger\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vtiger.com\/blog\/wp-content\/uploads\/2021\/12\/Big-Little-Things-91-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3334\" \/>\n\t<meta property=\"og:image:height\" content=\"1250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Josh Rich\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@vtigercrm\" \/>\n<meta name=\"twitter:site\" content=\"@vtigercrm\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Josh Rich\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Big Little Things - Find Duplicates - Vtiger CRM Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/","og_locale":"en_US","og_type":"article","og_title":"Big Little Things - Find Duplicates - Vtiger CRM Blog","og_description":"Welcome back to Big Little Things, where we highlight some of the lesser-known and sometimes overlooked features and enhancements in Vtiger CRM that pack a big punch. By taking a deeper look at and exposing some of these features, our goal is to help ensure our users are deriving the most benefits possible while using… .Big Little Things – Find Duplicates","og_url":"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/","og_site_name":"Vtiger CRM Blog","article_publisher":"https:\/\/www.facebook.com\/vtiger","og_image":[{"width":3334,"height":1250,"url":"https:\/\/www.vtiger.com\/blog\/wp-content\/uploads\/2021\/12\/Big-Little-Things-91-1.png","type":"image\/png"}],"author":"Josh Rich","twitter_card":"summary_large_image","twitter_creator":"@vtigercrm","twitter_site":"@vtigercrm","twitter_misc":{"Written by":"Josh Rich","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/#article","isPartOf":{"@id":"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/"},"author":{"name":"Josh Rich","@id":"https:\/\/www.vtiger.com\/blog\/#\/schema\/person\/b66f64b89472808592ef2ce7b442ef59"},"headline":"Big Little Things – Find Duplicates","dateModified":"2021-12-02T21:33:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/"},"wordCount":692,"commentCount":0,"publisher":{"@id":"https:\/\/www.vtiger.com\/blog\/#organization"},"articleSection":["All"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/","url":"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/","name":"Big Little Things - Find Duplicates - Vtiger CRM Blog","isPartOf":{"@id":"https:\/\/www.vtiger.com\/blog\/#website"},"dateModified":"2021-12-02T21:33:29+00:00","breadcrumb":{"@id":"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vtiger.com\/blog\/big-little-things-find-duplicates\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vtiger.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Big Little Things – Find Duplicates"}]},{"@type":"WebSite","@id":"https:\/\/www.vtiger.com\/blog\/#website","url":"https:\/\/www.vtiger.com\/blog\/","name":"Vtiger CRM Blog","description":"Latest CRM Topics, Tips, Insights and Updates","publisher":{"@id":"https:\/\/www.vtiger.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vtiger.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vtiger.com\/blog\/#organization","name":"Vtiger","url":"https:\/\/www.vtiger.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vtiger.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.vtiger.com\/blog\/wp-content\/uploads\/2023\/02\/vtiger-logo-only.png","contentUrl":"https:\/\/www.vtiger.com\/blog\/wp-content\/uploads\/2023\/02\/vtiger-logo-only.png","width":490,"height":399,"caption":"Vtiger"},"image":{"@id":"https:\/\/www.vtiger.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vtiger","https:\/\/twitter.com\/vtigercrm"]},{"@type":"Person","@id":"https:\/\/www.vtiger.com\/blog\/#\/schema\/person\/b66f64b89472808592ef2ce7b442ef59","name":"Josh Rich","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vtiger.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/119a81e88950c261f31b69a646a2e9ec?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/119a81e88950c261f31b69a646a2e9ec?s=96&d=mm&r=g","caption":"Josh Rich"},"url":"https:\/\/www.vtiger.com\/blog\/author\/joshrich\/"}]}},"_links":{"self":[{"href":"https:\/\/www.vtiger.com\/blog\/wp-json\/wp\/v2\/posts\/12508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vtiger.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vtiger.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vtiger.com\/blog\/wp-json\/wp\/v2\/users\/42"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vtiger.com\/blog\/wp-json\/wp\/v2\/comments?post=12508"}],"version-history":[{"count":0,"href":"https:\/\/www.vtiger.com\/blog\/wp-json\/wp\/v2\/posts\/12508\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vtiger.com\/blog\/wp-json\/wp\/v2\/media\/12540"}],"wp:attachment":[{"href":"https:\/\/www.vtiger.com\/blog\/wp-json\/wp\/v2\/media?parent=12508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vtiger.com\/blog\/wp-json\/wp\/v2\/categories?post=12508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vtiger.com\/blog\/wp-json\/wp\/v2\/tags?post=12508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}