uSonar for Zoho CRM

uSonar for Zoho CRM

Alert
This integration is supported for users in the US and JP DCs.

 

Scope
Synchronize and update company details for Zoho CRM Accounts & Leads module.

Install the uSonar extension

You can install the uSonar extension either from Zoho Marketplace or from within your Zoho CRM account as follows:

  1. Go to Setup > Marketplace > All. All the installed extensions will be listed.

  2. Under All Extensions, browse for and click uSonarThe details about the extension will be available.

  3. Click Install.

  4. Agree to the terms of service and click Install, as shown in the picture below.



  5. Choose one of the following options, then click Confirm

    1. Install for admins only- The extension will only be installed in CRM for users with the administrator profile.

    2. Install for all users- The extension will be installed in CRM for all users.

    3. Choose profiles- The extension will be installed in CRM for manually chosen users. Choose this option, click Confirm, then select the desired profiles. The extension will be installed automatically for the specified users.

            


uSonar configuration

Once installed, uSonar extension has to be configured with three specific CID numbers. These are namely the Information linkage CID, Search API CID, and Update API CID, as shown below.


.

Info
Key Terms


LBC ID:
 A unique ID used to automatically fetch customer data, directly from uSonar's records.


Company ID (CID):
 A unique ID used by uSonar, to recognize who is accessing their data.



Overview
The uSonar for Zoho CRM integration enhances your CRM experience by enabling seamless synchronization of company data. Leveraging uSonar’s extensive database, users can retrieve over 80 unique company details directly into the Leads and Accounts modules. With just a single click, multiple fields are accurately updated, significantly reducing the need for manual data entry and ensuring data consistency across your CRM. Additionally, the automated scheduler keeps your records up to date with the latest available data, ensuring your sales and marketing teams always have the most current insights.

Configuration  

To begin using the uSonar extension, users must complete the configuration by setting up all three required sections and then clicking the Save button. This setup can be accessed from the Settings page within the extension.

The Settings page includes the following sections:

  1. Module Fields Configuration

  2. Synchronization

  3. Additional Configuration

 

      

                                                                          

1. Module Fields Configuration   

This section allows users to configure fields for the Leads and Accounts modules.

 Steps to Configure:   

  1. Click the Configure now to access the configuration page.

  2. Click the Activate button to enable the configuration.

  3. Configure the following:

    • Criteria Mapping

    • Field Mapping

 Criteria Mapping   

In this section, users can define which specific field should be used as the primary search key to retrieve company details from uSonar. This setting determines how the system queries uSonar to match and fetch relevant company data during the integration process.

  1. Company Name and Address are mandatory fields.
  2. Phone Number and Website fields are optional and can be configured as needed.

 Field Mapping   

The left section of the interface displays the available uSonar fields, while the right section allows users to map these fields to the corresponding fields in the selected Zoho CRM module. Users must ensure that each field is correctly mapped to facilitate accurate data transfer between uSonar and Zoho CRM. In the CRM section, only fields with specific data types and sizes are available for each uSonar field, as outlined in the section below. Once the necessary configurations are complete, click Done to configure the settings.

Note: 

  1. The same configuration steps apply to both Leads and Accounts modules.
  2. In field mapping, data from uSonar will overwrite the corresponding fields in Zoho CRM. If a uSonar field is blank but the mapped CRM field contains a value, that value will be overwritten with a blank during integration process.

           

Field Mapping Specifications:

When mapping uSonar fields to Zoho CRM, ensure that the data type and size constraints of the Zoho CRM fields are met. Below is a list of available uSonar fields along with their respective data types and size limits:

uSonar Field
CRM Field - Data Type
CRM Field - Min. Size
Listed Status flag
Single Line, Multi Line, Pick List
2
Grade
Single Line, Multi Line, Pick List
2
Prefecture Code
Single Line, Multi Line, Pick List
2
Employee Count Details Range Code
Single Line, Multi Line, Pick List
2
Revenue Details Range Code
Single Line, Multi Line, Pick List
2
Net Profit Detail Range Code
Single Line, Multi Line, Pick List
2
Industry Major Classification Code 1
Single Line, Multi Line, Pick List
2
Industry Middle Classification Code 1
Single Line, Multi Line, Pick List
2
Industry Major Classification Code 2
Single Line, Multi Line, Pick List
2
Industry Middle Classification Code 2
Single Line, Multi Line, Pick List
2
Industry Major Classification Code 3
Single Line, Multi Line, Pick List
2
Industry Middle Classification Code 3
Single Line, Multi Line, Pick List
2
Securities Code
Single Line, Multi Line, Pick List
5
City Code
Single Line, Multi Line, Pick List
5
Industry Code 1
Single Line, Multi Line, Pick List
5
Industry Code 2
Single Line, Multi Line, Pick List
5
Industry Code 3
Single Line, Multi Line, Pick List
5
Industry Minor Classification Code 1
Single Line, Multi Line, Pick List
5
Industry Minor Classification Code 2
Single Line, Multi Line, Pick List
5
Industry Minor Classification Code 3
Single Line, Multi Line, Pick List
5
Date of bankruptcy
Single Line, Multi Line, Pick List
8
Post Code
Single Line, Multi Line, Pick List
8
Established Year (month)
Single Line, Multi Line, Pick List
8
Current Fiscal Year
Single Line, Multi Line, Pick List
8
Phone Number Call Checked Date
Single Line, Multi Line, Pick List
8
Survey Date
Single Line, Multi Line, Pick List
8
LBC Head Office ID
Single Line, Multi Line, Pick List
15
LBC Parent Company ID
Single Line, Multi Line, Pick List
15
LBC Top Affiliated Office ID
Single Line, Multi Line, Pick List
15
LBC Merger Company ID
Single Line, Multi Line, Pick List
15
Corporate Number
Single Line, Multi Line, Pick List
15
Integration key
Single Line, Multi Line, Pick List
15
Capital (thousand yen)
Single Line, Multi Line, Pick List
20
Current Period Sales Revenue (thousand yen)
Single Line, Multi Line, Pick List
20
Previous Period Sales Revenue (thousand yen)
Single Line, Multi Line, Pick List
20
Sales Revenue from Two Periods Ago (thousand yen)
Single Line, Multi Line, Pick List
20
Employee Count Details Range Name
Single Line, Multi Line, Pick List
50
Revenue Details Range Name
Single Line, Multi Line, Pick List
50
Net Profit Detail Range Name
Single Line, Multi Line, Pick List
50
Listed Status name
Single Line, Multi Line, Pick List
96
Company Status Name
Single Line, Multi Line, Pick List
96
Office Status Name
Single Line, Multi Line, Pick List
96
Industry Name 1
Single Line, Multi Line, Pick List
96
Industry Name 2
Single Line, Multi Line, Pick List
96
Industry Name 3
Single Line, Multi Line, Pick List
96
Company Classification Name
Single Line, Multi Line, Pick List
96
Industry Major Classification Name 1
Single Line, Multi Line, Pick List
96
Industry Middle Classification Name 1
Single Line, Multi Line, Pick List
96
Industry Minor Classification Name 1
Single Line, Multi Line, Pick List
96
Industry Major Classification Name 2
Single Line, Multi Line, Pick List
96
Industry Middle Classification Name 2
Single Line, Multi Line, Pick List
96
Industry Minor Classification Name 2
Single Line, Multi Line, Pick List
96
Industry Major Classification Name 3
Single Line, Multi Line, Pick List
96
Industry Middle Classification Name 3
Single Line, Multi Line, Pick List
96
Industry Minor Classification Name 3
Single Line, Multi Line, Pick List
96
LBC Parent Company Name
Single Line, Multi Line
255
LBC Top Affiliated Office ID Name
Single Line, Multi Line
255
Merger Company Name
Single Line, Multi Line
255
Company Name
Single Line, Multi Line
255
Company Name Kana
Single Line, Multi Line
255
Office Name
Single Line, Multi Line
255
Prefecture Name
Single Line, Multi Line
255
City/ward/town/village name
Single Line, Multi Line
255
Town/district name
Single Line, Multi Line
255
Block number
Single Line, Multi Line
255
Street number
Single Line, Multi Line
255
Building Name/Room number
Single Line, Multi Line
255
Representative Position
Single Line, Multi Line
255
Representative Name
Single Line, Multi Line
255
URL
Single Line, Multi Line, Website
255
Web Tag
Multi Line
32000
Story
Multi Line
32000
Best Industry
Multi Line
32000
Intent Signal
Multi Line
32000
Telephone Number
Single Line, Multi Line, Phone
15
Fax number
Single Line, Multi Line, Phone
15
Number of establishments
Integer, Bigint, Single Line, Multi Line, Pick List
6
Company Status Flag
Integer, Bigint, Single Line, Multi Line, Pick List
2
Office Status Flag
Integer, Bigint, Single Line, Multi Line, Pick List
2
Phone Number Call Checked Flag
Integer, Bigint, Single Line, Multi Line, Pick List
2
FAX Number Call Checked Flag
Integer, Bigint, Single Line, Multi Line, Pick List
2
Foreign Affiliated flag
Integer, Bigint, Single Line, Multi Line, Pick List
2
 LBC Match Result
 Single Line, Multi Line, Pick List
 2
 LBC Match Div
 Single Line, Multi Line, Pick List
 2
 LBC Temporary Flag
 Single Line, Multi Line, Pick List
 2
 Attention Code
 Single Line, Multi Line, Pick List
 2
 Attention Name
 Single Line, Multi Line
 255
 Company Score
 Single Line, Multi Line
 255
 Company Score Range
 Single Line, Multi Line, Pick List
 2
 Company Score Range Name
 Single Line, Multi Line, Pick List
 50


2. Synchronization
   

If the scheduler is enabled, the system will automatically update information in Zoho CRM whenever changes are made in uSonar. For example, if Company A has already been synced to Zoho CRM and certain fields are later updated in uSonar, the scheduler will detect these changes and sync the updated data to Zoho CRM automatically.

  • Only active and configured modules (Leads and/or Accounts) will be included in this scheduler.

  • Users can view the Status and Last Sync Time for reference.

  • Administrators also have the option to manually sync the latest company data by clicking Sync Now, which updates previously synced records with the most recent information from uSonar.

 3. Additional Configuration   

  • Admin users can set their preference for retrieving company details based on either the Official Name or Abbreviation of the company.


 uSonar Widget 

 1. Accessing the Widget   

  • After configuring the settings, users can access the uSonar widget within the Leads and Accounts modules.

  • The widget is available on the View Record page.

  • A uSonar button is displayed in the top-right corner of the record view.

  • Clicking this button allows users to fetch company details from the uSonar database.

 2. Fetching Company Data 

  • A pop-up displays search results, categorized as: Head Office, Branch Office, and Unknown Head Office.

  • Each entry includes: Business Name, Company Name, Industry, Address, and Zip code.

  • Select the appropriate company from the list and click Update to sync its details with the current Zoho CRM record.

  • If the desired company is not listed, users can use the search bar to find and link the correct company.

 

            


3. Syncing and Managing Data   

Once a record has been synced, users can:

  1. Fetch the latest data using the Sync Now button.
  2. Remove synced data from the record if needed.

      


Field Mapping Enhancement in Version 10    (Optional)

In Version 10, we have introduced major improvements to field mapping functionality. Previously, fields were automatically created and mapped by the extension. With this update, users now have the flexibility to manually map fields based on their specific needs.

For customers upgrading from Version 9, previously configured fields will remain accessible and are automatically mapped in the settings. To retain these fields, users must activate them and click the Done button. Alternatively, field mappings can be updated to align with current requirements.

If you need to migrate data from existing fields to newly configured ones, please follow the steps outlined below.

  1. Export Existing Data

    • Export your data along with the Record ID & LBC ID to ensure a smooth transition.

    • Refer to this guide for detailed export steps.

  1. Modify the Exported File

    • Add a new column named "uSonar Data Synced" and set all values to "true" to indicate synced records.

  2. Old Configured Fields Deletion (Optional)

    • If you no longer need the previously configured fields (created via the extension), please uninstall and reinstall the extension. This will remove all the old fields created by the extension.

  3. Import Data to a Module

    • Use the Record ID for updating existing records.

    • Map old fields to the new fields as required.

    • Follow this guide for detailed import instructions.


Uninstalling the extension
To uninstall the extension: 

  1. Go to Setup > Marketplace > All. All the installed extensions will be listed.
    Under All Extensions, you can view all the extensions supported in your CRM.

  2. Browse for uSonar and click the corresponding Uninstall link.

  3. Click Ok to confirm and uninstall the extension.


      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        Access your files securely from anywhere

          Zoho CRM Training Programs

          Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

          Zoho CRM Training
            Redefine the way you work
            with Zoho Workplace

              Zoho DataPrep Personalized Demo

              If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

              Zoho CRM Training

                Create, share, and deliver

                beautiful slides from anywhere.

                Get Started Now


                  Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                  BOOK A SESSION







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsEnterpriseOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceAccessible Forms
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Intake FormsLegalMobile App
                              Form DesignerHRMobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic Forms
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsEncrypted Forms

                              Secure Forms

                              WCAG

                                      Create. Review. Publish.

                                      Write, edit, collaborate on, and publish documents to different content management platforms.

                                      Get Started Now






                                                        You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                            Manage your brands on social media

                                                              Use cases

                                                              Make the most of Zoho Desk with the use cases.

                                                               
                                                                

                                                              eBooks

                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                               
                                                                

                                                              Videos

                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                               
                                                                

                                                              Webinar

                                                              Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                               
                                                                
                                                              • Desk Community Learning Series


                                                              • Meetups


                                                              • Ask the Experts


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner

                                                                Zoho Sheet Resources

                                                                 

                                                                    Zoho Forms Resources


                                                                      Secure your business
                                                                      communication with Zoho Mail


                                                                      Mail on the move with
                                                                      Zoho Mail mobile application

                                                                        Stay on top of your schedule
                                                                        at all times


                                                                        Carry your calendar with you
                                                                        Anytime, anywhere




                                                                              Zoho Sign Resources

                                                                                Sign, Paperless!

                                                                                Sign and send business documents on the go!

                                                                                Get Started Now




                                                                                        Zoho TeamInbox Resources





                                                                                                  Zoho DataPrep Demo

                                                                                                  Get a personalized demo or POC

                                                                                                  REGISTER NOW


                                                                                                    Design. Discuss. Deliver.

                                                                                                    Create visually engaging stories with Zoho Show.

                                                                                                    Get Started Now









                                                                                                                        • Related Articles

                                                                                                                        • HubSpot for Zoho CRM

                                                                                                                          With the HubSpot extension for Zoho CRM, you can view existing contacts from HubSpot in Zoho CRM. You can also add contacts and leads to HubSpot from Zoho CRM. This integration makes it easier to synchronize contacts (and leads) between HubSpot and ...
                                                                                                                        • Zoho Contracts for Zoho CRM

                                                                                                                          The Zoho Contracts extension for Zoho CRM lets you work on contracts and contract templates from within Zoho CRM. It helps contract administrators, legal users, and other customers streamline the process of creating and maintaining contracts. Users ...
                                                                                                                        • Zoho CRM for Google Ads

                                                                                                                          Google Ads is a powerful online advertising program designed to help you reach new customers and increase sales for your business through ads on Google Search and across Google's network of partner websites. By helping you drive more traffic to your ...
                                                                                                                        • FAQs: Zoho CRM Integration with Zoho Projects

                                                                                                                          How is the integration between Zoho CRM and Zoho Projects helpful? The integration between Zoho CRM and Zoho Projects works as a bridge between sales data and team collaboration data—all in one place. Since you can associate projects directly with ...
                                                                                                                        • Zoho Directory integration with CRM

                                                                                                                          Integrating CRM with Zoho Directory gives the CRM administrators a stronger hold on the organization's CRM account by enforcing password security, IP restrictions, and other policies. Read more about Zoho Directory here. Benefits of integrating CRM ...
                                                                                                                          Wherever you are is as good as
                                                                                                                          your workplace

                                                                                                                            Resources

                                                                                                                            Videos

                                                                                                                            Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                            eBooks

                                                                                                                            Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                            Webinars

                                                                                                                            Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                            CRM Tips

                                                                                                                            Make the most of Zoho CRM with these useful tips.



                                                                                                                              Zoho Show Resources