Upsert your missing data without affecting the historic logs

Dear Customers,

We hope you're well!

Migrating your data from a legacy system to Zoho CRM is a critical operation as it deals with treasured data. In an unfortunate event, if you have missed to move your historical datasets, you have had to repeat the migration process all together to protect the integrity of their timeline. With a huge volume of data at hand, repeating this process is painstakingly redundant and time-consuming and that's why we have come up with a useful enhancement to upsert data.

The Upsert operation 

Upsert is a database operation that enables you to update data to an existing record or insert data to the original database while simultaneously ensuring relevance and accuracy.

 

As opposed to module imports where data added or updated is considered as edits to the records, upserting datasets is meant to patch the data with the existing database without altering their chronology and timeline.

How are we ensuring integrity while restoring missing data?

While our goal is to restore missing data to the database seamlessly, we are also aware of how the migrated data could have been put to use in Zoho CRM or how the older values could have been altered, changing their original timestamps. With these potential consequences in place, upserting missed data might question its relevance to the current process and thus we are leaving the decision to choose the desired data at the hands of admins through an action called Upsert Resolution.

 

The Upsert resolution:

Upsert resolution is like a gatekeeper. Based on the nature of your conflict, it lets you decide what desired data to upsert.

At this juncture, you have two data at hand:

• Data already migrated to the system
  
• File with data to upsert
  

 

As an admin, you would have a better knowledge of which data is right at the time of upsert. You would know if it is better to keep the new values per the process or retain the legacy values. Based on this judgment, you can choose your upsert resolution.

Untouched records indicate migrated records that are not modified after migration. By selecting untouched records as upsert resolution, you are intending to update only those records that are not "touched" for modification.

Selecting "All records" instructs the system to update all records in the system irrespective of them being modified after migration or not.

If you'd like to restore or retain empty values, you can also do so after selecting this preference.

That's all about seamlessly stitching legacy data back to its database. If you have questions or feedback about this enhancement, drop them in the comments section—let's connect!

Release plan: The Upsert operation is available for customers in all DCs.

Editions: Available for editions from Free to Ultimate

CRM Availability: You can use this Upsert operation in both the UIs.

Help doc: CRM Old UI | CRM New UI 

 

May the right data win!

 

Kind regards,

Saranya Balasubramanian,

CRM Marketing

• Topic Participants

• Saranya Balasubramanian

  

• Sticky Posts

• Presenting ABM for Zoho CRM: Expand and retain your customers with precision

  Picture this scenario: You're a growing SaaS company ready to launch a powerful business suite, and are looking to gain traction and momentum. But as a business with a tight budget, you know acquiring new customers is slow, expensive, and often delivers

• Elevate your CX delivery using CommandCenter 2.0: Simplified builder; seamless orchestration

  Most businesses want to create memorable customer experiences—but they often find it hard to keep them smooth, especially as they grow. To achieve a state of flow across their processes, teams often stitch together a series of automations using Workflow

• Nimble enhancements to WhatsApp for Business integration in Zoho CRM: Enjoy context and clarity in business messaging

  Dear Customers, We hope you're well! WhatsApp for business is a renowned business messaging platform that takes your business closer to your customers; it gives your business the power of personalized outreach. Using the WhatsApp for Business integration

• Zoho CRM: Sales Rep Professional Certification Program on Coursera

  We are happy to share that we have published the Zoho Sales Representative Professional Certificate in partnership with Coursera, a leading platform for online learning and career development that offers access to courses and degrees from leading universities

• 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

• Recent Topics

• How can I restore all the deleted Time entries of a Task in Zoho Projects

  How can I restore all the deleted Time entries of a Task in Zoho Projects? Query: In Zoho Projects, I cloned a task and deleted the time entries from the cloned task. However, this also deleted the time entries from the original task. How can I restore

• Is there a way to make an account inactive in ZoHo Desk

  We have a few Clients "Accounts" that we no longer do business with. It would be beneficial for them to not show up in lists. However, we want to go back and view tickets, time, etc.

• How to set the value of the Phone field importing contacts in Zoho Desk

  Hi everyone, i'm new in Zoho Desk, we're setting up the environment and i'm importing contacts from another CRM using a file CSV and i'm getting a problem with phone numbers (italian): the leading zero is cut away, also if the value is inside double quotes.

• Set Custom Icon for Custom Modules in new Zoho CRM UI

• Deprecation Notice: OpenAI Assistants API will be shut down on August 26, 2026

  I recieved this email from openAI what does it means for us that are using the integration and what should we do? Earlier this year, we shared our plan to deprecate the Assistants API once the Responses API reached feature parity. With the launch of Conversations,

• How to center a field inside a section?

  I’ve been trying to center a field inside a section in Zoho Canvas. When I align it visually, it looks centered in the editor, but after clicking Save, the field appears misaligned on the actual canvas. I also tried setting the field to full width, but

• Kaizen #192 - Implementing Custom Token Persistence in Python SDK

  Welcome back to another week of Kaizen! Last week, we discussed how to implement Login with Zoho using OAuth 2.0 and saw how to bring it to life in a real-world application with the Zoho CRM Python SDK. We also discussed how Zylker Academy built a custom

• Showing the map along with mileage expense

  When you use the GPS to track mileage, it shows you the map of the actual path travelled. It would be very useful and practical to save that map with the mileage expense, so that when the report is created, it provides a map of each mileage expense associated

• Enable Validation Rule for Multi-Select Picklist Field

  Zoho, Please allow validation rules for multi-select fields.

• File Upload field not showing in workflow

  Hi, I have added a field on Zoho CRM. I want to use it in a workflow where that particular field is updated based on another field, however it is not showing up in the field list to select it in the workflow. Why is this please?

• CRM Custom function updating a module record shows the Super Admin user as the record modifier

  Dear Zoho CRM Team, Is there any way to update this so that when a custom function has updated a record the Super Admin user doesn't become the modifier? This happens on the record as a modifier and shows up in the audit logs. It would be more useful

• Best practice importing items and matching assemblies

  Hi, I was wondering what would be the best practice to import items and composite items (assemblies) From my backup, what should I import first? The items or the composite items? I am on Zoho one, using inventory and books. Kind regards, Sabine

• Best way to fetch employee names from Zoho People into Zoho Creator Inventory Stock Form field Employee Name Lookup

  Hi Team, I have a requirement in my Zoho Creator application (Inventory Stock Adjustment) where I need to fetch employee names from Zoho People and use them as a lookup in a form. Currently, I am considering using an integration field to fetch this data

• get file api is returning Junk data

  I am working on extension development where at one point I need to retrieve attachments on records I found out I can use only invokeconnection and not invokeurl in extension development The invoke connection returns the image in raw binary format. When

• Need help with message box

  End user updates many records at once. Each have unique serial number. They want a confirmation box that says starting number, ending number and qty. Is there any way to do this? I been searching and asking support but seems like no great solution.

• [Webinar] The Transformative Power of Gen BI

  Traditional decision-making tools are no longer enough. The integration of generative AI into business intelligence (BI) is proving to be a true game changer—enabling businesses to make faster, smarter, and better informed decisions. Early adopters of

• Backorder process review - Automating Removal of Sales Order from "On Hold" When PO is Received

  Hello Zoho Inventory Team, Currently, sales orders in On Hold status are released only when the bill for the purchase order is created. In our workflow, it would be much more efficient if the sales order could automatically move out of On Hold as soon

• How to access the saved Query using API?

  I have created a query in setting. Is it possible to access it from a API? What's the endpoint? I tried /v8/queries/important_deals but didnt' work.

• création d'une base de données

  base de donnee d'un lycée

• User Session variables to recall after form submit & redirect to menu

  Hey, Forgive me if this is a simple answer I have overlooked. I have built a big onboarding process for my SAAS platform which is built and managed by an external Dev team. I am hoping to embed my new creator app on the SAAS platform. I have a menu page

• Zoho Writer Merge Template with data from Zoho Analytics Views

  Hello, Is there any way to pull information from Zoho Analytics and put it into a Merge Template? I am trying to create a bulk export of one report that filters on a field to create a single document for each of the filter fields.

• Having to enter bill before stock shows as available.

  Hi, Am I right in thinking you must create a bill from the purchase order receipt before the goods are available for shipping?

• Agent Availability Report

  From data to decisions: A deep dive into ticketing system reports Businesses need to track when their support agents check in and check out from work. This report, titled Agent Availability, is one of the static reports that helps managers track the number

• Writing by Hand in "Write" Notes

  Hi there! I just downloaded this app a few moments ago, and I was wondering if there was a way to write things by hand in "Write" mode instead of just typing in the keyboard. It would make things a bit more efficient for me in this moment. Thanks!

• AI-driven construction analytics using Zoho Projects Plus

  Construction projects thrive on timelines; if a project is completed on or before the expected time, it makes headlines, but if it gets delayed, the company’s credibility will be at risk. Such projects require precise planning and constant monitoring,

• Canadian payroll

  Hello ZOHO, is any updates on when payroll for Canada will be available?

• Unified customer view: Bringing product intelligence into your CRM data

  For businesses today, applications and digital interfaces are the main touch points in the customer journey. While Zoho CRM data already tells who your customers are and what they buy, Zoho Apptics tells you how they interact and engage with your product.

• Zoho Creator SaaS app with multiple client AND multiple users

  I am close to finalizing a Zoho Creator app that will be used by different companies to manage sale info, and each company can have multiple users using the app. Things were going perfectly until I tried a search on a report. I use a database field in each table to separate the data for each company, which works great. BUT when I do a search, I get to see ALL the data. This means that Company A could easily see the data from Companies B and C via the built-in search. Is there a way to set up the

• Project Change Orders and Additions

  We are in the process of migrating from QuickBooks Online to Zoho Books. We have Zoho One and like the ability to sync all of our data across everything. And I like that projects work in a way that's less dumb than QuickBooks. I'm trying to figure out

• Track online, in-office, and client location meetings separately with the new meeting venue option

  Hello everyone! We’re excited to announce meeting enhancements in Zoho CRM that bring more clarity and structure to how meetings are categorized. You can now specify the meeting venue to clearly indicate whether a meeting is being held online, at the

• Create custom rollup summary fields in Zoho CRM

  Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were

• Possible to send Zoom AI Companion transcripts and summaries to contacts in CRM?

  Title says it all. Is it possible to send Zoom AI Companion transcripts and summaries to contacts in Zoho CRM?

• Introducing segments for targeted user engagement

  Hello everyone, We’re excited to announce Segments in Zoho Apptics, a new way to group users based on their behavior, preferences, and app activity. With Segments, you can deliver more meaningful, timely, and relevant experiences to your users. When combined

• How do I edit the Calendar Invite notifications for Interviews in Recruit?

  I'm setting up the Zoho Recruit Interview Calendar system but there's some notifications I don't have any control over. I've turned off all Workflows and Automations related to the Calendar Scheduling and it seems that it's the notification that is sent

• Posibility to add Emoticons on the Email Subject of Templates

  Hi I´ve tried to add Emoticons on the Subject line of Email templates, the emoticon image does show up before saving the template or if I add the Emoticon while sending an Individual email and placing it manually on the subject line. Emoticons also show

• Clarity on extended contract status

  Clarity on “extended” status- How does Zoho “extend” a contract?  E.g. if client extends by 1 month, can the “end date” be adjusted accordingly in Zoho and tagged as “Extended” with a clear audit trail that also captures the client’s email? Note- Email

• Customizing contract status

  Can we customize/add/remove status on Zoho contracts ourselves or does Zoho needs to do this? Context- There is a long list of status on Zoho but not all of them are relevant for us . There are few status which are missing and needs to be added. E.g-

• Set Custom Business Calendars and Holidays for Global Teams

  Managing a project across diverse teams means accounting for more than just tasks and deadlines; it means acknowledging how and when each team actually works. Users might follow different working days or observe region-specific holidays that cannot be

• [Integration edition] Deluge learning series - Integrations between Zoho apps and Third-party services with Deluge | 28 August 2025

  We’re excited to welcome you to the Deluge learning series: Integration edition! The Integration edition will run for three months: Session 1 – Integrating Zoho Apps with Deluge using inbuilt integration tasks Session 2 – Integrating Zoho Apps with Deluge

• Critical Vulnerability in all major password manager plugins - is Zoho Vault affected?

  Hi Zoho, a security researcher found a critical clickjacking vulnerability in all major browser password managers: DOM-based Extension Clickjacking: Your Password Manager Data at Risk | Marek Tóth Is Zoho Vault affected as well? Apparently the Vault extension

• Next Page