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.

https://sheet.zohopublic.com/sheet/published/rynsd8169caa8676345ac9312c62c9245758e

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.

https://sheet.zohopublic.com/sheet/published/rynsdf78ca3c24daf44c89989cf8229588d70

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 CRM

• 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

• Recent Topics

• Pause(1);

  I'm using scheduler to invoke an interaction via http post with an external service. The schedule code uses a for-each loop that runs so fast my external application's log files get messed-up (they are named by date-time stamp). What I'm suggesting is

• All new Address Field in Zoho CRM: maintain structured and accurate address inputs

  The address field will be available exclusively for IN DC users. We'll keep you updated on the DC-specific rollout soon. It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition. Managing addresses

• Integration Request: Elementor

  Integrating Zoho CRM forms with Elementor, the most popular page builder on Wordpress, would be great. I use it for our site, goenergylink.com, and I have had to use Zapier webhooks to be able to connect it with Elementor. The one issue I have run into

• Ability to Change Visibility of Published YouTube Videos

  Hi Zoho Social Team, How are you? We would like to request an enhancement in Zoho Social regarding the management of already published youtube videos. Currently, after publishing a youtube video through Zoho Social, there is no option to change its visibility

• Published Course Not Reflecting In Hub

  Hi! I am trying to create micro-learning courses for our team to be available for self-guided learning. I have published the courses with enrollment settings open to all users of the hub, but they don't appear to be available for enrollment. Am I missing

• Adding anchor links in Zoho CRM email templates

  I know you can add anchor link in Campaigns, but I dont see the option to that in the CRM email template. Am I missing something?

• Support “Never End” Option for Recurring Meetings in Zoho Meeting

  Hello Zoho Meeting Team, Hope you are doing well. We would like to request support for creating recurring meetings with no end date in Zoho Meeting. Currently, when scheduling a recurring meeting, Zoho Meeting requires us to select a specific end date.

• openUrl in blueprints

  My customer wants to open a URL at the end of a blueprint transition. Seems this isn't possible right now but it would be very useful. In this thread, https://help.zoho.com/portal/en/community/topic/openurl-not-working the Zoho agent said that it's logically

• Is it possible to pull the Zoho desk data into Zoho analytics in real time

  Hi - I am looking to add more dashboards and reports of Zoho Desk in analytics. I see there is a schedule to pull the data into analytics, but I'm wondering if there is an option to pull the data in real time instead of a specific interval?

• Item Details Field - New Barcode / Document option?

  Is this a new feature??? its in both books and inventory.

• CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

  Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files

• Introducing the revamped What's New page

  Hello everyone! We're happy to announce that Zoho Campaigns' What's New page has undergone a complete revamp. We've bid the old page adieu after a long time and have introduced a new, sleeker-looking page. Without further ado, let's dive into the main

• Ability to Add YouTube Video to Playlist During Publishing

  Hi Zoho Social Team, How are you? While publishing YouTube videos through Zoho Social, we noticed that the platform currently does not allow selecting a playlist at the time of publishing. Instead, we can only add the video to a playlist after it has

• Nouveauté dans Zoho Writer - Création de documents et de modèles assistée par l'IA

  Zia, l’assistant IA de Zoho Writer, soutient les utilisateurs dans l’amélioration de leur écriture et la création de contenus : correction orthographique et grammaticale en temps réel, suggestions adaptées au contexte, détection du plagiat, révisions

• Canvas View in Zoho Recruit

  Is it possible or would it be possible to have the new 'Canvas View' in Zoho Recruit?

• Sharing Form Ownership Among Multiple Users

  I would really like the ability to share form ownership among multiple users. It's frustrating to me that if a co-worker wants to make an edit to a form, I have to transfer ownership to them. It would be great if forms could act like google forms, where multiple people can edit a form and view responses. 

• How to go to the next open ticket in the queue when agents closes ticket

  Zoho Desk When agent closes a ticket - eg when they choose 'Send and Close" - where is the setting that automatically redirects them to the next open ticket in the queue?

• How to Automate Email Sequence

  I'm having trouble trying to set up a workflow to automate an email sequence. Once a group of emails in a Task has been tagged by a certain tag, I want an instant email template to be sent. After 7 days with no response, another email template would be

• Marketer’s Space - Ace Your Spooky-Season Marketing with Pre-designed Templates in Zoho Campaigns

  Hello marketers, Welcome back to another post in Marketer’s Space! We’re in Q4, which means that you have endless opportunities to connect with your audience, starting with Halloween campaigns! In this post, we’ll show you how to design the perfect Halloween

• Turning off the new UI

  Tried the new 'enhanced' UI and actively dislike it. Anyone know how to revert back?

• Zia expands to China with native features and DeepSeek-powered generative AI features

  Hello everyone, We are glad to support Zia native features and Zia generative AI features for our customers in China. From hereon, all AI-features in Desk will be accessible in China data center with the integration of DeepSeek generative AI model. DeepSeek

• Email in each module

  We have a contact ,module which then has a link to customer assets which in turn the asset has a multiple link to service visits. When we link assets to customers we choose by name and it brings over the associate email via the lookup. Great feature.

• 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

• Global Search placement in the new UI

  Having a hard time with the global search placement in the UI redesign. Surely I can't be the only one. Previously global search placement was perfect. A bar at the top/center of the page. Exactly where you would expect it to be. Since the new UI has

• Introducing Skill-Based Ticket Assignment

  The goal of every support team is to provide great support, and to do so as fast as they can. To make this possible, it is important that agents spend their time judiciously, especially when they're dealing with a large number of tickets of varying urgency

• Empowered Custom Views: Cross-Module Criteria Now Supported in Zoho CRM

  Hello everyone, We’re excited to introduce cross-module criteria support in custom views! Custom views provide personalized perspectives on your data and that you can save for future use. You can share these views with all users or specific individuals

• Kaizen #213 - Workflow APIs - Part 1

  Welcome to another week of Kaizen! If you have ever managed complex business processes, you know that Workflows are the quiet backbone of any well-run business process. They keep things moving; assigning owners, sending alerts, keeping deals on track,

• Browser and address bar hide

  Hi, How i can do hide the address bar with browser headline when i am working on the sheet, because i am using (freeze panes) which i want visible for full work. For your reference here i am attached the screen shot and marked yellow lines which really

• Cells Border

  Hi I am using Zoho Sheet on S Tab , is there any option to make all border of any cell at once. I think this is very basic which we are missing. This is available in mobile but not in tab or suggest if i am missing this function. And for Tab can you give

• Credit Management: #2 Configuring Right Payment Terms for Credit Control

  Think about the last time you ordered something online and saw that little note at the checkout, "Pay on Delivery" or "Pay later". It's simple, but it actually sets the tone. As a business owner, you know exactly when payment is expected. Now, imagine

• Zobot and Sales IQ

  What will happen to the Zoho Sales IQ being integrated to the website after creating the Zobot on the website too

• Workflow workdrive rollout

  Hi! When will workflow be rolled out to all users? Thanks.

• Task Due Date greater than 10 years.

  We use recurring tasks in Projects where every week, month, year etc Some of our projects are greater than 10 years and we are unable to set a new due date because the difference between start date and due date is greater than 10 years. As an example

• Zoho Analytics - Make text clickable in underlying data

  Hi Community, I have a simple sales report based on a Invoice query table. I have included a link on to each invoice on the table and sent the Invoice number URL to the link. This works find in the query table, but when I click underlying data on the

• Custom Modules - Where are Comments??

  In the standard ticket module and in the tasks module, we have an interactive comment box that we can post important details/notes and can tag others if needed. Where is this functionality for Custom Modules? Ideally, custom modules would have very similar,

• Mapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually

  Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be able

• ZOHO TEAM INBOX Calendar Integration

  The Problem: Clients send meeting invitations to our TeamInbox address. TeamInbox receives these invites, but we cannot accept them. We do not use individual inboxes for transparency purposes. Ideal Solution: A way to accept calendar invites sent to our

• Help Center and SEO: Any Benefit to My Domain-Mapped Website Ranking?

  First of, I love the Help Center which I've just decided to integrate into my website to replace its old-fashioned FAQs. So much more to achieve there now! Lots of new benefits to the site visitors and to me in terms of organizing and delivering all the

• Blueprint status change

  I want to change the Blueprint status of a workflow. The status is completed automatically when I added the record through API call. But I want to make it active, I don't see any options for this. Even if I draw transition from any stage , it is not visible

• Support french language options

  Greetings, I want to use Zoho with the french language portal, however the supplied translation is not very good (google translate). There are many basic mistakes on the main most important sections (my requests, submit a request). Is there a way for

• Next Page