Price-cut trigger rules by item
Applies a rule to each item: if the stock coverage in weeks is above the threshold and the item has been on the shelf long enough, it goes into the price cut, and the depth depends on the coverage tier (for example, 12–16 weeks minus 20%, 16–24 minus 30%, above 24 minus 40%). Novelties, bestsellers and the core range go into exceptions. Shows the label and tier for each item, the number of items and the stock sum in the cut. It is a selection rule in practice; the dates and depth by scenario are counted by the “Discount ladder” and “Sale stages”.
At a glance
- What question does it answer?
- Which items fall into the price cut by the rule and at which tier.
- What data is needed?
- Stock, rate, age and an exception flag per item.
- How to read the result?
- Look at the number of items and the stock sum in the cut; check the exceptions by hand. Example on the default values: Items in the cut: 3; Share of items in the cut: 75%; Pieces in the cut: 1,700; Share of stock in the cut: 93.4%. The figures are illustrative: enter your own to see your result.
Why and how to reason
A rule by coverage and age selects items without manual sorting. In the example the threshold is 12 weeks, tiers 16 and 24, depth 20, 30, 40%: A coverage 15.0 weeks minus 20%, B 33.3 weeks minus 40%, C 36.0 weeks minus 40%, D a novelty is excluded. 3 items and 1,700 pcs are in the cut.
When to use it
Apply weekly in season with dates by the marketplace promotion calendar and the control week.
How to read the result
Look at the number of items and the stock sum in the cut; check exceptions by hand.
Common mistakes
The same thresholds for all categories, cutting the price of novelties.
What data is needed?
- Stock, rate, age and an exception flag per item.
- Coverage thresholds and depth by tier.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Coverage from which to cut the price | weeks | 12 | Coverage is stock ÷ sales rate. You set the threshold for your category: there is no common norm. The example value is illustrative. |
| Coverage of the second tier | weeks | 16 | Above this coverage the depth is greater. The example value is illustrative. |
| Coverage of the third tier | weeks | 24 | Above this coverage the depth is the maximum. The example value is illustrative. |
| Age up to which the item is a novelty | weeks | 4 | Novelties are not cut: they need time to reach full sell-through. The example value is illustrative. |
| Depth of the first tier | % | 20 | For coverage between the first and second thresholds. The example value is illustrative. |
| Depth of the second tier | % | 30 | For coverage between the second and third thresholds. The example value is illustrative. |
| Depth of the third tier | % | 40 | For coverage above the third threshold. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Coverage | stock ÷ sales rate per week |
| Exceptions | an exception flag or an age of 4 weeks or less |
| Tier | coverage above 12 weeks: −20 %; above 16: −30 %; above 24: −40 % |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Items in the cut
- 3
- Share of items in the cut
- 75 %
- Pieces in the cut
- 1,700
- Share of stock in the cut
- 93.4 %
- Stock in the cut at cost
- 2.37 m ₽
- Average depth (by pieces)
- 36.5 %
- Exceptions
- 1
- Coverage
- Threshold
Data as a table
| Measure | Coverage | Threshold |
|---|---|---|
| A | 15 | 12 |
| B | 33.3 | 12 |
| C | 36 | 12 |
| D | 4 | 12 |
Item labels
| Item | Coverage, weeks | Age, weeks | Label | Price cut | Stock at cost |
|---|---|---|---|---|---|
| A | 15 | 6 | price cut | −20 % | 540,000 ₽ |
| B | 33.3 | 20 | price cut | −40 % | 750,000 ₽ |
| C | 36 | 30 | price cut | −40 % | 1.08 m ₽ |
| D | 4 | 3 | novelty, exception | — | 240,000 ₽ |
What to do with the result: fit the cut dates to the marketplace promotion calendar and the control week; set the thresholds separately by category and season. Check the exception items by hand.
A typical mistake: the same thresholds for all categories and cutting the price of novelties before they reach full sell-through.
Nuances and limits
- The same thresholds for all categories.
- Cutting the price of novelties.