We use Salesforce CPQ and we do not use MDQ. We use quote line groups on a quote to signify the year of the subscription. For example,
- Year 1 quote line group has dates of 1/1/2026 through 12/31/2026 and comes on as list price.
- Year 2 quote line group has dates of 1/1/2027 through 12/31/2027 and we want to apply a 5% uplift using the year one price and apply 5% uplift to each line in the Year 2 quote line group.
- Year 3 quote line group has dates of 1/1/2028 through 12/41/2028 and we want to apply a 5% uplift using the year 2 price and apply that 5% to each line in the Year 3 quote line group.
Does anyone else done this before? If so, and you used the QCP could you share how you built it? We need help building this and adding to our current QCP. Thank you.
Hi Rachel - yes, this is very doable with the QCP, and since Year 1 comes in at list you actually have a clean shortcut. Two approaches, depending on exactly what you're upflifting from:
Common setup for both: order your Quote Line Groups by the group's Start Date so you always know which is Year 1, 2, 3, and match lines across groups by Product (add any configuration attributes to the match key if the same product is configured differently across years).
Option A - uplift off list (simplest, and it fits your description): because every year holds the same product at the same list price, a compounding 5% is just a per-group markup. The simplest lever is a negative Additional Discount (%), which acts as a markup in CPQ - set it by group in onBeforeCalculate: Year 2 = -5, Year 3 = -10.25. The formula per group is -(1.05^(year-1) - 1) x 100. That lands Year 2 at list x 1.05 and Year 3 at list x 1.1025 - true compounding - and you never have to read another line's calculated price. (Just confirm negative discounts are allowed in your CPQ package settings; if they aren't, set the target Unit Price directly instead.)
Option B - compound off the prior year's actual (discounted) price: if Year 1 might carry negotiated discounts and you want 5% on the real Year 1 price, do it in onAfterCalculate instead. Build a map of each product's Customer Price (or Net Price) from the prior group, then set this line's price to priorPrice x 1.05. One gotcha worth knowing: CPQ re-derives List Price from the price book during calculation, so don't try to override List - apply your value at the Customer/Net price stage, which is exactly why onAfterCalculate is the right hook here.
For a straight 'Year 1 at list, +5% each year' setup, Option A is far less code and less fragile, so I'd start there and only move to B if you need to compound off discounted prices.
(A CPQ Price Rule can handle a flat per-group uplift too, but the compounding across three groups is cleaner to express in the QCP - so your instinct is right.)
Happy to sketch the grouping/ordering loop if you go with Option A!