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.



      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • 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

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ






                                ご検討中の方

                                  • Recent Topics

                                  • 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?
                                  • 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
                                  • Introducing Zoho Creator's 2025 Release Projection 2

                                    Hello Creators! I'm Prakash, from the Creator product management team, and today I'm delighted to unveil our next set of features as part of Release Projection 2 for 2025. With thoughtful analysis and planning, we've curated powerful new capabilities
                                  • 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. 
                                  • 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
                                  • 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.
                                  • 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
                                  • 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.
                                  • 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
                                  • Automation #7 - Auto-update Email Content to a Ticket

                                    This is a monthly series where we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk. Email is one of the most commonly
                                  • filter broke my data

                                    I uploaded a file recently from Sheets and it has top 2 rows frozen, with table headers in second row and each one is filterable. somehow my first 2 columns became unfiltered and no matter what I do I cannot reapply the filter?? also didn't realize they
                                  • Introducing the Workflow and Actions APIs for Zoho CRM

                                    We are absolutely thrilled to announce the release of Workflow APIs and Actions APIs in Zoho CRM’s v8 API suite! This powerful new set of endpoints gives developers unprecedented programmatic control over business automation. For years, Workflow Rules
                                  • Zoho CRM Analytics - Allow To Reorder Dashboards

                                    I would like to suggest that you add the ability to reorder dashboards in the Analytics Module. I can see that this has been requested some time ago, the latest 9 years ago. I am not sure if this is a big or small endeavor, but such a small fix can go
                                  • Zoho Form URL displays incorrect name

                                    Hi, I have a form I created called "Design Request form". It displays this way everywhere I look. However, in the URL, it shows up as "DesignJobRequestFormFINAL011325PROOFV1B" and I'm not sure why. I can't find where to fix this. Does anyone have any
                                  • Consumers are talking about your business. Are you listening?👂

                                    A loyal customer might be praising your product in a forum. A frustrated user could be posting a harsh review on a public site. An excited partner may have left a comment on your campaign. A domain expert might be deconstructing your product. A prospect
                                  • What counts as a Temp for Billing Purposes in Workerly

                                    I'm considering trying this product but am not sure how the temp count is used for billing purposes. For example, if we keep a large data base of 500 potential workers.....are we billed for that or only if they are assigned to a client at a given point
                                  • Form name incorrectly displayed in URL

                                    Hi, I have a form I created called "Design Request form". It displays this way everywhere I look. However, in the URL, it shows up as "DesignJobRequestFormFINAL011325PROOFV1B" and I'm not sure why. I can't find where to fix this. Does anyone have any
                                  • I can't receive mail

                                    Hello, I can't receive e-mail. I no longer receive e-mails to the e-mail I received for ​my site. I also edited the DNS settings, but it doesn't work at all.
                                  • 1‑to‑1 invite missing post-setup (needs re-invite) vs channel invite auto-joins without business prompt

                                    1. Zoho Cliq 1‑to‑1 external invite The inviter sent a 1‑to‑1 invite to an invitee who didn’t have a Cliq account. After the invitee completed account setup and created a business/organization, the website redirected them to Cliq, where they opened Cliq
                                  • 【開催報告】東京 ユーザー交流会 Vol.3 2025/10/17 Zoho サービスの活用促進を外部ツールとの連携で実現!

                                    ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 10月17日(金)に新橋で「東京 ユーザー交流会 Vol.3」を開催しました。ご参加くださったユーザーの皆さま、ありがとうございました! この投稿では、当日のセッションの様子や使用した資料を紹介しています。残念ながら当日お越しいただけなかった方も、ぜひチェックしてみてください😊 ユーザー活用事例セッション:Zoho Flowと決済システムの連携 あみろくの岡島さんに、Zoho サービスの活用事例として、Zoho Flow を活用した外部サービスとの連携事例をご共有いただきました。
                                  • received email opens in a new tab every time I log in

                                    as per the title: since about when I first made my email account, every single time Ive logged in to view my inbox, a new tab opens for an email I viewed once as if restoring a closed session. I thought I just didnt understand the "starting up" settings
                                  • Engage with your customers at scale using WhatsApp Marketing Template messages

                                    Hi everyone, To make it easier for organizations to communicate with customers, Desk now allows you to send individual, mass, and bulk WhatsApp template messages from both the Ticket and Contact modules. How is this going to benefit your business? WhatsApp
                                  • Importation Tickets error

                                    Hi, I'm newbie here 🤓 So, i'm importing data from csv, but when I try advance to mapping fields the importer tool show this message: Previously I try import, other data, and not show errors in this step. Some ideas? Best Regards,
                                  • Showing description in timesheet and timelogs.

                                    I am wondering if it’s possible in version 5 of Zoho People to have the description show by default or with a manipulation on the user’s part. Let me show you what I mean. As you can see this is the view for the users. Now if they want to see the full
                                  • Direct “Add to Google Calendar” Option in Zoho Meeting

                                    Hello Zoho Meeting Team, Hope you are doing well. We would like to request an enhancement related to the “Add to Calendar” functionality in Zoho Meeting. Currently, when we open Zoho Meeting and view our meetings under My Calendar, there is an Add to
                                  • Add Flexible Recurrence Options for Meeting Scheduling in Zoho Cliq (e.g., Every 2 Weeks)

                                    Hello Zoho Cliq Team, We hope you are doing well. Currently, when scheduling a meeting inside Zoho Cliq, the recurrence options are limited to Daily, Weekly, Monthly, and Yearly. There is no ability to set a meeting to occur every X weeks — for example,
                                  • Workaround: openURL in Blueprints - An alternate approach

                                    There is a roundabout way to open a URL in blueprints after a save event. By using the 'onBeforeMandatoryFormSave' in Client Script, you can open an external URL. Now, the problem is, this is designed to be run BEFORE the blueprint is saved, not after,
                                  • Next Page