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.
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:
- Create a Sales commission app in Zoho Creator. (Refer Zoho Creator tutorial on Creating Apps).
- Configure Webhooks in Zoho Subscriptions. (Refer the help documentation to know about webhooks).
- 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;
- Module and Event:
Module - Invoice
Predefined Event - Invoice Created - 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. - Method: POST
- 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.
Access your files securely from anywhere
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Sasidaran K
lh
Joshua
Sasidaran Kumar
Jay Larson
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. CustomersTip #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'sTip #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 canTips 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
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Transfer ownership of files and folders in My Folders
People work together as a team to achieve organizational goals and objectives. In an organization, there may be situations when someone leaves unexpectedly or is no longer available. This can put their team in a difficult position, especially if thereConsumer Financing
Does Zoho currently have a payment gateway (such as Stripe, Square, etc) which offers financing for customers? So, let's say the estimate we give the customer is greater than what they can afford at the time, but we can sell the service now, letting themSubform edits don't appear in parent record timeline?
Is it possible to have subform edits (like add row/delete row) appear in the Timeline for parent records? A user can edit a record, only edit the subform, and it doesn't appear in the timeline. Is there a workaround or way that we can show when a userZoho CRM - Option to create Follow-Up Task
When completing a Zoho CRM Task, it would be very helpful if there was an option to "Complete and Create Follow-Up Task" in the pop-up which appears. It could clone the task you are closing and then show it on the screen in edit mode, all the user wouldDeluge function to copy parent record file upload field to child record file upload field
I'm stuck trying to write a deluge function that is triggered via automation in child record "Appointments," confirms if a file is in file upload "Report" field of parent "Contacts" record via Contacts lookup field "Contact_Name". If no file is in parentMake panel configuration interface wider
Hi there, The same way you changed the custom function editor's interface wider, it would be nice to be able to edit panels in pages using the full width of the screen rather than the currently max-width: 1368px. Is there a reason for having the configuration panel not taking the full width? Its impossible at this width to edit panels that have a lot of elements. Please change it to 100% so we can better edit the layouts. Thanks! B.Image Compression Options
Much better if we have level of options to compress the image [20%, 40%...] We are dealing with service reports daily that has before and after photos (image field)- the file size too large and one thing, the current limit is 10mb or 15mb for reportCannot get code to work with v2.mergeAndStore!
Please can someone help me pass subform items into a repeating mail merge table row using v2.mergeAndStore? I have a mail merge template created in Writer and stored in Workdrive. This template is referenced by a custom CRM function which merges all ofHow to hide or archive a blog post temporarily in Zoho commerce website builder?
I would like to temporarily hide or archive a blog post in zoho commerce website builder so that it doesnt appear on my website till I enable it again. I tried to look for this option but could not find it. It only allows me to permanently delete a blogFounders using Zoho — are you leveraging Zoho Campaigns + Zoho Social for thought leadership… or just sending emails?
I’ve noticed something interesting in the Zoho ecosystem. Many founders use Zoho Campaigns and Zoho Social for basic marketing—newsletters, scheduled posts, and announcements. But very few are using these tools strategically to: • Position themselvesHow to mix different types of inputs (such as dropdown list and textbox)
Hi, I'm creating a form called "Room Reservations" for a company. I created a "table" using "Matrix Choice". I created "Room 1", "Room 2" and "Room 3" with the "Questions". I would then like to create two columns with the "Answers", one called "Department"Reply to Email for SO/PO
Hello, We are new to Zoho Books and running into an issue. Our support@ email is our integration user. When our team is sending out PO/SO's we are updating the sender email, but for some reason many of our responses are coming back to our support@ emailHow to Convert NSF to PST Format Effortlessly? - SYSessential
It is highly recommended to obtain the error-free solution of the SYSessential NSF to PST converter to convert NSF files from Lotus Notes. Using this professional software, it becomes easier to convert all NSF database items, including emails, journals,Zoho Commerce - Poor Features Set for Blogging
Hi Zoho Commerce team, I'm sure you will have noticed that I have been asking many questions about the Blogs feature in Commerce. I thought that it would be useful if I share my feedback in a constructive way, to highlight the areas which I feel needPass shipping info to payment gateway Zoho Books to Authorize.net
For some reason the integration from Zoho books to Authorize.net does not pass the shipping address. Authorize.net is ready to receive it, but zoho books does not send itMassive Zoho Books failure
We have not received any communication or notification from Zoho, but we have detected that Zoho Books is not working for all our users. We cannot access or use Zoho Books. This is critical. We are trying to contact Zoho on the Spain telephone number,Does the Customer “Company Name” field appear anywhere in the Zoho Books UI outside of PDFs?
Hi everyone, I’m trying to understand how the Company Name field is actually used in Zoho Books. There is a Company Name field on the customer record, but when viewing transactions like a Sales Order in the normal UI (non-PDF view), that field doesn’tEmail outbox is now available in the sandbox
Hello all! Testing emails without visibility has always been a blind spot in the sandbox. With the new Outbox, that gap is closed. You can now view and verify every email triggered from your sandbox, whether it’s through workflows, approvals, or massLooking For Recruit Developer
Hi everyone, I am looking for a Zoho Certified Developer to assist with a development project for MetalXpert. We are building a software system designed to bridge the gap between a candidate mobile app and an employer web portal using Zoho Recruit assales IQ issue on website
i integrated the zoho sales IQ code on the website but it is comming in distroted form i am sharing the screenshot below the website is bulit in wix platformDeprecation of the Zoho OAuth connector
Hello everyone, At Zoho, we continuously evaluate our integrations to ensure they meet the highest standards of security, reliability, and compliance. As part of these ongoing efforts, we've made the decision to deprecate the Zoho OAuth default connectorI need to know the IP address of ZOHO CRM.
The link below is the IP address for Analytics, do you have CRM's? IP address for Analytics I would like to know the IP address of ZOHO CRM to allow communication as the API server I am developing is also run from CRM. Moderation Update: The post belowImportant Update: Google Ads & YouTube Ads API Migration
To maintain platform performance and align with Google's newest requirements, we are updating the Google Ads and YouTube Ads integrations by migrating from API v19 to the newer v22, before the official deprecation of v19 on February 11, 2026. Reference:Zoho recruit's blueprint configuration is not functioning as mapped
Current Status: Zoho Blueprint is not functioning as configured. Issue: We are moving a Candidate status in Zoho Recruit "for active file" but we encountered: "Status cannot be changed for records involved in Blueprint." This happens to various clientSuper Admin Logging in as another User
How can a Super Admin login as another user. For example, I have a sales rep that is having issues with their Accounts and I want to view their Zoho Account with out having to do a GTM and sharing screens. Moderation Update (8th Aug 2025): We are workingBlocklist candidates in Zoho Recruit
We’re introducing Block Candidate, which helps recruiters to permanently restrict a candidate from applying to current/future job openings. Once the candidate is blocked, they will no longer be able to participate in the recruitment process. This willAdmin asked me for Backend Details when I wanted to verify my ZeptoMail Account
Please provide the backend details where you will be adding the SMTP/API information of ZeptoMail Who knows what this means?Zoho Desk - Upsert Ticket
Hi Desk Team, It is common to request more information from end-users. Using forms is a great way to ensure all the required information is collected. It would be great if there were an "upsert" option on the Zoho Form -> Zoho Desk integration which wouldAll 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. Latest updateClient Side Scripts for Meetings Module
Will zoho please add client side scripting support to the meetings module? Our workflow requires most meeting details have a specific format to work with other software we have. So we rely on a custom function to auto fill certain things. We currentlyIntroducing Multiple Sandbox Types and Support for Module's Data Population
Register here for the upcoming Focus Group webinar on Multiple Sandbox | Help documentation to learn more about the new enhancements Hello everyone, Sandbox in CRM is a testing environment for users to create and test new configurations like workflowCreator Offline
We had online access setup and working on our iphones. We have just set it up on an 'Android Tablet' and it is not downloading all the images? We use it to show customers our catalogue. Any ideas. Offline components all setup on both devicesUpdated font library: New font styles and custom font options in Zoho Sheet
Zoho Sheet's font library now supports 500+ font styles in 60+ languages! The updated font library is stacked with new font styles, and some of the previously available font styles have been replaced with equivalent options. There are two ways you canEnable or disable any Field Rule!
Hello Zoho Forms Community, We are excited to announce a powerful new enhancement to Field Rules that gives you greater control and flexibility in managing your form logic! Previously, if you wanted to temporarily deactivate a field rule, you had twoMarketing Tip #20: Increase traffic with strong meta titles and descriptions
Meta titles and descriptions are what people see first on search results before they ever click through to your website. If your pages use generic titles or basic descriptions, you miss the chance to stand out, and search engines may not know which pageKanban view on Zoho CRM mobile app!
What is Kanban? The name doesn't sound English, right? Yes, Kanban is a Japanese word which means 'Card you can see'. As per the meaning, Kanban in CRM is a type of list view in which the records will be displayed in cards and categorized under the givenNot able to delete a QC nor able to revert or create a cycle of manufacturing for QC failed Jobs
Not able to delete a QC nor able to revert or create a cycle of manufacturing for QC failed JobsDheeraj Sudan and Meenu Hinduja-How do I customize Zoho apps to suit my needs?
Hi Everyone, I'm Meenu Hinduja and my husband Dheeraj Sudan, run a business. I’m looking to tweak a few things to fit my needs, and I’d love to hear what customizations others have done. Any tips or examples would be super helpful! Regards Dheeraj Sudanis there any way to change the "chat with us now" to custom message?
is there any way to change the "chat with us now" to custom message? I want to change this textDeprecation Notice: OpenAI Assistants API will be shut down on August 26, 2026
I recieved this email from openAI what does it means for us that are using the integration and what should we do? Earlier this year, we shared our plan to deprecate the Assistants API once the Responses API reached feature parity. With the launch of Conversations,Next Page