Tip #7: Combina registros duplicados

Tip #7: Combina registros duplicados

Tips and tricks #07, adaptado de Aishwarya EK
¡Hola de nuevo, usuarios!

Este mes, dedicado a la limpieza y mantenimiento de las bases de datos en Zoho CRM, nos ha traído tips como el uso de hojas de estilo y los campos únicos para evitar duplicados. Si quieres que hablemos sobre alguna temática de CRM en concreto, por favor déjalo en los comentarios.

Esta semana te enseñamos un nuevo tip para mantener tu base de datos limpia.

Tip #8: Combina registros duplicados
  • Mantener una hoja de estilo para una base de datos de CRM limpia: HECHO ✓
  • Crear campos únicos para evitar registros duplicados: HECHO ✓

Durante estas semanas hemos aprendido a evitar la creación de registros duplicados. Pero tal vez ya tenías tu base de datos antes de ver estos tips y no sabes si tu base de datos contiene duplicados. Si te preguntas como localizar y arreglar estos registros duplicados, puedes usar herramientas de de-duplicación para hacer limpieza. Veamos cuándo y cómo utilizar estas herramientas en Zoho CRM.

Encuentra y combina registros duplicados

En ciertas ocasiones puede que sepas que algunos registros tienen entradas duplicadas en tu cuenta de Zoho CRM. En este caso, puedes ir directamente a la página detalle de este registro y utilizar Buscar y combinar duplicados.

Módulo Posibles Clientes > clic en un registro > (...) > Buscar y combinar duplicados.

Por ejemplo, sabes que hay un posible cliente con el nombre "Marta Martín" que ha sido duplicado, y quieres encontrar los registros con el mismo nombre y combinarlos en un único registro.

Primero, marca los registros que quieras combinar de la lista de registros encontrados:



Segundo, marca qué campos quieres conservar de cada registro:



Y haz clic en "Combinar".

Deduplicar registros (Auto-combinación de duplicados)

Esta herramienta es especialmente útil cuando tienes dudas de si tu cuenta de CRM contiene registros duplicados, pero no sabes cuáles. Puedes dejar que Zoho CRM haga una revisión completa por cada módulo utilizando la herramienta de deduplicados.

Tomemos el siguiente ejemplo. En el módulo de Posibles Clientes, haz clic en el símbolo (...) y selecciona Deduplicar Posibles Clientes. Selecciona los registros sobre los que quieres realizar la revisión de duplicados, por ejemplo: nombre de la empresa y cuenta de correo electrónico. Zoho CRM buscará aquellos registros en el módulo Posibles Clientes en los que los valores de los campos nombre de la empresa y cuenta de correo electrónico sean iguales. Automáticamente, CRM encontrará y combinará aquellos campos que sean exactamente iguales. En caso de conflictos, puedes resolverlos de manera manual.

Módulo Posibles Clientes > (...) > Deduplicar Posibles Clientes.

Deduplicar contactos de forma automática:


Deduplicar contactos con conflictos de manera manual:




En este caso, la misma cuenta de correo tiene dos números de teléfono asociados, por lo que deberás escoger entre uno de ellos o quedarte ambos.

Y con esto y un bizcocho...¡los registros duplicados han desaparecido!

Haz clic en este enlace para aprender más sobre las herramientas de de-duplicación en Zoho CRM.

¿Conocías esta función? ¿Qué te parece? ¡Añádelo en los comentarios!


      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ




                                ご検討中の方

                                  • Recent Topics

                                  • Zoho CRM Formula - Current Time minus Date/Time field

                                    Hello, I am trying to prevent duplicate emails going to clients when more than 1 deal is being updated. To do this, I would like to create a formula to identify if a date/time field is >= 2 hours ago. Can someone please help me write this formula? Example:
                                  • Per Level Approval for admins

                                    We need Process admins like Zoho CRM in Zoho Books for per stage approval Currently in books, admins only have the option for Final Approval But for example, in cases like when an employee is on leave, we can't just approval one level we only have option
                                  • Billing Management: #7 Usage Billing in Telecom & Internet Service Provider

                                    Telecom and Internet Service Providers operate in markets where usage varies drastically from one customer to another. While flexible, usage-based models align revenue directly with consumption, they also introduce operational challenges like real-time
                                  • Zoho Sprints - Q3 updates for 2025

                                    The updates for the third quarter of 2025 are out. A few significant features and enhancements have been rolled out to improve user experience and product capabilities. The following are the updates: Manage tags and cluster tags Record and maintain project
                                  • Kaizen #208 - Answering your Questions | Functions, AI and Extensions

                                    Hello Developers! Welcome back to a fresh week of Kaizen! We are grateful for your active participation in sharing feedback and queries for our 200th milestone. This week, we will answer the queries related to Functions and Extensions in Zoho CRM. 1.
                                  • Zoho Projects Webhook fails with HTTP Error 0

                                    Hello Zoho Community, I am pulling my hair out over this one. I have setup a very basic http(s) server that always responds "ok" and code 200 to incoming GET requests. It will accept any parameters, and any path. Really, all it does is say "ok," and log
                                  • Zoho CRM still doesn't let you manage timezones (yearly reminder)

                                    This is something I have asked repeatedly. I'll ask once again. Suppose that you work in France. Next month you have a trip to Guatemala. You call a contact there, close a meeting, record that meeting in CRM. On the phone, your contact said: "meet me
                                  • Creating Restaurant Inventory Management on Zoho

                                    Hi,  We run a small cloud kitchen and are interested to use Zoho for Inventory and Composite Item tracking for our food served and supplied procured to make food items.  Our model is basically like subway where the customer can choose breads, veggies,
                                  • To Zoho customers and partners: how do you use Linked Workspaces?

                                    Hello, I'm exploring how we can set up and use Linked Workspaces and would like to hear from customers and partners about your use cases and experience with them. I have a Zoho ticket open, because my workspace creation fails. In the meantime, how is
                                  • Zoho Forms to Zoho CRM : First/Last Name to just Name ?

                                    When integrating a Zoho Form into the Accounts menu of the CRM I'm having trouble with how names are formatted ; In Forms the data is available as First Name or Last Name In the CRM there is only one field called Name How can I ensure that "John" "Smith"
                                  • Enhancements to the formula field in Zoho CRM: Auto-refresh formulas with the "Now" function, stop formula executions based on criteria, and include formulas within formulas

                                    Dear Customers, We hope you're well! By their nature, modern businesses rely every day on computations, whether it's to calculate the price of a product, assess ROI, evaluate the lifetime value of a customer, or even determine the age of a record. With
                                  • This festive season, offer discounts with coupon code support in Stripe Checkout

                                    Hello form builders! It’s the festive season, the perfect time to spread joy and great deals! Now, with Zoho Forms’ latest enhancement for Stripe Checkout, you can do exactly that with coupon codes! Your payment forms integrated with Stripe Checkout can
                                  • Cómo creo una factura negativa o de abono?

                                    NEcesito anular una factura y crear una nueva igual pero en negativo. El sistema no me lo permite
                                  • Power of Automation::Streamline log hours to work hours upon task completion.

                                    Hello Everyone, A Custom Function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as to when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:-
                                  • Is CRM On Premise available

                                    Hi Zoho team, Can you please let me know that CRM Zoho is available for On Premise as well? Thanks, Devashish
                                  • Last activity time is acting like last modified time

                                    When i edit the description or any field in the potential, account, contact and lead, the Last Activity Time is being updated like the Modified Time. This is messing all workflows and reports and we are unable to track real last time of activities like
                                  • CRM : Function to add user name to text field

                                    I have a lookup field in a module that is linked to the CRM users so we can assign a Project Lead to the customer. Sadly Zoho Marketing Automation doesn't sync Lookup fields so I need to extract information from the lookup to text fields: Lookup field
                                  • Zoho CRM - Restrict Login based on work hours

                                    Hi there, I'm wondering if we can restrict users to login during works - For example the users would be able to login from 8am to 5pm. I have seen the IP address restriction - the only downfall is what if the customer has dynamic IP. thanks Jiri
                                  • Tips and Tricks #46: Customize themes and templates using Show's Master View

                                    Hi All!  Let's say you want to revamp your presentation and make changes to its visual design. You can do this easily using the Master Slide and its associated layouts. The Master Slide stores information about all the layouts used in the presentation.
                                  • Currency abbreviations

                                    Hello, Im stuck, and need help. I need the currency fields for example, opportunity value, or total revenue, to be abbreviated, lets say for 1,000 - 1K, 1,000,000 - 1M, and so on, how should I do this?
                                  • Sheet View in CRM portal

                                    Hi, When will it be possible for my CRM portal users to edit/add records with Sheet View? George
                                  • What's New in Zoho Invoice | July - September 2025

                                    Hello everyone! We’re back with the latest updates and enhancements we’ve rolled out in Zoho Invoice from July to September 2025. Here’s what’s new this quarter: Introducing the Singapore Edition in Zoho Invoice Share Invoices through WhatsApp GST 2.0
                                  • Alert: Audio Call Support to be discontinued for Old Live Chat Widget from December 31, 2025

                                    Action Required: Upgrade to the New SalesIQ Live Chat Widget We're reaching out with an important update regarding the SalesIQ Live Chat Widget that requires your immediate attention. Effective December 31, 2025, audio call functionality will no longer
                                  • 【開催間近 - 10/17】東京 ユーザー交流会 Vol.3 参加登録 受付中!(参加無料)

                                    ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 10/17(金)に、東京・新橋で「東京 ユーザー交流会 Vol.3」を開催します! ZOHOLICSよりも小規模なイベントですので、「リアル開催はちょっと緊張する…」という方も、安心してご参加いただけます✨ 当日は、初公開の事例を2つご紹介予定です! なお、セッション映像のアーカイブ配信は予定していないため、会場にお越しいただいた方だけが、登壇者へ直接質問したり、リアルな声を聞いたりできる貴重な機会となっています。 ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー
                                  • multiple contacts for one account

                                    We currently use Zoho CRM where each Account represents a club or organization, and each Contact represents a manager or owner. However, some of our managers own or manage multiple clubs, and Zoho only allows a contact to be linked to one account at a
                                  • Rich text Merge field - Not using font specified in HTML

                                    I have a rich text merge field in a writer template which is creating a table. I have chosen to use this method instead of a repeat region because I need to specify specific cell background colours which change every time the document is created. The
                                  • Can't change form's original name in URL

                                    Hi all, I have been duplicating + editing forms for jobs regarding the same department to maintain formatting + styling. The issue I've not run into is because I've duplicated it from an existing form, the URL doesn't seem to want to update with the new
                                  • ヒートマップ詳細設定について

                                    はじめまして マーケティング担当の浅田です。 PageSenceのヒートマップ設定について質問です。 単一ページ毎の設定は上手くできるのですが 詳細設定にて、トップページのURLを含ませ全体のヒートマップを計測できないか試したところ お知らせ:データを受信していません。と表示されてしまいます。 トップページURLで始まるページの条件も試しております。 全頁を反映させたいと思い、詳細設定を上手く設定できたらと考えております。 どなたか詳しい方がいらっしゃいましたら、教えて頂けませんでしょうか 宜
                                  • Automatic category assignment

                                    Hi, I’d like to ask if there is a way to automatically assign an expense category based on the recognized Merchant. What would be the simplest way to set up automatic category assignment? Alternatively, is there an option to first choose the category
                                  • Need Help to setup plugs along with codeless bot buidler. To send sms OTPs to users via Zoho Voice and to verify it

                                    Need Help to setup plugs along with codeless bot buidler. To send sms OTPs to users via Zoho Voice and to verify it. I get leads from our website and we need to make sure those are not junk. So we are using proactive chat bot and we need mobile OTPs to
                                  • Experience with Zoho Vertical Studio

                                    I'm considering Zoho Vertical and would love to hear from some devs who've been using it. The Zoho ecosystem is pretty solid, so I assume the experience has been pretty good, but sometimes Zoho has its quirks. Overall, has your experience been positive?
                                  • LinkedIn Chrome Extension

                                    Hello - I believe it is a known issue that the LinkedIn extension Resume Extractor has stopped working and they are working on potential fixes. Wondering how others users are finding this issue and if there are any better workarounds for this issue? It
                                  • Advance PDF creation from CRM data

                                    I'm trying to create a PDF export of data in the CRM. My problem is I want a pretty complicated format for the data. I'm trying to export multiple modules worth of data, with nested one-to-many relationships between the modules. Along with that, I want
                                  • Where does this report come from in the Zoho One ecosystems?

                                    Is this directly from MA, Analytics or ??? ???
                                  • Sub-Form Padding in CSV Export

                                    Hi, When you use the Sub-Form, and for example you have a Date Field on the Main Page, then Option 1 and Option 2 fields on the Subform, when you export this to CSV the Date column will only have the Date in 1 row, the first row, it would be nice to pad
                                  • More Formula Functions

                                    Hi, I would ike for example to be able to have a Date Field and Formula Fields, and then in the Formula Fields I would like to grab just the Month of the above Date Field or the Week Number of the above Date Field. So more "Functions" than the current
                                  • File upload size limits

                                    I am designing a contact form in Zoho Creator with File upload facility. I am not sure where and how to set the following properties for the same: Allowed File Types Maximum Size of the Attachment Number of Attachments
                                  • Composite Services and Account Tracking

                                    I am looking to garner support/request the ability to make composite services. A quick search in the forums brings up multiple requests for this feature. I fail to see why an item is mandatory while services are optional. I also would like to see the
                                  • All operation codes getting Not applied in WO-TT22J1025WOR0471, SR-TT22J1025PRE0423,FOR VIN-W1K6G2AB2SL005130.

                                    Dear Support Team, Please refer attached screenshot. All operation codes getting not applied in work order. Request you to please check and update ASAP.
                                  • Customer Grouping

                                    Hi, how can I group multiple customers into single group. So that I can have idea of accounts receivables of all the customers in single group. Like if there are multiple subsidiaries of same company we have having a business with, and want to view the
                                  • Next Page