About Services Tools Blog Contact us

Seasonal Sell-through Report

Shows how fast each style is selling against the season, when it may sell out, and how customers split between first order and repeat.

  • Reporting Dashboards
  • Retail
  • Dashboard feature
  • Productised
  • Hybrid
  • 2026

The problem

Buyers could not see which styles would sell out before the season ended, so reorders came late or were wasted. Someone assembled sell-through in a spreadsheet each time a person asked which lines were moving. Questions about customers needed a separate report, rebuilt whenever marketing asked who was buying.

What it does

Sell-through is the quantity sold divided by opening stock. The expected sell-out date comes from the daily sales rate and the remaining stock. A suggestion compares sell-through with how much of the season has passed. The same screen groups buyers by period, so customer questions need no separate report.

Outcomes

  • Each style shows a sell-through bar, a sell-out date and a reorder or hold label.
  • Fast lines are badged before the season runs out.
  • Customer groups update with the same date range.
  • A product family filter updates the table without a new spreadsheet.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Sell-through

Autumn 2026 1 Aug to 30 Nov 40% of the season has passed

Repeat when sell-through is ahead of the season. Hold when it is behind. Fast means the line sells out before 30 Nov.

StyleSell-throughSell-outCall
Fenwick Chelsea Fast
Boots · 168 of 240
70% 18 Oct 2026 Repeat
Harlow Court
Boots · 96 of 180
53% 12 Nov 2026 Repeat
Pebble Trainer
Trainers · 210 of 320
66% 2 Nov 2026 Repeat
Linnet Brogue
Shoes · 38 of 150
25% After season Hold
Calder Sandal
Sandals · 12 of 90
13% After season Hold

Buyers, 1 Aug to 17 Sep

First order 42 · £18,400
CustomerTownOrder
Emma HaleBrighton£86
Ben CroftReading£124
Laura WhitbyCanterbury£64
Ian PreeceDover£210
Chloe AldenOxford£48
Repeat 67 · £41,200
CustomerTownLatest
Michael Hale 4thBrighton£340
Rachel Croft 3rdMaidstone£188
Will Nunn 2ndAshford£96
Karl Penrose 6thSevenoaks£420
Jess Alden 2ndTelford£72

Export the visible table

All families is selected, so the file contains five styles. Change the family on the Styles tab and the download follows the rows still in view. Nothing is sent to a server.

  1. Read the family filter
  2. Take the visible styles
  3. Write the CSV in the browser
Ready
sell_through_autumn_2026.csv

How it works

  1. Read items, purchase lines, transactions and the season calendar.
  2. Work out sell-through and a sell-out date from the daily sales rate.
  3. Mark fast and slow styles, and flag styles likely to sell out before the season ends.
  4. Suggest whether to reorder or hold.
  5. Group customers into first-time and returning buyers for the same dates.
  6. Filter by product family and export the visible table.

Pipeline

flowchart LR
  Till["Sales and stock"] --> Rate["Daily rate"]
  Rate --> Through["Sell-through"]
  Rate --> Date["Sell-out date"]
  Through --> Chip["Repeat or hold"]
  Orders["Customer orders"] --> Cohort["First order or repeat"]