Bulk Import Counterparty Data
Currently, as the feature to bulk import counterparty data is not available, here is a solution using our APIs that would be useful for our customers. For example, Zoho CRM customers can import their Accounts as counterparties in Zoho Contracts. Using this option, you can import a maximum of three contacts for each counterparty. Please follow the below steps, categorized into three sections.
Prepare the data to import:
1) Download the attached "Import Counterparty Data.xlsx" file. The file contains 3 sample counterparty data for your reference.
2) In the first worksheet Data, enter each counterparty record. We strongly recommend you try the bulk import exercise with fewer rows (say, 2 to 3 counterparty records) first as a test run, and then do a bulk import.
3) In the Counterparty Type column, for each counterparty, enter the API name of the counterparty type as mentioned below, which is of the default counterparty types in Zoho Contracts. If you maintain custom counterparty types, please reach out to us, we will help you to get the API names of them.
Counterparty Type Name | Counterparty Type API Name |
Customer | customer |
Employee | employee |
Partner | partner |
Reseller | reseller |
Supplier | supplier |
| Vendor | vendor |
4) In the Country column, for each counterparty, enter the Country code as mentioned in the below spreadsheet.
5) In the State column, for counterparties whose country is either US or India, enter the State code by referring to the below spreadsheet. For other countries, you can enter the value as it is.
6) Go to your Zoho Sheet account by accessing sheet.zoho.com in your browser, then log in if you are not logged into Zoho.
7) Click Upload at the top-right corner of the page, select Upload Spreadsheet, then upload the "Import Counterparty Data.xlsx" file that has your counterparty data.
The uploaded spreadsheet will be listed in the My Spreadsheets list.
Create a connection with your Zoho Contracts account:
1) Open the uploaded spreadsheet "Import Counterparty Data" by clicking it. The file will be opened in the spreadsheet editor.
2) Select Tools > Custom Functions > Manage Connections, then click Create Connection.
3) Select the service Zoho OAuth under the Default Services list. You can use the search option to find it.
4) Enter "ZContracts" in the Connection Name field. The Connection Link Name will be auto-populated. You can leave it as it is.
5) Select the scope contracts.contracts.ALL from the Scopes list. You can use the search option to find it.
6) Click Create and Connect.
The connection will be created and listed under the My Connections list.
Creating and editing the import function:
1) Select Tools > Custom Functions > Create Custom Function.
2) Enter "IMPORT_COUNTERPARTIES" in the Name field.
3) Choose Result Type as string, then click Save.
4) In the editor window, replace the default code with the code in the attached "Import Counterparties Function.txt" file.
5) Replace the value of sheetDocumentId seen at the top with the spreadsheet ID you are currently working on. The ID of the spreadsheet can be taken from the browser URL, as depicted in the below image.
6) If your account is in the data center other than US (e.g., India, Europe, Australia, or Japan), replace all the occurrences of contracts.zoho.com in the code with the respective domain values as mentioned below.
| Data Center | Domain |
India | contracts.zoho.in |
Europe | contracts.zoho.eu |
Australia | contracts.zoho.com.au |
Japan | contracts.zoho.jp |
7) Click Save at the top, then close the window.
Run the function to import all the data:
1) Go to Tools > Custom Functions > Manage Custom Functions.
2) Click Run next to the IMPORT_COUNTERPARTIES function, then close the window.
3) To check success or failure status of the imported counterparties, select the worksheet Logs at the bottom.
4) Go to contracts.zoho.com and verify the successfully imported counterparties.
Note:
- After you import, you cannot undo the action. Therefore, we recommend you import with 2-3 rows first as a test run and the subsequent also in batches.
- If you are in the Standard plan of Zoho Contracts, ensure the total rows prepared to import are within the plan limit.
- In the import logs, for each counterparty, the Counterparty API Name column contains the unique name of the respective counterparty.
- For each import, the rows will get appended in the Logs worksheet. To clear the logs, you can delete the rows.
Please give it a try. If you need any assistance, please write to us at support@zohocontracts.com. We would be happy to help you.
Cheers,
Jayakrishnan
Zoho Contracts Team
Topic Participants
Jayakrishnan
Helga Szűr
Sathyakeerthi U
Viola Martyniuk
Sticky Posts
Adding signature fields in your contract template
When you send a contract document for the signing process, you have to insert the signature fields into your contract document by dragging and dropping them for each signer. It won't be effort-intensive for contracts that have fewer pages or signers.Mapping Billing Country Field to Your Contract Template Field
In Zoho CRM, while configuring Counterparty Fields Mapping to map counterparty information in your contract type, the field 'Billing Country' doesn't have the support to be mapped due to field type mismatch. Because the Billing Country field in Zoho CRMBulk Import Counterparty Data
Currently, as the feature to bulk import counterparty data is not available, here is a solution using our APIs that would be useful for our customers. For example, Zoho CRM customers can import their Accounts as counterparties in Zoho Contracts. Using
Recent Topics
Zoho Sign embedded iframe
Hello, we are looking for any of these options: a) some iframe that we can paste into our website for every signer, for onpage signing document. b) or get direct link for signers from Zoho sign API which we can redirect manually. Is any of these optionsGoods in transit
When creating a purchase order in Zoho Books, how can I properly reflect the inventory as "Goods in Transit" until it reaches its final destination?how to coming soon, holding site, or "under construction"
Hi! I was wandering if was possible to create a website with the simple sign of "Under construction or coming soon" while i work on the site. if possible, how? CheersAnnouncing Agentic AI - Ask Zia!
We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.Zoho People LMS VS Zoho Connect Manuals VS Zoho Learn
in the past I came accross Zoho WIKI but did not like the platform because it could use a lot of upgrade. Over the time I have noticed Zoho People come out with a LMS module which allows us to created a shared knowledge for our internal team I also came across Zoho Connect which as a knowledge-based for internal team referred to as Manual Now I am seeing Zoho Learn which is a new and fine-tuned version of Zoho Wiki. All of these platforms are very similar but I am wondering what are the differencesMarketing Automation Activities in Zoho CRM
Hello, I've connected Zoho CRM and Marketing Automation, sent a campaign, but no data are displayed in CRM, neither in "campaigns" section inside contact profile. It is possible to display Marketing Automation activities in CRM? Also in CRM Timelines?How do we get a follow up to Experts 22: Scale up your customer support with integrations & extensibility
Hi, How do we get a followup and answers to the questions we have asked during 'Experts 22: Scale up your customer support with integrations & extensibility'. I have repsonded to the answers but have no way of following up. Thanks BrettFrustrating Email Duplication and Timeline Issues Between Zoho Mail and CRM
Hi Zoho team, Can someone please help clarify what’s going on here? Here’s what’s happening: I initiate an email to a lead using Zoho Mail. The lead is created in Zoho CRM via the integration, and the email is correctly associated with that lead. Sometimes,Best Strategy to import contacts and when to create leads
Hi, I'm new to Bigin and looking for a "best" strategy. I had and have the following idea for an use case: 1. Search for websites which I want to contact 2. Create a contact in Bigin with all the required information based on this website (via API ifBetter implementation of Item Category on Invoices and Estimates
1) I have added Item Category as a custom field. Honestly, this should be a native part of the item itself, and either required, optional, or not used. 2) When entering an item on an invoice, you have to enter the first character(s) of the item, otherwiseBulk Update (via the 'Accountant' menu)
Why can't we bulk update Expenses to Owner's Drawings? It always ends in failure with the error "Involved account types are not applicable". If such conversion isn't possible, why make the option available? Better to allow it though.Set Reply_to parameter for "Email an Invoice" API Endpoint
Is there a way to set "Reply To" email address when using the Email an invoice API endpoint? It doesn't seem to be in documentation, but sometimes there are undocumented parameters. If it doesn't exist, please consider adding it as parameter since allZoho Books adaptado a la legislación española. ¿Sustitutos?
Buenas a tod@s No tenemos información sobre la adaptación de Zoho Books a la nueva ley de facturación en España. Me preguntan usuarios de zoho que deberían hacer. Propongo una lista de alternativas, si al final se opta por no desarrollar la funcionalidadA Question about Email Handling (Sending and Receiving)
Hello! I was looking into setting up Email Aliases for my domain that I purchased a while ago through Zoho Mail. I set up a singular alias already and have it linked with Gmail, and it seems to be working out well. However, I set up another alias today,Kaizen #201 - Answering Your Questions | Webhooks, Functions, and Schedules
Hello everyone! Welcome back to another post in the Kaizen series! We are incredibly grateful for all the feedback we received, and as promised, we will answer all the queries in this Kaizen series. Last week, in our 200th post, we addressed one of theZoho Projects Strict Dates for Tasks
Hi Zoho Projects team, I would love to see a feature to allow Strict Dates for Tasks. Sometimes in projects you have dates which must not move, even if predecessor Task dates change. For example, perhaps you need to book access to a facility to performNo Mark as filed buton in GSTR -3b
We are filing our GST in GST portal -and want to mark GST in Zoho books as filed. It is possible to mark GSTR 1 as filed through Mark as filed button. But there is no such button in GSTR-3B. How to mark corrosponding GSTR-3B as filed?ranking by drag the choices instead of rank by number
is the option of draging the choice is available instead of selecting the ranking number for each choice?TASKS - Dashboard to show ALL Tasks from ALL apps.
The Unified Tasks View is useless without the other main zoho apps (Desk, Books & even FSM now) We need to see all our tasks under on pane of glass. The Zoho developers are out of touch with real business workflows. So how it was designed they want usFunction #13: Transaction level profitability
In Zoho Books, the Profit & Loss report provides valuable insights into the overall profitability of your business, indicating whether you have made a profit or incurred a loss. However, there may be occasions when you wish to assess whether a specificZoho CRM with Sap Business One
I need information about integration CRM with Sap BO, thank.Allow bill to nest multiple projects
A bill (purchase) is more often than not used across multiple projects and this functionality is missing and very urgently needed for accurate reporting of purchases across projectsAmazon invoice in Zoho Books
I have just made my first few sales on Amazon India. Amazon Seller account generates invoices for the sales made on Amazon. These invoices are sent to customers also. Now when I was only making offline sales, I used to create Invoices in Zoho Book. NowHow can I change iOS display setting at night?
It seems like at night the two light daytime settings themes (white with blue on top or just white) are not available and I am forced to choose among a few other colours that I really don’t want, I.e., black, blue or orange. Is there a way for me to alwaysCelebrate WWW day with Zoho Desk
Let's recall the times when we learned 'WWW' stands for World Wide Web. Whether you like to call it wuh-wuh-wuh or double-u double-u double-u, or World Wide Web, we all owe a lot to this groundbreaking invention that reshaped how we connect, communicate,The power of camaraderie
In the days before the internet boom, conversations happened face-to-face or over the phone. Phone calls were precious; every minute counted, and every word mattered. We looked forward to those moments of real connection. Even today, nothing quite matchesMessage Content is missing/invalid fault
We cannot create a complete template over zoho. Some features - like button adding - is missing. The templates are created on Zoho and edited on Meta to solve the problem. But still then, some features cannot be used and the message returns this failureKönnen bereits gesendete Kampagnen im Nachhinein einer Mailing-Liste zugeordnet werden, ohne dass die Kampagne erneut versendet wird?
Wir haben unsere älteren Kampagnen in Campaigns über Kontaktkategorien versendet. Dann haben wir umgestellt auf Mailing-Listen, damit alte Kampagnen auch in einem Archiv aufgerufen werden können. Jetzt ist die Frage, ob die Kampagnen, die über die KategorieauswahlNewsletter Templates Are Not Mobile Responsive
Hi, I've already submitted this request to ZOHO once this morning, but for some reason your system logged me out, wouldn't accept my username/password login, and isn't showing any evidence that I've submitted this issue. So here we go again... I am under the impression that your newsletter templates are supposed to be mobile optimised: https://www.zoho.com/campaigns/blog/responsive-email-marketing.html This is clearly not the case, as the last 2 newsletters I've created in Campaigns look perfectDigest Juillet - Un résumé de ce qui s'est passé le mois dernier sur Community
Bonjour à toutes et à tous, Zoom sur les nouveautés de juillet dernier au sein de Zoho Community France. Zoho Commerce vous propose une expérience améliorée grâce à sa nouvelle interface ergonomique et à ses fonctionnalités avancées, conçues pour faciliter100 Rows in a Subform is too limited
We have a custom Module in CRM called Price Sheets, when we get a PO from a client we add the items from the PO to it and then check with our vendors for pricing and add our margin etc And after it is complete we have setup custom scripts to create aUninstall unattended agent
Hello, I'm testing many use case before we purchase assist for our remote support. While we are testing what is the proper way to uninstall agent? I did uninstall from systray, from windows control panel but still ZohoURservice is running. How can I uninstall client side?Zoho Commerce Down?
Is anyone else's storefront down at the moment? Ours has been down for at lease an hour.Zoho Projects iOS app update: Dashboard widget on the home screen
Hello everyone! We are excited to introduce the 'Dashboard' widget in the latest version(v3.10.8) of the Zoho Projects iOS app. Dashboard widgets allow you to view the project progress visually without having to open the app. The widget enables you toIdea: Workflow Rule Trigger Only When Subform Row Is Updated (Thanks to New Inline Row Feature)
Hi Zoho team and community, With the recent update to Zoho CRM, we can now add or delete rows inside subforms without entering edit mode, using the inline Add row button. This is a fantastic improvement for user experience — seamless, fast, and efficient.Auto add new section based on document choices
Hi team, I'm wondering if the below is a possilibity within Zoho sign. We have an application process to become a customer of ours, we currently use Zoho Sign to manage this application and this works quite well. However, if the customer indicates 'YES'Change rate after xxxx kilometers
Is there a way to change the miileage rate after a certain mileage. After 5000 kilometers, we want the rate to automaticly change. Thank !Subform Entry Limit from a Subform Field (A different Subform on the same Form)
Hi, I would like to be able to use a Subform 1 Field as the Dynamic Entry Limit for Subform 2. Even better would be able to use some code with the values, so for example using the Subform 1 Qty Field as the Max Entry limit for Subform 2, BUT only theSlow Zobot response time
Hi, We launched the Zobot on our site to sit along with the regular Live Chat but had to take the Zobot down as the response time was very slow. The bot was slow to begin then once the chat had been initiated the response was very slow. The bot typinghow to show data of 3 table in pivot
Based on engineer name i want to get the data from 3 different tables like Service , amc, installation , but Every table contain Engineer name As Common , based that from the service table i want to take service amount , and count of service based onNext Page