CPQ for Zoho CRM — How it works

CPQ explained with a scenario

CPQ is an effective tool to achieve line item automation in Zoho CRM. Consider the case of Zylker Apparel, which uses the CRM to maintain a database of their customers. They are often faced with situations such as annual clearance sale, special offers and so on. They wish to implement a better quote management system, and so they implement CPQ in Zoho CRM. Following is a summary of their requirements.

Every time they add a certain product, a few other products need to be added to the quote automatically. These could be typically free products or accessories.
Depending on various factors such as the time of the year, the size of the deal, region and more, their prices vary. For instance, they have an annual clearance sale, where a few products are offered for free or at an impressive discount. This "conditional pricing" needs to be incorporated in the CRM system.

Watch the following video to learn how CPQ achieves the requirements mentioned above. When a sales rep adds a specific sweatshirt to a quote,

Two other product line items (a couple of matching scarves) get added automatically.
A discount of 20% gets applied on the list price of the sweatshirt.
Two pairs of Jeans are suggested as a prompt for the sales rep, to add to the quote.

How it works

The CPQ system for Zoho CRM consists of the following building blocks.

Product Configurator
Price Rules

Note:

Both Product Configurator and Price Rules can be set up for default as well as custom modules in Zoho CRM.
Note that only modules with at least one sub-form (and at least one look-up field in the sub-form) will be listed. This is because, CPQ rules are all about line item automation and cannot be set up for modules that do not have any line items (sub-forms).
CPQ rules can also be set up for default and custom fields.

Product Configurator

The Product Configurator is the section where you define the actions that need to be automated upon the selection of specific products. These automated actions could be any of the following:

Add Product
Suggest Product
Quoted Item Field Update

1) Add/Suggest Product

Often when customers order a product, it's a common practice to add a related line item, be it free products or related accessories, depending on a specific context.

Consider that Zylker Apparel has a year-end clearance sale in which, if a customer orders a specific sweatshirt, a matching scarf gets added to the line item for free. To make this a consistent practice across the organization so that the sales teams do not miss out on this action, this practice can be fed into the CPQ system under "Product Configurator".

As per this rule, whenever the product "Zylker Men Grey & Black Pure Cotton Colourblocked Hooded Sweatshirt" is added to a price quote and the moment the quote is saved in CRM, this rule will be triggered. As a result, the CPQ engine will automatically "add" the scarf to the quote as per the product configuration.

Line item 1 being added to the quote and saved

Mandatory products added on the quote via CPQ rules

2) Suggest Product

When customers order a specific sweatshirt, they wish to cross sell their best pair of Jeans as well. To make this a consistent practice across the organization so that the sales teams do not miss out on this action, this practice can be fed into the CPQ system under "Product Configurator".

Consider that Zylker Watches deals with mid-range to expensive watches including wall clocks, wrist watches, smart watches and so on. Upon the purchase of an expensive heritage wall clock, they wish to auto-suggest additional items — that is, an annual repair package, suitable batteries as well as additional wrist watches. This may help the sales reps cross sell these relevant, related products. Now if the suggestion has worked and the customer wishes to add-on these suggested products, the sales reps can directly bulk-select the required items and add them directly to the quote in bulk.

3) Quoted Item Field Update

Quoted Item Field Update is an action that comes in handy when you want to auto-update the field value of the quoted item (s). Example, you may want to quickly add a note called "CPQ rules applied" against the quoted item, just for your reference to understand that automation was at play for this quote. This content would be updated in the Description column of the quoted line item.

Adding a "Free product"

It is a very common scenario where companies offer products to customers for free. On a regular day, Product A has a price attached. However, on a special occasion, Product A may be offered for free UPON the purchase of Product B.

For example, consider the case of Zylker Watches. Their couple watches range from ₹2500 — ₹50000. When bought separately, the list price of the selected couple watch applies. However, to encourage purchase, Zylker decides to make a specific type of couple watch worth ₹2500 free upon the purchase of a Zylker Heritage Wall Clock worth ₹10890. When bought separately the couple watch comes with its price tag attached, however, upon the purchase of the wall clock, it can be offered as a free product. This can be configured easily in CPQ by simply marking the product as a "Free product" as part of the product configuration setup for the Heritage Wall Clock.

Step 1: Create a new product configuration rule.

Step 2: Select primary product as the Heritage Wall Clock. Add Mandatory Product as the selected brand of Couple watch.

Step 1 — Search for Heritage Wall clock and select this as the Primary Product

Step 2 — Add Couple watch as a mandatory product under selected actions

Step 3: Select the "Set this Product as free" checkbox and update the quantity as an absolute number or from Quoted Items.

Step 4: Click Done and Save the rule.

Note:

1. When make a product as free, note that if you have a different price rule for the same product, that price rule will always override product configuration. That is, if the same Couple watch in the above example has a different price rule, this free product configuration will be neutralised and that price rule will take effect.

2. The "Set this Product as free" option is available for all Selected Actions in CPQ: i.e, Product addition, Product suggestion as well as Quoted Items Field update.

Dynamic quantity update for added/suggested items.

There may be circumstances where you may want to automatically update the quantity of the added/suggested item based on the number of primary products added. For example, for every purchase of a laptop, a compatible stand needs to be added. So if the number of laptops added are 10, then the number of laptop stands that go along with it should be 10 as well. Here, the added/suggested items equal the quantity of the main product.

Therefore the quantity field of the added/suggested product needs to dynamically be updated based on the quantity of the main item. In such cases, you can configure dynamic quantity update in CPQ's product configurator.

To do this, create a new Product Configuration based on the primary laptop.

Select the specific product: Example, Zylker Slim Black Laptop.
Define action required: Example, Add Mandatory product, Zylker Slim Black Laptop Stand S405.
Click Next.
In the Set Values For <Product> screen, select the Quantity field.

Note that there are multiple functions to format the values. They include Absolute, Ceil and Floor.
The Quantity update could be either an absolute value or a dynamic value.

If you set an Absolute value, no matter what the quantity of the primary product is, the quantity of the added/suggested product will be equal to the Absolute number mentioned here.
If you want the quantity of the added/suggested item to change dynamically based on the primary item's quantity, select From Quoted Items and click the Configure link. This configuration screen is nothing but a representation of a formula for the dynamic update of the quantity field. Select the required parameters based on your need and click Done.

In this case for every one purchase of Zylker Slim Black Laptop, 1 stand gets added. If 10 laptops are added, 10 stands get added (quantity times the absolute number 1). If you want 2 stands to get added for every purchase of one laptop, hypothetically speaking, you will add absolute number 2. So for 10 laptops. 20 stands get added. This formula denotes how many secondary items need to be added based on the quantity of the primary item. The formula functions include multiplication, addition and division.
Click Done and Save the rule.

Use cases for dynamic quantity update

The configuration formula includes the following parameters:

The selection of the base product — Example: Wall clock.
The base product's field based on which the secondary product's quantity gets updated: Example: 3 wall clocks.
The formula function: Example: Multiplication.
Selection of a number for calculation— Absolute number or a number denoted by a custom field:
Example, in case every wall clock needs 2 batteries, you will enter an absolute number 2. So if 4 wall clocks are added, dynamically 8 batteries will get added automatically.
Alternatively, in case for every wall clock, you need to dictate the number of batteries needed for that particular model of wall clock, then you can fetch that number from a custom field and this number will be multiplied with the quantity of the primary product to get the correct number of secondary product. In such a case you can select the multiplier as "Field" and choose the field. Example: "Number of batteries".

Let's understand how the dynamic quantity is calculated based on absolute number or custom field through the following use cases/examples.

When to use an "Absolute value" for quantity calculation.

1. Zylker Watch Manufacturers want to add 2 batteries along with the purchase of every wall clock.
Here you can multiply the quantity of primary product with the absolute number 2 in order to calculate the quantity of the secondary products.

So, in this case, if there are 4 wall clocks added, there will be 8 batteries added dynamically. Quantity * 2 (absolute number).

When to use an a custom "field" for quantity calculation.

2. There could be another scenario where the quantity needs to be multiplied not by an absolute number but yet another dynamic number dictated by a custom field in the same product record. For example, in the same Zylker Watch Manufacturers, assume that for every watch purchased, there is a watch case that accompanies it. In case of couple watches there needs to be 2 cases. In watches that are a "set of 3", obviously there need to be 3 cases and so on. So Zylker could have a custom field called "Set of" and let this field dictate the number of cases applicable for that particular watch set.

This way, if there 5 "set of 3" watches ordered, the formula to calculate the quantity of cases would be Primary product quantity * number dictated in the custom field — (Set of). In this case, 5*3 = 15 cases.

This way, the CPQ system is robust in that whatever your use case, you will be able to set up automatic dynamic calculation of the quantity of secondary products to be added or suggested in the CPQ engine.

Notes:

The dynamic update is applicable for all actions in Product configurator — Addition, Suggestion and Quoted Item Field Update.
The custom field chosen in the Quoted Item calculation formula should be a number, decimal or a percentage field.
If the base product chosen is "Any product", the dynamic quantity update is not applicable as the system wouldn't know which product to make the calculation based on. Dynamic calculation of the secondary product's quantity is only possible for the selection of specific base product(s).
At present, CPQ calculates the dynamic quantity value only for the first matching product in the list of line items, if the same base product is added across multiple line items. That is, if you add the same product "Zylker Couple watch" in more than one line item, the dynamic quantity update is executed only for the first instance of the product and not the subsequent entries.
For instance, consider that you are adding the same base product "Zylker Wall Clock" as three different line items, one for each color, which you plan to denote in the description. One blue, black and grey— so you decide to add the same product thrice, just noting down the color detail as a description. But in this case, the dynamic quantity update will be performed only for the first matching line item and not the other two.

Therefore, make sure to keep the line items unique so that the corresponding dynamic calculations are made as per your configurations.

Price Rules

Price rules in CPQ allow you to implement variable pricing strategies in your organization. For instance, the price of Product A by default is Amount X. However, customers who come in via "employee referrals" are are eligible for a 10% discount on X. You can specify this in a price rule and CPQ will automatically implement this on your quote.

This variable or in other words, conditional pricing can be implemented either in the form of discount or list price, both of which could in turn be direct or volume based.

So, you have 4 options to choose from, when it comes to implementing price rules:

Direct (static )

Direct discount
Direct list price

Volume-based (dynamic)

Volume-based discount
Volume-based list price

Let's demonstrate these options with a simple example.If the price of Product A is $100, the following is an overview of how the pricing is implemented for each option.

DIRECT METHOD

You essentially mention the DIRECT discount value or the list price, whichever is suitable for your process. This is mentioned against a corresponding product and is static.

Direct discount — if you enter 10% discount on $100, the final amount will be $90.
Direct list price — You can also feed the same thing to the system in a different way. You can say that the list price is 90% of $100, which will yield the same result — $90.

VOLUME-BASED METHOD

Volume based method involves a tier-based model. That is, the discount or list price that you enter will vary based on a specified range.

Volume-based discount

If the quantity ordered ranges from 1-10 — give 10% discount
If the quantity ordered ranges from 11-20 — give 20% discount
If the quantity ordered ranges from 21-30 — give 30% discount and so on.

Volume-based list price

If the quantity ordered ranges from 1-10 — the list price is 90% of $100
If the quantity ordered ranges from 11-20 — the list price is 80% of $100
If the quantity ordered ranges from 21-30 — the list price is 70% of $100

For a product worth $100, the final price in both cases will be the following. It's just a preference — whether you want to enter the discount or the list price.

1-10	$90
11-20	$80
21-30	$70

Volume-based discounts and list price could also be calculated as per two models — flat or slab-based, per your selection.

Note:

Price Rule Sequence
When multiple price rules are created, their sequence is crucial for the desired pricing outcome.
Price rules are applied in the order they appear on your Price Rules page. If multiple rules meet the product criteria, only the first rule in the sequence will be considered and applied to the product. The subsequent rules will be skipped for that transaction.

Here is an additional detail on the pricing options. When you enter the discount or the list price, you will be prompted to choose between "Percentage" value or an "Absolute" value. Here's an example of discounts and list prices entered in percentage and absolute values.

Percentage discount Vs Absolute discount

Percentage discount

You enter the percentage of deduction to be made on the original unit price. For instance say you enter a 10% discount on the unit price.

If the unit price is $100, the final price after discount will be (100 — 10% of $100),

which is $90

If the unit price is $500, the final price after discount will be (500 — 10% of $500),

which is $450.

Absolute discount

You enter the absolute amount to be deducted from the original price. For instance you enter a figure $10 here.

If the unit price is $100, the discounted price will be $100 — $10 = $90

If the unit price is $500, the discounted price will be $500 — $10 = $490

So, you have to be careful which option you choose, whether percentage or absolute, as the difference in results could be drastic.

Percentage list price Vs Absolute list price

Percentage list price

You directly enter the percentage of the original unit price that should be displayed for a selected product. For instance say you enter that the conditional list price should be 90% of the unit price.

If the unit price is $100, the conditional list price will be 90% of $100, which is $90.

If the unit price is $500, the conditional list price will be 90% of 500, which is $450.

Absolute list price:

If you enter an absolute list price, this is the final price that will show up on the quote and will be displayed as is, no calculations made. For instance, if you enter an absolute list price as $80, the price that shows up will be $80, no matter what the unit price is.

These are the various options available under the Price Rules. To sum up, you can offer discounts or state the list price to implement your variable pricing strategies. This discount or list price could be direct or volume based and can be entered as a percentage or absolute value based on your preferences.

CPQ for custom modules and custom sub-forms

CPQ rules can be created for any module and any subform within that module, with at least one look-up field. All you need to do is choose the module, and subform and look-up field for which the rules must be executed.

Case 1 (Default module, default sub-form):
If you are maintaining your quotes in the default Quotes module, you can select Quotes and the Quoted Items subform.

CPQ rules for default modules

Case 2: If you are maintaining your quotes in a different module and wish to also create CPQ rules for custom sub-forms such as Product Accessories or Spare Parts or Warranty Details, then you can select the respective custom sub-form and run your rules.

a) Custom module, custom subform:

For example, let's say Zylker Watches maintains their quotes in a custom module called Estimates, and has organized the line items in two sub-forms — Primary Products and Product Accessories. In this case you can create CPQ rules for Estimates and then choose the sub-form required and then proceed to create the rules.

CPQ rules for custom modules and sub-forms

b) Default module, custom sub-form

In another scenario, you want to make a note of the list of items a customer is interested in, as part of the Deal itself. So you have included a custom sub-form in the Deals module called "Items interested in" and you have brought in Products as a lookup module here to record the list of products in question.

Case 3: You want to run CPQ rules for Purchase Orders, Invoice, Sales Orders.

In case you want to run CPQ rules for Purchase Orders, Invoices, or Sales Orders, you can do this as well. This way, all your inventory documents can be created easily, with automated product additions, suggestions or price calculations.

Note:

If you're using default inventory modules and their default subforms ('QuotedItems', 'OrderedItems', 'InvoicedItems', 'PurchaseItems'), you can only create rules with the system-mandatory Products lookup field. In addition to this,

The CPQ user (the sales reps) must have the required profile permission to access the Products module.
The Products module should not be inactive in your Org account.
(That is, it should be activated and have at least one record).

If you are using default inventory modules with a custom subform, you can create rules with any lookup you need, as long as you have the necessary profile permission and the field is used.

CPQ Use Cases Gallery

This slide show showcases the application of CPQ on the Quotes module in different scenarios and domains such as retail, manufacturing, insurance, education and so on. View this deck to learn more.

Access your files securely from anywhere

Zoho CRM Training Programs

Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

Redefine the way you work

with Zoho Workplace

Start your free trial

Zoho DataPrep Personalized Demo

If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

Create, share, and deliver

beautiful slides from anywhere.

Get Started Now

Zoho Sign now offers specialized one-on-one training for both administrators and developers.

BOOK A SESSION

Zoho Workerly Home
Forums
Connect With Us:

Zoho Recruit Home
Forums
Connect With Us:

Start tracking your website metrics today

Use PageSense to understand what your visitors are looking for, how they are behaving, and where they are facing problems on your website.

Ready to improve your website's performance?

Install the PageSense code snippet on your site in a matter of minutes and start collecting in-depth data about the website visitors to grow your business.

Track and measure every business goal

Set up goals in PageSense to measure every single action performed by visitors on your website like button or link clicks, form submissions, and page engagements.

Understand the customer journey on your website

Create funnels in PageSense to quickly see which pages visitors use to enter your website, where they navigate to next, and which pages they decide to leave without converting.

Visualize your visitor's behavior with color codes

Set up heatmaps in PageSense to see where users have clicked more, how far they've scrolled, and on which parts of a page they've spent the most time using color-coded patterns in reports.

Measure customer engagement with your web forms

Use form analytics in PageSense to see how people interact with different fields in your form, whether they complete the form successfully or not, and where exactly they drop out on your form.

Record real visitor interactions on your website

Use session recordings in PageSense to watch a video of all the visitor actions performed on your website including the pages they navigate, the buttons they click, the UX issues they face, and more.

Test and optimize webpages for better conversions

Run A/B or Split URL tests in PageSense to figure out which version of your web page works best for your business and results in the best conversion rate.

Give each customer a unique website experience

Use personalization in PageSense to deliver customized versions of your website for every individual customer based on their demographics, local weather, browsing history, and more.

Grow your business through customer feedback

Run polls on your website using PageSense to understand what your customers think about your products/services and what needs improvement on your site.

Send timely updates that customers love

Use web push notifications in PageSense to schedule and notify your customers about an upcoming flash sale, product releases, promotional coupons, and a lot more that can spark conversions on your website.

Advertise your business to website visitors

Use pop-ups in PageSense to instantly grab the attention of visitors by showing attractive signup offers, coupon code discounts, or email newsletters that can eventually convert them into subscribers.

Access more advanced settings in PageSense

Use PageSense's advanced features like creating mutually exclusive groups, enabling cross-domain tracking, configuring customized project JS, and more to get deeper insights about your website.

Try easy-to-use extensions

Download the PageSense extension app available for your web browser with a few clicks and start collecting all of your required website metrics in real time.

Discover your favorite integrations with PageSense

Get a deeper look at your website's data by seamlessly integrating PageSense with a host of popular third-party apps like Google Analytics, Mixpanel, Intercom, and more.

Quick Links	Workflow Automation	Data Collection
Web Forms	Enterprise	Begin Data Collection
Interactive Forms	Workplace	Data Collection App
CRM Forms	Customer Service	Accessible Forms
Digital Forms	Marketing	Forms for Small Business
HTML Forms	Education	Forms for Enterprise
Contact Forms	E-commerce	Forms for any business
Lead Generation Forms	Healthcare	Forms for Startups
Wordpress Forms	Customer onboarding	Order Forms for Small Business
No Code Forms	Construction	RSVP tool for holidays
Free Forms	Travel
Prefill Forms	Non-Profit
Intake Forms	Legal	Mobile App
Form Designer	HR	Mobile Forms
Card Forms	Food	Offline Forms
Assign Forms	Photography	Mobile Forms Features
Translate Forms	Real Estate	Kiosk in Mobile Forms
Electronic Forms
Notification Emails for Forms	Alternatives	Security & Compliance
Holiday Forms	Google Forms alternative	GDPR
Form to PDF	Jotform alternative	HIPAA Forms
Email Forms		Encrypted Forms
Embeddable Forms		Secure Forms
Drag and Drop form builder		WCAG

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

Zoho Pagesense Resources

You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho Social?

Manage your brands on social media

Access Zoho Social

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Zoho Sheet Resources

New to Zoho Forms?

Latest Feature Updates

Explore our Pricing & Plans

Zoho Forms Resources

Secure your business

communication with Zoho Mail

Get started

Mail on the move with

Zoho Mail mobile application

Go Mobile

Stay on top of your schedule

at all times

Get started

Carry your calendar with you

Anytime, anywhere

Get started

Latest Announcements

New to Zoho Sign?

Zoho Sign Resources

Sign, Paperless!

Sign and send business documents on the go!

Get Started Now

Zoho SalesIQ Resources

New to Zoho TeamInbox?

Zoho TeamInbox Resources

Connect with us

New to Zoho ZeptoMail?

LEARN MORE

Latest Feature Updates

Zoho DataPrep Resources

New to Zoho DataPrep?

Access Zoho DataPrep

Zoho DataPrep Demo

Get a personalized demo or POC

Design. Discuss. Deliver.

Create visually engaging stories with Zoho Show.

Get Started Now

New to Zoho Workerly?

Access Zoho Workerly

New to Zoho Recruit?

Access Zoho Recruit

New to Zoho CRM?

Signup Now

Access Zoho CRM

Latest Feature Updates

New to Zoho Projects?

Access Zoho Projects

New to Zoho Sprints?

Access Zoho Sprints

New to Zoho Assist?

Access Zoho Assist

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Related Articles
CPQ for Zoho CRM — Scope, Purpose and Benefits
CPQ stands for Configure, Price, Quote. In simple words, CPQ is a software application designed to enable sales teams to create bespoke, accurate quotes for their customers, efficiently and quickly. CPQ is especially valuable when you have multiple ...
Zoho CRM for Google Ads
Google Ads is a powerful online advertising program designed to help you reach new customers and increase sales for your business through ads on Google Search and across Google's network of partner websites. By helping you drive more traffic to your ...
FAQs: Zoho CRM Integration with Zoho Projects
How is the integration between Zoho CRM and Zoho Projects helpful? The integration between Zoho CRM and Zoho Projects works as a bridge between sales data and team collaboration data—all in one place. Since you can associate projects directly with ...
Microsoft Sentiment Analysis for Zoho CRM
The Microsoft Sentiment Analysis extension for Zoho CRM analyzes and scores the sentiments of each customer's comments, helping salespeople know whether the client is happy or sad throughout the engagement. This feature evaluates text and returns ...
HubSpot for Zoho CRM
With the HubSpot extension for Zoho CRM, you can view existing contacts from HubSpot in Zoho CRM. You can also add contacts and leads to HubSpot from Zoho CRM. This integration makes it easier to synchronize contacts (and leads) between HubSpot and ...