Skip to content
All case studies Ecommerce

Merchandising demand-signal workflow

A multi-category retailer replaced a day and a half of weekly dashboard-scraping with a single ranked action list — each call backed by an explicit reason.

Representative engagement — the figures below model a typical project of this kind, not a named-client audited result.

SectorMulti-category online retail
Scale~9,000 active SKUs
Team4-person buying team
Engagement~7 weeks, audit to handover
The challenge

Five dashboards, one gut feeling

Restock and markdown decisions were made weekly by hand. Buyers pulled sales velocity, stock cover, review sentiment, and return rates from five separate dashboards and reconciled them in their heads.

It cost about a day and a half of analyst time every week, and the lag meant the team reacted late — stockouts on the risers, overstock on the decliners.

What we built

One ranked list, every signal, every Monday

We built a workflow that aggregates sales velocity, days of cover, review sentiment, return rates, and competitor-availability signals into a single weekly ranked action list.

Each item is tagged restock, reorder, mark down, or investigate — with a plain-language rationale and the supporting numbers — and delivered straight into the team's existing planning sheet.

  • Five demand signals aggregated into one model
  • Weekly ranked action list with restock / markdown / investigate tags
  • A plain-language rationale and source numbers on every call
  • Delivered into the team's existing planning sheet
The figures

What changed, by the numbers.

~20 minWeekly analysis prep (was ~1.5 days)
−38%Stockout days on top-quartile sellers
−24%Aged inventory over 90 days
100%Markdown calls backed by an explicit rationale

Weekly analysis prep

Before
~1.5 days
After
~20 min

Aged inventory (>90 days)

Before
Baseline
After
−24%
The outcome

Decisions backed by signal, not by Sunday-night guesswork

The buying team now starts each week with a ranked list instead of five dashboards. Stockouts on the best sellers fell sharply and aged inventory shrank — and because every call carries its reasoning, decisions hold up when someone asks "why".

Have a process like this one?

Get in touch hello@fivela.net