Salesforce CPQ is a Next Generation Configure, Price, Quote app that helps your sales reps create accurate quotes quickly and submit error- free orders on the fly—from any device. Salespeople can now spend more time selling and less time on paperwork, while eliminating errors and growing order value.

After implementing CPQ, customers see huge gains in accuracy and speed throughout their sales cycle. CPQ improves the accuracy of quotes, orders, and proposals. Most customers find that they are able to close deals with fewer quote iterations using the tool.  69% of survey respondents also report reduced order errors with Salesforce CPQ and 75% experience fewer errors at the time of proposal.

In CPQ, Price rules is an object. It automates price calculations and update quote line fields. This feature is useful if your business contains products that change in response to the presence of other products on your quote. Some scenarios, we have to create more price rules to update quote line fields based on different products. By Using lookup Queries in price rules, we need not to create more price rules. We can create one price rule and use lookup Queries in that price rule.

Create lookup queries on your price rules to evaluate field values on objects other than quotes. You can then use your rule’s actions and conditions to send those values to a quote, quote line, or product option.

Price rules contain the Lookup Object field, which defines the object containing fields that you want to evaluate. Rules also contain a related list for making lookup queries. Lookup queries reference the fields on the object that you can compare against your quote, quote line, or product option fields.

The lookup queries contains following fields:

 Tested Object:  Define the object that contains the field your lookup query evaluates.

Tested Field:   Define the quote field that your lookup query evaluates.

Match Type:   Choose where this lookup query evaluates its target data.

 Lookup Field:  Define the lookup data field or custom object field that you want to test.

Operator:Define how Salesforce CPQ compares your lookup field to the field you’re testing.

Lookup Queries with Price Rules:

For Example, you want to apply additional discounts on the quote line based on the product family and the quote field (IsExistingCustomer).

Create your quote custom field:

You have to create a custom object to store data in Salesforce CPQ and then reference this data through lookup queries on your price rules.

Additional Discount Object:

Create a custom Additional Discount with fields (Additional Discount,IsExistingCustomer,Product Family).

Create the records in Additional Discount Object with your specifications by using below diagram.

Price Rule Configuration: –

Create a Price Rule

Evaluation Scope: Calculator

Conditions Met:  All

Lookup Object: Additional Discount

Create lookup Queries

  1. Create a lookup query to test whether the quote’s IsExistingCustomer field value matches the Additional Discount’s IsExistingCustomer field value.
  2. Create another record to test whether the quote line’s Product Family field value matches the Additional Discount’s Product Family field value.

Create Price Actions

These actions are executed when all its lookup queries are true.

  1. Create a price action to send source lookup field value to quote lines additional discount field.

Price Rules

Output for the quote lines

Quote Line Editor