Retail & e-commerce
Repricing Frequency
The repricing cadence each category calls for, and what the team can absorb.
The problem
In most retailers, repricing frequency settles in without ever being decided. Weekly because a tool allows it, monthly because the team cannot manage more, and then applied uniformly across the whole assortment. Fiercely contested categories end up tracked too slowly, while stable categories consume processing time for no measurable return at all.
What is missing is a four-way trade-off: the cost of waiting on a category where competitor prices drift, the operational cost of a price change, what rate of sale makes worthwhile, what the team can absorb. Each of those four figures exists somewhere in the organisation, rarely in the same place. The calculation brings them together, category by category.
Repricing Frequency
How to read the result
Input
- Drift of competitor prices in the category, assumed linear and one-way, in percentage points per week
- Rate of sale and average assortment lifespan, which caps the cadence; cadence does not go below one week
- Operational cost of a price change, per item tracked: labelling, verification, systems
- Team capacity, in items processable per week
- Weekly revenue of the category, share exposed to comparison, and sensitivity of exposed revenue to the price gap
How to read the result
- Cadence is reasoned per category; one company-wide rhythm over-invests in stable ones, and its extra cost is sized for a uniform cadence of 1 to 12 weeks
- Between the workload of the right cadences and capacity, the gap sizes the case for automation; where capacity falls short, the recommendation is an optimal allocation by category under the workload constraint, with its weekly extra cost
- The fast-cadence alert fires only when the cadence is 4 weeks or less and exposure is below 50%: the effort then sits in the wrong place
- A category with no drift and no rotation is flagged with an undefined cadence and left out of the workload total
Limits
- The drift entered describes a past and assumes a linear, one-way slide. Competitor prices that oscillate are not captured, and an open price war or a new entrant changes the regime with no warning at all.
- The cost of a price change is taken as uniform, when in store it depends on floor space, facing count and electronic shelf label coverage.
- Perception cost enters nowhere. A price that moves too often becomes unreadable to the customer, and no optimal frequency internalises that effect.
- Team capacity serves as a fixed constraint. It varies sharply with the quality of competitor price feeds and how far pricing rules are automated.
The resulting cadence is revisited when the competitive landscape on that category moves seriously, not on a fixed calendar. An unreadable entry leaves the last valid value in place with a message, and any value brought back to a limit is flagged. Numbers are read according to the language of the page: comma or point in French, point in English, comma in German and Spanish.
In the glossary
A first thirty-minute conversation
The tool gives the order of magnitude. The decision that follows can be discussed in thirty minutes.