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.

• 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. 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

• Zoho Commerce in multiple languages

  When will you be able to offer Zoho Commerce in more languages? We sell in multiple markets and want to be able to offer a local version of our webshop. What does the roadmap look like?

• Compensation | Salary Packages - Hourly Wage Needed

  The US Bureau of Labor Statistics says 55.7% of all workers in the US are paid by the hour. I don't know how that compares to the rest of the world, but I would think that this alone would justify the need for having an hourly-based salary package option.

• How to create auto populate field based on custom module in Zoho CRM?

  Hello, i'm still new to Zoho CRM and work as administrator in my company. Currently, I'm configuring layout for Quotes Module. So, the idea is, I've created a read-only field in Quotes called "Spec". I want this field automatically filled with Specification

• webinar registration confirmation are landing in SPMA folders

  I am trialing zoho webinar and do not have access to custom domains. When I test user registrations, they are working but the resulting confirmation email is landing in a spam folder. How can I avoid this?

• Making digital signatures accessible to all: Introducing accessibility controls in Zoho Sign

  Hi there! At Zoho Sign, we are committed to building an inclusive digital experience for all our users. As part of our ongoing efforts to align with Web Content Accessibility Guidelines (WCAG), we’re updating the application with support that will go

• Is there a way to set Document Owner/Sender via the API

  When sending requests for zoho sign, it would seem zoho uses the id of the person that created the zoho api cred to determine the owner_id, is there a way to set a default for this?

• Transition Criteria Appearing on Blueprint Transitions

  On Monday, Sept. 8th, the Transition criteria started appearing on our Blueprints when users hover over a Transition button. See image. We contacted Zoho support because it's confusing our users (there's really no reason for them to see it), but we haven't

• Delegates should be able to delete expenses

  I understand the data integrity of this request. It would be nice if there was a toggle switch in the Policy setting that would allow a delegate to delete expenses from their managers account. Some managers here never touch their expense reports, and

• Add Save button to Expense form

  A save button would be very helpful on the expense form. Currently there is a Save and Close button. When we want to itemize an expense, this option would be very helpful. For example, if we have a hotel expense that also has room service, which is a

• Multiple organizations under Zoho One

  Hello. I have a long and complicated question. I have a Zoho One account and want to set it up to serve the needs of 6 organizations under the same company. Some of the Zoho One users need to be able to work in more than 1 organization’s CRM and other

• IMAP Server not responding.

  Trying to connect a phone via IMAP and getting "imap.zoho.com not responding." Is the server down, for maintenance or otherwise? I've tried this on two different devices and got the same error on both.

• Error AS101 when adding new email alias

  Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.

• Unbundle feature for composite items

  We receive composite items from our vendors and sell them either individually or create other composite items out of them. So, there is a lot of bundling and unbundling involved with our composite items. Previously, this feature was supported in form

• Regarding the integration of Apollo.io with Zoho crm.

  I have been seeing for the last 3 months that your Apollo.io beta version is available in Zoho Flow, and this application has not gone live yet. We requested this 2 months ago, but you guys said that 'we are working on it,' and when we search on Google

• Open filtered deals from campaign

  Do you think a feature like this would be feasible? Say you are seeing campaign "XYZ" in CRM. The campaign has a related list of deals. If you want to see the related deals in a deal view, you should navigate to the Deals module, open the campaign filter,

• How do you print a refund check to customer?

  Maybe this is a dumb question, but how does anyone print a refund check to a customer? We cant find anywhere to either just print a check and pick a customer, or where to do so from a credit note.

• MTD SA in the UK

  Hello ID 20106048857 The Inland Revenue have confirmed that this tax account is registered as Cash Basis In Settings>Profile I have set ‘Report Basis’ as “Cash" However, I see on Zoho on Settings>Taxes>Income Tax that the ‘Tax Basis’ is marked ‘Accrual'

• workflow not working in subform

  I have the following code in a subform which works perfectly when i use the form alone but when i use the form as a subform within another main form it does not work. I have read something about using row but i just cant seem to figure out what to change

• Fetch data from another table into a form field

  I have spent the day trying to work this out so i thought i would use the forum for the first time. I have two forms in the same application and when a user selects a customer name from a drop down field and would like the customer number field in the

• Zoho Creator as LMS and Membership Solution

  My client is interested in using Zoho One apps to deploy their membership academy offer. Zoho Creator was an option that came up in my research: Here are the components of the program/offer: 1. Membership portal - individual login credentials for each

• Record comment filter

  Hi - I have a calendar app that we use to track tasks. I have the calendar view set up so that the logged in user only sees the record if they are assigned to the task. BUT there are instances when someone is @ mentioned in the record when they are not

• How to View Part Inventory and Warehouse Location When Creating a Work Order in Zoho FSM

  Hi everyone, We’re currently setting up Zoho FSM and would like to improve how our team selects parts when creating a Work Order. Right now, when we add a part or item to a Work Order, we can select it from our Zoho Inventory list but we don’t see any

• FSM too slow today !!

  Anybody else with problem today to loading FSM (WO, AP etc.)?

• 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

• Not able to Sign In in Zoho OneAuth in Windows 10

  I recently reset my Windows 10 system, after the reset when I downloaded the OAuth app and tried to Sign In It threw an error at me. Error: Token Fetch Error. Message: Object Reference not set to an instance of an object I have attached the screenshot

• Mapping a custom preferred date field in the estimate with the native field in the workorder

  Hi Zoho, I created a field in the estimate : "Preferred Date 1", to give the ability to my support agent to add a preferred date while viewing the client's estimate. However, in the conversion mapping (Estimate to Workorder), I'm unable to map my custom

• Runing RPA Agents on Headless Windows 11 Machines

  Has anyone tried this? Anything to be aware of regarding screen resolution?

• The sending IP (136.143.188.15) is listed on spamrl.com as a source of spam.

  Hi, it just two day when i am using zoho mail for my business domain, today i was sending email and found that message "The sending IP (136.143.188.15) is listed on https://spamrl.com as a source of spam" I hope to know how this will affect the delivery

• Delegates - Access to approved reports

  We realized that delegates do not have access to reports after they are approved. Many users ask questions of their delegates about past expense reports and the delegates can't see this information. Please allow delegates see all expense report activity,

• Split functionality - Admins need ability to do this

  Admins should be able to split an expense at any point of the process prior to approval. The split is very helpful for our account coding, but to have to go back to a user and ask them to split an invoice that they simply want paid is a bit of an in

• What is a a valid JavaScript Domain URI when creating a client-based application using the Zoho API console?

  No idea what this is. Can't see what it is explained anywhere.

• Is there a way to request a password?

  We add customers info into the vaults and I wanted to see if we could do some sort of "file request" like how dropbox offers with files. It would be awesome if a customer could go to a link and input a "title, username, password, url" all securely and it then shows up in our team vault or something. Not sure if that is safe, but it's the best I can think of to be semi scalable and obviously better than sending emails. I am open to another idea, just thought this would be a great feature.  Thanks,

• Single Task Report

  I'd like a report or a way to print to PDF the task detail page. I'd like at least the Task Information section but I'd also like to see the Activity Stream, Status Timeline and Comments. I'd like to export the record and save it as a PDF. I'd like the

• Auto-response for closed tickets

  Hi, We sometimes have users that (presumably) search their email inbox for the last correspondence with us and just hit reply - even if it's a 6 month old ticket... - this then re-opens the 6 month old ticket because of the ticket number in the email's subject. Yes, it's easy to 'Split as new Ticket', but I'd like something automated to respond to the user saying "this ticket has already been resolved and closed, please submit a new ticket". What's the best way to achieve this? Thanks, Ed

• How to Push Zoho Desk time logged to Zoho Projects?

  I am on the last leg of my journey of finally automating time tracking, payments, and invoicing for my minutes based contact center company - I just have one final step to solve - I need time logged in zoho desk to add time a project which is associated

• Cannot access KB within Help Center

  Im working with my boss to customize our knowledge base, but for some reason I can see the KB tab, and see the KB categories, but I cannot access the articles within the KB. We have been troubleshooting for weeks, and we have all permissions set up, customers

• Export to excel stored amounts as text instead of numbers or accounting

  Good Afternoon, We have a quarterly billing report that we generate from our Requests. It exports to excel. However if we need to add a formula (something as simple as a sum of the column), it doesn't read the dollar amounts because the export stores

• why my account is private?

  when i post on zohodesk see only agent only

• Getting ZOHO Invoice certified in Portugal?

  Hello, We are ZOHO partners in Portugal and here, all the invoice software has to be certified by the government and ZOHO Invoice still isn´t certified. Any plans? Btw, we can help on this process, since we have a client that knows how to get the software certified. Thank you.

• Show/ hide specific field based on user

  Can someone please help me with a client script to achieve the following? I've already tried a couple of different scripts I've found on here (updating to match my details etc...) but none of them seem to work. No errors flagged in the codes, it just

• Next Page