Stacking: total discount and order of application
Combines a shelf discount, a promo code and points or cashback into one total discount, shows the unit price and margin, the “ceiling” of the total discount at your minimum margin and the difference between orders of application.
At a glance
- What question does it answer?
- What a purchase really costs a customer with a discount, a code and points together and whether we broke the margin.
- What data is needed?
- Price before discounts excl. VAT, cost.
- How to read the result?
- A 20% shelf discount and a 10% code in turn give 28% (price at the till 3,600). With 5% points, of which 30% will not be spent, the net price is 3,474 and the total discount 30.5%; margin 1,474 (42.4%). The ceiling at a 35% minimum margin is 38.5%: headroom 7.9 pp If percentages add up the total is 32.5% and margin 1,378. Example on the default values: Total discount off the original price — 30.5%; Price at the till — RUB 3,600; Expected cost of points — RUB 126; Net price after points — RUB 3,474.
Why and how to reason
Discounts do not add arithmetically, and that causes two mistakes. First: 20% at the shelf and a 10% promo code give not 30% but 1 − 0.8 × 0.9 = 28%, because the second applies to an already reduced price. The second mistake goes the other way: points or cashback seem free, but 5% is accrued on the till price, and although 30% of it will not be spent (breakage), the rest becomes a cost. Example: price RUB 5,000, shelf −20% gives 4,000, promo −10% gives RUB 3,600 (till price). Points 5% = RUB 180, expected cost 180 × 0.7 = RUB 126, net price RUB 3,474, total discount 30.5%. Unit margin 3,474 − 2,000 = RUB 1,474, 42.4% of price. The discount ceiling at a minimum margin of 35% is 38.5%. Headroom 7.9 points.
When to use it
Use it when several mechanics apply to one purchase: shelf price, promo code, points, partner cashback. Assumption: breakage is estimated from program facts, and the order of application is known (in turn or summed). It does not fit when rules forbid combining discounts (then count each separately) nor wholesale discounts, where logic differs. Set the minimum acceptable margin before the calculation, otherwise the ceiling is formal.
How to read the result
The main number is headroom to the ceiling. If negative, a buyer who collects all discounts gets goods below the acceptable margin, and stacking must be limited. Comparing orders shows the price of a rule mistake: summed gives 32.45% against 30.5% in turn, 2 points on every purchase. If both paths exist, fix the order in promotion terms. Decision: forbid a promo code on already reduced goods or raise the minimum price. It is worth fixing the rules in the promotion terms and at the till: what stacks with what and what does not, and check on a test basket that the system applies discounts in the set order.
Common mistakes
Typical trap: adding percentages arithmetically; treating points as free; taking breakage from a competitor; not setting a minimum margin; not limiting combination in the rules. Remember total discount is measured from the original price, not the till price. Do not enter points as a till discount: they are accrued and spent later.
What data is needed?
- Price before discounts excl. VAT, cost.
- Shelf discount, promo code, points accrual and an estimate of unredeemed points (breakage).
- Minimum acceptable margin and the order in which percentages apply.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Price before discounts, excl. VAT | ₽ | 5,000 | Price excl. VAT: the general rate is 22% from 01.01.2026. The rate follows the shipment date; confirm your regime and rate with an accountant. |
| Unit cost excl. VAT | ₽ | 2,000 | Unit cost excl. VAT, delivered to the warehouse. |
| Shelf discount | % | 20 | The discount the customer sees on the shelf or the product page, in percent. |
| Promo code | % | 10 | The promo code discount in percent on top of the first discount; empty means there is no code. The order of application affects the final discount. |
| Points or cashback (accrual) | % | 5 | Percentage of the price paid returned as points. Empty: no points. |
| Points that will not be spent (breakage) | % | 30 | An estimate for your program: the share of issued points that expire or are never redeemed. Empty: zero. |
| How the percentages apply | In turn: each on the already reduced price | How the discounts apply in practice: in turn (each on the already reduced price) or added up on the original price. In turn gives a smaller total discount. | |
| Minimum acceptable margin in the price | % | 35 | A rule of thumb, replace with yours. Margin is taken on the net price after discounts. |
How it is calculated
| Step | Formula |
|---|---|
| In turn | price at the till = price × (1 − d1) × (1 − d2); total discount = 1 − (1 − d1)(1 − d2) |
| Added up | price at the till = price × (1 − d1 − d2) |
| Points | cost = price at the till × accrual × (1 − breakage); net price = price at the till − cost |
| Ceiling | 1 − cost ÷ ((1 − minimum margin) × price) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Total discount off the original price
- 30.5 %1 − (1 − d1)(1 − d2) − expected cost of points. Percentages do not simply add.
- Price at the till
- 3,600 ₽
- Expected cost of points
- 126 ₽Accrued points × the share that will actually be spent (1 − breakage).
- Net price after points
- 3,474 ₽
- Margin per unit
- 1,474 ₽
- Margin in the net price
- 42.4 %
- Ceiling of the total discount
- 38.5 %At this total discount the margin equals your minimum.
- Headroom to the ceiling
- 7.9 p.p.
- For comparison: added up
- 32.4 % · margin 1,378 ₽
In turn: price steps
| Step | Price | Discount off original | Margin per unit |
|---|---|---|---|
| Price before discounts | 5,000 ₽ | 0 % | 3,000 ₽ |
| After the shelf discount | 4,000 ₽ | 20 % | 2,000 ₽ |
| After the promo code | 3,600 ₽ | 28 % | 1,600 ₽ |
| Including points (expected) | 3,474 ₽ | 30.5 % | 1,474 ₽ |
For a customer one clear discount matters: complex combinations work worse and cause more disputes at the till. State the combination rules in full in the promotion text: untrue information about the size of a discount breaks the Russian advertising law (Art. 5 of Law 38-FZ); have a lawyer check the text.
Nuances and limits
- Percentages do not add: 20% and 10% in turn give 28%, not 30%; the order changes the total.
- Points granted to people who would not have changed behavior remain a liability: accounting and taxes with an accountant.
- An untrue discount size in advertising breaks Art. 5 of Law 38-FZ.