Skip to Content
Technical Articles
Author's profile photo Varun Rao

To pre configure Product based on Formula Rules in SAP CPQ

In this blog I will demonstrate how to pre configure a Configurable Product based on Rules in SAP CPQ.

Sometimes there may be requirement to limit or pre-select the Options available for a user based on their Configuration or requirement. With the help of these rules we can pre select or limit the number of Attributes values available to users.

For our demonstration of Rules, I will use the same Product that I had configured earlier blog.

Below are the Attributes available to users–:



For our example if we select Attribute value of Processor as ‘Snapdragon’ and Operating System as ‘Mac’ then system should auto select Attribute value of RAM as ‘8 GB’. In order to configure above condition we need to first define the Formula for Condition and then formula for Action.

Condition Formula allows the system to Identify the Condition while Action formula explains the Action that needs to be executed if the Condition is fully satisfied.

We can define the Rules in Formula Rules section Rules and Messages tab of the Product.



For above requirement Condition formula will be as shown below–:

Action Rule will be as shown below–:


After saving above Rule, if we Select Attribute values for Chipset as Snapdragon and Operating system as Mac it auto selects value of RAM as ‘8 GB’ as shown below–:



I will demonstrate 1 more example, if the user selects Processor as ‘Exynos’ then Operating System and Display type value should get auto selected as ‘Android’ and ‘Amoled’ respectively.

For this Rule formula for Condition and Action is shown below–:

After saving the Rule if we Configure the Product in Catalog by selecting ‘Exynos’ as attribute value for ‘Chipset’ then Operating System and Display Type ‘Attribute value’ will get Auto select as shown below–:


In the same way we can also disallow certain Attributes to be selected based on Rules.

Hope this is of help to you.





Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Dhirendra Tripathi
      Dhirendra Tripathi

      hi Varun

      Could you explain me what is collection of configurable product and how it differs from system list configurable product

      I'm new to cpq ...I have a lot confusion