Force Sync Contact/Account from CRM to Books

Force Sync Contact/Account from CRM to Books

Hi all. This might not be a common issue to the large portion of the user base here, but for those who dabble and use CRM and Books integration, they know how painful it is that we have to wait for the 2-hour intervals for the records to sync; especially from CRM to Books.

Sure, you can 'force' the contact/account to be synced to Books by creating SO/Estimate/Invoice manually, but sometimes, you have automations, buttons, etc to handle the creation of these records and in that case, normally, we don't have any way to do so.

So, I searched and searched, and lo and behold, a way to do it. Now, the method was documented here:

However, it was not mentioned that this can be used to 'force' sync a particular record. So, its application, basically. With this, you can ensure that the contact/account exists first in Books before you create any SO/Estimate/Invoice for the respective record. Might not seem big, but it is from a developer's point of view. So, what you want to do is create a custom function/button, and use this script:
  2. orgId = "78213211";
  3. mp = Map();
  4. createsync = invokeurl
  5. [
  6. url :"https://books.zoho.com/api/v3/crm/contact/" + contactId + "/import?organization_id=" + orgId
  7. type :POST
  8. parameters: mp
  9. connection:"zbooks"
  10. ];
  11. info createsync;
Please note that "contactId" has been mapped to the Contact Id of the record, and "orgId" has also been defined in the first line. "zbooks" is the connection name I use and it's simple to create one. In CRM, Go to Developer Space > Connections > Create New > Find Zoho Books app > choose zohobooks.fullaccess scope to be able to use this connection for nearly everything regarding Zoho Books. Remember, the connection name is up to you, mine happens to be "zbooks".

To use this code to force sync an account record, simply change "/contact" in the url shown to "/account", and put the account Id in place of the "contactId".

You can use this upon the creation of the contact/account, or at any point you desire, really. But that's the critical point in my opinion at least.

Good luck!



      • Sticky Posts

      • Free Webinar - Digital signatures for digital contract management with Zoho CRM

        Hi, Did you know you can seamlessly send and collect signatures on important business documents like business proposals, vendor agreements, sales contracts, invoices, and other inventory documents with Zoho Sign’s extension for Zoho CRM? Join our upcoming

      • New User Interface for your Email integration in Zoho CRM

        Hello folks,  As most of you may already know, Zoho Mail recently got a new user interface that's a lot better and easier to use. As a result, this change will affect your email integration with your Zoho CRM account**.  If you have your email integration in Zoho CRM set up through POP, your Emails UI in CRM will be moved to the new Zoho Mail UI. We hope that you like the new and improved Emails interface inside Zoho CRM. Feel free to share your feedback by commenting below.  **Please note that,

      • Fetching leads from Zoho CRM into Zoho Creator, automatically

        I'd like to pull new leads from the CRM system, into Creator, on a daily basis. Is this possible?   Yes, it is possible. Zoho Creator and Zoho CRM are integrated with each other, enabling you to synchronize data between them. This is done by fetching records from CRM into a Zoho Creator form. In order to achieve this, you'll have to configure a workflow alert in Zoho CRM.  For instance, you can maintain the lead details in CRM on a separate form in Zoho Creator by fetching the details automatically

        • Recent Topics

        • fetch records from analytics table from creator

          I have a creator workflow that I am working in that will compare data from within the app to a table in zoho analytics. Is there a way to fetch a record from Analytics? I have attempted a custom connector with analytics and tried to use it with invoke

        • Remove County field from Customer Address input screen (or allow input to be deleted)

          We are in the USA and have just noticed that there is now a County field in the Customer Address input screen (and maybe other areas of Zoho Books, but this is the one affecting us at the moment). County is not important to our business, and in fact we

        • Card payment surcharge?

          Hi, I would like to offer my customers the ability to pay invoices by card (using the PayPal integration). However, PayPal charges me around 5% to receive a card payment, and I would like to pass on this cost to my customer by way of a card payment surcharge. Is there any way for Zoho Invoice to be set up to automatically add a defined "card processing fee", say 5% of the invoice total, if the customer elects to pay by card? I don't want to add this on to invoice manually, since most of my clients

        • Cant add contact mail. cant find it

          Hi, I am writing a new message and when I enter the contact address that is in my address book, zoho cannot find it. Previously there was no problem. I wrote the first two characters and it shows me all the contact.

        • Customer Parent Account or Sub-Customer Account

          Some of clients as they have 50 to 300 branches, they required separate account statement with outlet name and number; which means we have to open new account for each branch individually. However, the main issue is that, when they make a payment, they

        • Creating a text box background with round corners in Campaigns

          Hello fellow Campaigns users, Is it possible to create a non-square text box? So with rounded off corners. Like the image that I added below. The shadow effect would be cool too, but I guess that would be more difficult (if possible). I suppose this can

        • Image field in custom module

          Hi guy, Is there any hope of adding a custom image field in the custom module? We created a custom module to keep track of assets, and it would be helpful if we could attach an image to the record. Thanks Rudy

        • Team can't view their created ticket through Followed Tickets

          Hello Everyone, in our organization we are new to zoho desk we have multiple teams, and each team handles specific topics and tickets when one of them tries to create a ticket for another team and use followed tickets to view this ticket we get a message

        • Function #61: Automatically add free item to the invoice based on item quantity

          Hello everyone, and welcome back to another Custom Function Friday! During holiday seasons or special promotions, businesses offer deals like BOGO (Buy One, Get One), Buy 3 Get 1 Free, Buy 2 at 50% off, and much more to attract customers. These promotions

        • Use color coding for picklist field values to enhance visual representation

          It's easier and more efficient to manage a large volume of data in a ticket or other custom module records, such as ticket priorities and issue types, when you apply clear visual distinctions through color coding. Color-coded picklist fields allow users

        • Creating a support request / ticket via email to xxx@zohosupport.com

          Is there the ability to create a ticket from an email sent to my support email address (e.g. xxx@zohosupport.com)? For example, I am running a small computer support/service business and I would like to be able to direct potential customers to send an

        • Call transcrition working for ringcentral?

          I don't see anything about what telephony providers can be used. The Zoho support person A said that RingCentral isn't supported. Zoho support person B said that it works, just make sure the call recording link works. Excellent instructions here: Call

        • Setting up CRM for RFP workflow management

          This will be the first time our organization uses an off-the-shelf CRM, transitioning from our homegrown custom solution, and I would appreciate general thoughts on how to get started in general with our workflow using Zoho CRM. The main question: if

        • Introducing Appointment Title Customization

          Hi all, We're delighted to announce an exciting feature, Appointment Title Customization, which you can use to personalize your appointment title according to your business's specific needs and preferences. An appointment title provides a glimpse of the

        • Custom Module

          I've created a custom module in Zoho Recruit for a separate list outside of qualified candidates. On the module, I use First name and Last Name in separate lines. On the top of the module and when I search a person, it only shows the first name at the

        • How to merge duplicate products?

          merge duplicate products

        • Rollup summary for custom module

          Rollup summary feature was introduced almost a year ago: https://help.zoho.com/portal/en/community/topic/introducing-rollup-summary-in-zoho-crm-public-early-access-2023 It does not support custom modules tough and this post aims to track such feature

        • Foreign Currency Bank Account

          I have a bank account in USD zero balance but when i run the bank ledger in my company currency in AED it was shown small balance 1.31 AED , how to make it zero also ,Thanks

        • "Trigger flow for each entry" not working

          I've read this article on how to trigger a flow for each entry in my array. https://help.zoho.com/portal/en/kb/flow/user-guide/create-a-flow/articles/webhook-trigger#Trigger_flow_for_each_entry I cannot get the flow to run for each variant in this JSON

        • migrating from Zoho Invoices (CRM) to Zoho Books

          Good day, I was wondering if there was a easy way to migrate all the quotes and invoices from Zoho Invoices CRM to Zoho Books. We plan to move to using Zoho Books in a few weeks and would like to have all the quotes and invoices from the past 3 years

        • Edit specific job page on carreer site

          Hey, I was wondering how I could change the layout of a specific job page? (when you go to the carreer website and then click on a job listed there). When I go to customization I can edit the carreer website but I seem to be only able to edit the first

        • CRM - Clearing a Subform

          I seem incapable of working out subform functions without assistance.  I've searched, but can't seem to find anything that works. I have a subform that gets filled in when a Zoho Sign document is completed but the fields don't match with the original field values held on CRM (I did have it automatically update, but some fields were being filled in with terrible data, so had to put a stop to it).  There are 4 fields on the subform: Field Name Original Value New Value Update Update is automatically

        • How to include GST% in PO amount?

          Currently when I raise PO, the basic price of the item is used. However, the GST is not calculated and added along with the basic amount. I have added a Custom field for GST in the PO but I need Zoho Inventory to calculate the GST amount and add it with the Basic price to give me the final PO price.

        • Automatically add a retainer to every estimate

          Hi all, I've been trying to find a way to automatically add a retainer at a set % to every estimate we create and send. So far I haven't been successful, does anyone know of a way to do this? Thanks,

        • Planning Sales visit to local lead, contacts

          Hello, We have our leads and contacts in CRM. One sale is asking me how he can view all leads and contacts (ideally on a map) in a given area (city or country or "region") so he can plan visiting them. What can be done or need to be developed to have

        • Force Sync Contact/Account from CRM to Books

          Hi all. This might not be a common issue to the large portion of the user base here, but for those who dabble and use CRM and Books integration, they know how painful it is that we have to wait for the 2-hour intervals for the records to sync; especially

        • Workflow for "Expenses" module?

          Hi there, over the last 2 years, Zoho Expense has seen tremendous growth and we are happy with it. But, sometimes it is frustrating to see things are being implemented halfheartedly, or so it seems. For example, There is the possibility to create workflows

        • When is partial reimbursement going to be launched?

          Hi there. I saw somewhere that the partial reimbursement feature is in the work. What is the update and ETA of that? Our clients and prospects have been asking us and we agree that that is an important feature to have.

        • IP Address List > Sigma

          We have developed a ZohoCRM extension that utilizes API calls to our server from Deluge scripts and Widgets. Our API server has IP restrictions in place. To ensure successful communication, we require a list of IP addresses utilized by Zoho's platform

        • Zoho CRM Canvas Copy Original Layout

          Hello all, I want to use Canvas to make small changes to certain views, not to make huge changes. Is it possible to copy the original Zoho layout and set-up and start from there? I checked and all I can find are some templates which are far from the original

        • Trying to integrate gmail but google keeps blocking Zoho access for integration??

          hi i am trying to integrate a gmail account so can track/access business emails this way. I have followed the instructions but after selecting my email account it gets re-routed to this message (screengrab below) Can anyone advise a way around this or

        • ZOHO Nightmare

          I am writing as a long-time Zoho user who has faced significant challenges implementing your platform for my business. As a New York-based real estate broker, I have invested over $10,000 and nearly two years trying to integrate Zoho CRM with my WordPress

        • Approval system in Books/expenses

          Hi In Books Is there a way to do the following: 1) Submitter to know the balance in Budget/cashflow before sending the amount for approval? 2) Approver to know the same as 1 above? In Expenses, is the above possible?

        • attaching pdf to a bill using REST api

          I'm trying to attach a pdf to a bill using REST and curl. The problem is the example in that section in the API reference document does not show how to actually submit the file. It only shows the headers used. I've been trying many variations of this

        • How to Open .mbox file in Gmail with Attachments?

          Gmail offer users to backup INBOX folder in .mbox file format via Google Takeout Feature. Howver there is no such option to Restore Gmail MBOX. Thus I would like to suggest you to choose an alternate approach i.e. MBOX to Gmail Wizard. This utility will open .mbox file in Gmail with attachments.  Steps to open MBOX file in Gmail are; Run MBOX to Gmail Wizard Click Add File and add .mbox file. Enter your Gmail login credentials. Click Convert button. Finished! This is how you can open MBOX file in

        • How to create comparison time periods like these examples

          In a Pivot Report I would like to be able to select any date range and show a set of metrics for that date range e.g. revenue, orders, units sold. I would then like to be able to compare to the previous period based on the amount of days on the selected

        • Custom fields for calls and an enhanced call creation form

          Greetings, I hope you're all doing well. We're happy to announce a few recent enhancements we've made to Bigin's Calls module. We'll go over each one in detail. Enhanced call creation form in Bigin What is this enhancement about? This update includes

        • Customize user data collection with User Layouts

          Users denote the people in your organization who work on agile projects using Zoho Sprints. You can add them to your workspace and associate them with required projects. Organizations have distinct requirements in collecting user data. Apart from the

        • Zoho Sites with GoDaddy DNS

          We have a site hosted with www. in front that works perfectly well. The issue is with getting the TLD/naked DNS pointed to the www. while using GoDaddy dns. I have edited the DNS Forwarding entry in the domain so that the root example.com forwards to

        • Integration with Moodle

          Greetings, I hope find all doing well and safe. I've recently returned to using Zoho Flow after a break and was hoping to connect my WooCommerce store with Moodle, the world's most widely used learning management system. My goal was to automatically enroll

        • Next Page