Tip #11 : Calculate sales commission in Zoho Creator using Webhook

Tip #11 : Calculate sales commission in Zoho Creator using Webhook

Hello everyone,

We've been sharing a tip every week to share specific business scenarios which can be implemented for your subscription business. Last week, we shared a tip about the way to customize your checkout page for your billing needs. This week we will be looking at how you can calculate sales commissions in Zoho Creator using Webhooks.

Business Scenario:

Majority of subscription businesses will have a dedicated sales team that works with the customers to find their needs, create solutions and thereby ensuring a smooth sales process. The main purpose of the sales representatives is to find new leads using business directories, client referrals, etc. Sometimes, sales representatives will work on following up with existing clients about payments, bringing back the clients who have left the business, etc. Hence, sales representatives have an important role in business which is to bring in new customers all while retaining the existing ones.

The sales representatives usually work for a commission based salary. To put it simpler, the more income they bring into business, the more commission they get. So, businesses might have to record, calculate and maintain the record of the sales per representative to calculate the commission and the bonus.

Let's consider the following scenario to understand this better. Zylker Comics is a subscription business that sells comic books on a renewal basis. They have a dedicated sales team to help them bring in new customers and to also follow up on the existing one regarding the payment. The sales representative gets 3.5% of the total subscription amount as a commission. The Head of the Sales Department at Zylker Comics wants to record the details of the customer, salesperson and the sales commission in a form as soon as an invoice has been raised for the subscription. Maintaining the sales done per representative help them to analyze and understand the data easily.

Now, let us see how we can maintain a separate record for sales person and commissions by integrating Zoho Subscriptions with Zoho Creator.

Pre-requisites:
  • An account in Zoho Creator.
  • Permissions to access Zoho Creator API.
Procedure:
  1. Create a Sales commission app in Zoho Creator. (Refer Zoho Creator tutorial on Creating Apps).
  2. Configure Webhooks in Zoho Subscriptions. (Refer the help documentation to know about webhooks).
  3. Test your Webhook integration.

Step 1 : Create Sales Commission app in Zoho Creator  

In Zoho Creator, create a Sales Commission application with the following fields
  • Sales Person
  • Contact Name
  • Invoice Date
  • Invoice Amount
Note: Enter "(0.035 * Invoice_Amount)" as the syntax for the formula to calculate the sales commission.


Step 2 : Configure Webhook

Configure the Webhook in Zoho Subscriptions by navigation to Settings > Automation > Webhooks. While setting up a webhook, specify the following details;

  1. Module and Event:
    Module -     Invoice
    Predefined Event -     Invoice Created
  2. URL To notify:
    https://creator.zoho.com/api/<owner_name>/json/<application_name>/form/<form_name>/record/add

    where;
    <owner_name> - You can view the owner name in the URL bar of your browser. For example, <https://creator.zoho.com/<owner_name>/<application_name>/...> to obtain it.

    <application_name> and <form_name> - These are link names for your application form and you can find it here.
  3. Method: POST
  4. Parameters:

    i) authtoken - Specify authtoken from your creator account. Refer this documentation for more details.

    ii) scope - creatorapi

    iii) All the Field Link Name in Zoho Creator App should be mapped to the corresponding placeholders. Please refer the below image for better understanding.


Also ensure that the date format is the same in Zoho Creator and Zoho Subscriptions. Save the Webhook.


Step 3 : Test the Webhook Integration: 

Test your workflow by creating a new Invoice. Make sure that the Sales Person, Contact Name, Invoice Date and Invoice Amount fields are filled with correct information. 

Therefore, whenever an invoice is created, a workflow will be triggered which will calculate the sales commission and have it saved in a form in Zoho Creator.

Found this useful? Try it out for your subscription business and let us know. If you have any queries, please feel free to comment them below. We are here to answer them.


Regards,
Sasidaran K,
The Zoho Subscriptions Team.


    • Sticky Posts

    • Tip #4 : Refer and Earn Workflow system for your Subscription Business

      Hello everyone, We've been coming up with a tip every week to address specific business scenarios which can be implemented for your business. In continuation to the previous post, this week we will be seeing about how you can implement the Refer and Earn Workflow system to acquire more customers. Why are Referrals important? Customer Acquisition is crucial for any business to sustain itself in a constantly evolving market. It involves persuading new consumers to purchase your products. Customers

    • Tip #2 - Cancellation of Offline Subscriptions based on the Expected Payment Date

      Hello everyone, As you all know, we are coming up with a custom function workflow every week to address specific business scenarios. In continuation of this previous blog, this week we will be seeing about Cancellation of Offline Subscriptions based on the Expected Payment Date. Business Scenario: In general, for any business, the customers make payments via online as well as offline. In case of subscription where the automatic collection of charge is enabled (aka online subscription), the customer's

    • Tip #3 : Send SMS Reminders for your Subscription Business

      Hello everyone, As you all know, we are coming up with a tip every week to address specific business scenarios. In continuation to the previous blog, this week we will be seeing how you can use SMS reminders for your Subscription Business. Using SMS messages for your Subscription Business: While managing your subscription business, more often than not, you need to keep your customers informed about upcoming renewals, payment reminders and cancellations. By keeping them informed in advance, you can

    • Tips And Tricks - Announcement

      Hello everyone, Every business is unique and each of them follows a specific workflow. While managing your customers' subscriptions with Zoho, you might have some needs unique to your business. Custom Functions helps you address such needs. This is a start to a series of posts, where we will be coming up with a custom function workflow every week that addresses specific business scenarios. Watch this space for further updates! Also, if you have any specific business scenario which needs to be addressed,

    • Tip #6 : Accessing external URLs from Zoho Subscriptions

      Hello everyone, We have been sharing a tip every week to address specific business scenarios which you can implement for your subscription business. Last week, we shared a tip about implementing the Approval Workflow system. This week, let's look at how you can access external URLs with the help of Custom Link. Business Scenario: Every business functions differently and has its unique requirements. At times, businesses might want to access other websites or applications by appending specific information

      • Recent Topics

      • Tip of the week #35: Migrate to Zoho Calendar from Google Calendar.

        If you are looking to move your Google Calendar events to Zoho Calendar, never worry about missing out the events from your Google Calendar. You can migrate the events from Google Calendar using the export option and import it to Zoho Calendar and manage

      • Tip of the week #36: Migrate to Zoho Calendar from Outlook Calendar.

        If you've been using Outlook calendar and looking to migrate to Zoho Calendar, you can seamlessly export your calendars from Outlook and import them into Zoho Calendar without losing any events, participants, and the reminders set for each event. To migrate

      • Shared calendar issues and duplications

        Apparently there was a calendar update?  Now when I schedule an event for a team member that has shared his calendar with me, the event makes me the organizer and adds the event to my calendar as well.  Previous to this "update" I would scheduled an event

      • Subscribed Calendar

        Hi i have subscribed to a calendar for Holidays in Canada it shows all the holidays perfectly but every one of them has the word Canada before the rest of the name is there a way to remove that word Canada? It takes up a lot of space in the square on

      • The year that was at Zoho Calendar 2023- Part 1

        Hello, amazing community members! Happy new year from all of us here at Zoho Calendar. As we begin the new year, we'd like to thank each and everyone of our community members for your unwavering support and love that you have shown for Zoho Calendar.

      • Zoho Calendar 2024: A Year in Review

        Hello, community members! Happy new year from all of us here at Zoho Calendar. As we turn the page to a new year, we extend our heartfelt gratitude to every member of our Zoho Calendar community for your continued support and enthusiasm. Your feedback

      • Zoho Calendar not syncing correctly with personal Google Calendar

        Coming to this forum as Zoho Calendar support team is not responding, any more. For the past 8 weeks, I have been having an issue with Zoho Calendar not syncing with my personal Google Calendar correctly. I subscribed to Zoho Calendar iCal in my personal

      • Zeptomail API error 500 internal server error

        Hi Everyone, getting this eror continuously! Can anyone please guide around the same! Zeptomail API error 500 internal server error Best Regards

      • Waiting multiple days to buy credits, causing my website to suffer

        So I own a fairly large website that gets a lot of registered users. I use transmail send activation emails, and also forgot password emails. I sent an email to zoho's presales team when I was only at 4K/10K emails sent, hoping to buy more credits before

      • Follow up

        Hello, I sent a message 2 days ago but I don't receive any response and I cannot find my ticket here. this is the ticket: Your ticket has been created with the ticket ID 68925465 and subject "Fwd: Fishing-alert" looking forward to seeing your response.

      • What's new in TransMail!

        Note: TransMail is now ZeptoMail. Click here to know more. Hello again, everyone! We've recently crossed the 6 months mark of TransMail's launch. In this time post our launch, we have been constantly working on updating our platform and adding new features

      • June 2021 in TransMail!

        Note: TransMail is now ZeptoMail. Click here to know more. Hello again, everyone! Hope you and your loved ones are doing well. If you're doing less than fine, we truly hope that things only get better for you.  We've had a few updates in the past month

      • TransMail has a new name—ZeptoMail!

        Tried navigating to TransMail's community forum but see a different name now? That's because TransMail has a new name. TransMail is now ZeptoMail! As we’ve grown from an internal service used mainly by other Zoho products to an up-and-coming competitor

      • July 2021 in ZeptoMail!

        Note: TransMail is now ZeptoMail. Click here to know more. Hello again, everyone! Hope you and your loved ones are doing well.  We've had a few updates in the past month in ZeptoMail—some new features and some important announcements. Take look at what

      • Send Email From the ZeptoMail BY API

        What is Zeptomail:- Transactional email service with reliable and fast delivery How we can Create a Connection for Zeptomail in Zoho CRM Go to the Setup Click on Connection Enter Connection Details:- Generate Consumer Key & Consumer Secret Using Zoho

      • Customer email on Opencart 3

        When I place an order, 2 emails are sent: 1) administrator 2) to the user The administrator receives a beautiful letter, but the user receives a damaged letter (see screenshot). What could be the problem?

      • [Announcement] Insert image from URL changes in Zoho Writer

        Hi Zoho Writer users! We'd like to let you know that we've changed the behavior of the Insert image from URL option in Zoho Writer for security reasons. Earlier behavior Once you inserted an image URL in a Writer document, the image would be fetched from

      • Writer sing up problom

        Zoho writer sing up prolom face

      • Unable to copy into a new document

        Whe I create a new Writer doc and attemp to copy and past I get this message. The only way to copy into a document is I duplicate an existing document, erase the text and save it under a different name and then paste the information. Not ideal. Can you

      • [Webinar] Live demos and user Q&A with Zoho Writer product experts

        Join us on June 12, 2025 for live demos based on your use cases and real-world scenarios raised via form. This is also an opportunity to get your questions answered directly by product experts from the Zoho Writer team. Webinar agenda Live demos based

      • Zoho Writer's built-in citation and bibliography generator

        Hey researchers and writers! Do you manually format citations and bibliographies, spending hours jumping between apps and tabs? If so, then check out Zoho Writer's built-in "Citations and Bibliography" feature. Imagine you're writing a thesis on the future

      • Single and group checkboxes in Zoho Writer's fillable forms

        Hey Writer Fam, Are you making the most out of single and group checkboxes in fillable forms in Zoho Writer? Here is a handy tip to optimize your use of checkboxes, both single and group, and enhance your data collection process. Single checkboxes: Single

      • Collaborate efficiently with Zoho Writer's track changes feature

        Hi Zoho Writer Community, Zoho Writer's track changes feature is a simple, built-in solution that helps you and your team work together efficiently. Instead of juggling multiple versions of a document or building up a long email chain of comments, each

      • Zoho Writer's WordPress extensions

        Hey Zoho Writer users! Say goodbye to all your WordPress content publishing woes with Zoho Writer's WordPress extensions. Publish content with all your formatting and images, republish content when you update a document, and more—from a single window

      • Time-saving table hacks

        Hey Zoho Writer Community, Do you find yourself using a lot of tables in your documents? We're here to share some of our time-saving hacks that will help you work more efficiently, organize your data, and make your documents look neat and professional.

      • Automating document approval and signing with Zoho Writer and Zoho Sign

        Hey Zoho Writer Community! Here's another automation tip to make your processes more efficient! Question: Can I send a document for client approval first, then automatically send it for signing with Zoho Sign if they approve? Since it's the same person

      • Customization hacks in Zoho Writer - Part 2

        Hey community, We're back with some more tricks to personalize your documents, save time, and get in the zone when you work in Writer. Check out part 1 of this post if you haven't already. Let's dive right in! Document ruler units Imagine you're creating

      • Simplify your tax calculations with Zoho Writer

        Hello Zoho Writer Community! Tax season can be stressful, but with Zoho Writer, managing your income tax calculations becomes straightforward and efficient. Here’s an example of how you can use the tables and formulae of Zoho Writer to calculate income

      • Enhance document navigation with headings and TOC

        Hey Zoho Writer Community! We're back with some useful features in Zoho Writer that can simplify your document creation and navigation process. Let's dive right in! Check out our video on how to make the most of Zoho Writer's heading and table of contents

      • Use and download in PDF format of Zoho wirter Merge template using deluge

        Hello Zoho Developers. Here is some information about Zoho Writer. Writer is not just another online word processor, it's a powerful tool for editing, collaboration, and publishing. Even with its wide range of features, Writer's pared-down user interface

      • Customization hacks in Zoho Writer - Part 3

        Hello everyone, Welcome back to Part 3 of our customization tips in Zoho Writer! In this third installment, we'll be diving into some essential customization settings that can enhance your document creation experience. Sender email address in mail merge

      • Daytime saving timezones messing up writer pdf

        Hi, I need help for something I can't figure out. I created a Form to collect data and it is set up with my current Daylight Saving Time (GMT-3). This form is used to generate a contract (pdf Writer) with dates from an event that is being held in 4 months

      • Issue with locked content in Writer

        Hi, I have seen the documentation which outlines how to lock specific content within a Writer document so that it can't be modified by collaborators, but I have come across an issue. When the editor locks a paragraph for example, then a collaborator can't

      • Deprecation of certain URL patterns for published Zoho Writer documents

        Hi Zoho Writer users! We'd like to let you know that we have deprecated certain URL patterns for published and embedded documents in Zoho Writer due to security reasons. If the published or embedded documents are in any of these URL patterns, then their

      • Using Mail Merge Template to Print Documents with One Subform Record's Fields per Document

        Hello, We have a Mail Merge template created in Zoho Writer which is not able to perform the functionality which is currently required to automate the documentation task portion of our process. The CRM module we are primarily using is based on a "Loans"

      • Problem with Writer and Workdrive

        Hi team, I’m the super admin for our Zoho One org. WorkDrive is active, and Zoho Docs is deprecated for our org. However, Zoho Writer cannot connect to WorkDrive at all — we’ve cleared cache, tried incognito, and restarted several times. I was able to

      • Set to Review for all

        We are testing the use of Writer as part of an internal review process for statement of work documents and have found that when the document is changed from Compose to Review by one person, that is not reflected for all others who view the document. Is

      • I’ve noticed that Zoho Sheet currently doesn’t have a feature similar to the QUERY formula in Google Sheets or Power Query in Microsoft Excel.

        These tools are extremely helpful for: Filtering and extracting data using simple SQL-like queries Combining or transforming data from multiple sheets or tables Creating dynamic reports without using complex formulas Having a Query-like function in Zoho

      • stock

        bom/bse : stock details or price =STOCK(C14;"price") not showing issue is #N/A! kindly resolve this problem

      • SOME FEATURES ARE NOT IN THE ZOHO SHEET IN COMPARISION TO ZOHO SHEET

        TO ZOHO sir/maam with due to respect i want to say that i am using ZOHO tool which is spreadsheet i want to say that some features are not there in zoho sheet as comparison to MS EXCEL like advance filter and other Features which should be there in ZOHO

      • Next Page