top of page
  • Writer's pictureHugh Marshall

How to Auto Update Multi-Currency Exchange Rates in Zoho CRM

Updated: Aug 1, 2023

If you're a Zoho CRM administrator looking to simplify and expedite the process of updating your currency exchange rates, you've come to the right place.


Zoho CRM's Multi-Currency feature is a powerful tool for businesses dealing with multiple currencies. However, one of its known limitations is the need for manual updates of the default exchange rate in the Settings under Company Details.

Screenshot of Zoho CRM Company Details Currencies

Manually updating these rates in your CRM system can be time-consuming and prone to errors. That's why we're here to show you how to automate this process by creating a custom schedule in Zoho CRM.


Our comprehensive tutorial will walk you through the entire setup, empowering you to automatically fetch the latest currency exchange rates effortlessly and allow you to say goodbye to the tedious task of manual updates so you can enjoy the benefits of accurate and up-to-date rates within your CRM.


External API

Zoho doesn't have built-in currency updating tools, so we need to obtain exchange rates from an External API. There are multiple currency APIs that offer this service, but the one I found to be the simplest is the Exchange Rate API. They provide a free Open API to get exchange rates that update daily and don't require an API Key or setting up an account. However, you can create a free account to increase the number of calls to the service. For this project, though, there is no need to do so.


Their API is straightforward to use, as it only requires a simple GET request with our home currency at the end:


https://open.er-api.com/v6/latest/ + homeCurrencyISOCode


The data we receive from this API shows the exchange rates with our home currency in a format that is easy to use and push back into Zoho CRM.

Connection

As we cannot update the currencies using standard Zoho Deluge integration tasks, we need to use the External Zoho API and call it from within our function. Zoho allows us to create connections for pre-determined scopes, which takes the difficulty out of having to manage authorisation and refresh tokens.


Head to Settings > Developer Space > Connections

  1. Click Create Connection

  2. Select Zoho OAuth

  3. Enter a Connection Name e.g. "currency_connection"

  4. Select the required scopes:

    1. ZohoCRM.settings.currencies.UPDATE

    2. ZohoCRM.settings.currencies.READ

  5. Click Create and Connect

  6. Click Connect

  7. Select your Production System

  8. Click Accept

Function

Of course we need a function to do all the heavy lifting, It will need to:

  1. Get the current active system currencies and home currency

  2. Get the exchange rates based on the home currency

  3. Update the active currencies in our system

Head to Settings > Developer Space > Functions

  1. Click New Function

  2. Enter a Function Name (No Spaces)

  3. Enter a Display Name

  4. Set the Category to Schedule

  5. Click Create

  6. Enter code below

  7. Click Save

Schedule

Now that we have our function saved we need to attach it to a schedule.


Head to Settings > Automation > Schedules

  1. Click Create Schedule

  2. Enter a Schedule Name

  3. Select Function to be executed > From existing functions

  4. Click configure next to the function you just created

  5. Click Save

  6. Select a Start Date and Time

  7. Set frequency to Daily

  8. Set Ends to Never

  9. Click Save

  10. Click Run Now under Next Run Column

You have now updated your currencies using the Exchange Rate API


Make sure to subscribe to our channel for more valuable tutorials and tips on optimising your Zoho CRM experience.


Resources:

Looking for further Assistance

If you are looking for further assistance with Zoho applications feel free to contact us to see what we can do for you.

bottom of page