Business modules

Ordering and stock

See at a glance what is out of stock and losing sales, and where capital is tied up.

The right stock in the right place: what, how much and for which store to order, plus lost sales and overstock.

Demo dataLive
To order36
Critical12
Cover24 days

What it looks like

The system’s home screen — with demo data.

Home · Demo data
Home

2,684,950 revenue 812,300 margin 1,126,400 stock

All budget groups · all brands · 9 stores · Oct 25 – Oct 26 (current)
Revenue2,684,950excl. VAT · 36,480 items▲ 8.2% YoY
Oct 25 – Sep 26
2,512,600
Oct 24 – Sep 25
2,322,200
Margin · revenue − cost812,30030.3% of revenue▲ 5.7% YoY
Oct 25 – Sep 26
760,300
Oct 24 – Sep 25
719,300
Stock1,126,400current stock at cost
average
1,214,800
since Sep 2025
▼ 6.3%
last ~30 days
▼ 0.8%
GMROI0.63turnover 1.44×▲ 10.5% YoY
Oct 25 – Sep 26
0.63
Oct 24 – Sep 25
0.57
Dead stock197,6003,870 with no sales
of stock
17.5%
idle over 12 mo.
151,300
new, unsold
46,300
Stopped selling2,960no sales in the last 6 mo.
stock in them
58,700
revenue before
214,500
New items1,830first sale recently
revenue
156,400
share of revenue
5.8%
stock in them
41,900
Lost margin19,850per month23% of possible margin
units / month
4,380
revenue / month
64,700
TOC buffers
12%8%14%34%32%
Critical1,050
Urgent700
Soon1,220
OK2,970
Overstock2,800
To order

118,760 at cost

2,410 lines · 9,380 pcsGo to orders →

H / B / T · by revenue

HHead
SKU
3,280 (9.0%)
GMROI
1.34
Sales
1,718,400 (64.0%)
Turnover
3.05
Stock
259,100 (23.0%)
BBody
SKU
10,580 (29.0%)
GMROI
0.69
Sales
805,500 (30.0%)
Turnover
1.52
Stock
405,500 (36.0%)
TTail
SKU
22,620 (62.0%)
GMROI
0.11
Sales
161,050 (6.0%)
Turnover
0.29
Stock
461,800 (41.0%)

X / Y / Z · stability

XStable
SKU
1,090 (3.0%)
GMROI
1.18
Sales
1,101,000 (41.0%)
Turnover
2.71
Stock
236,500 (21.0%)
YVariable
SKU
4,010 (11.0%)
GMROI
0.71
Sales
832,300 (31.0%)
Turnover
1.63
Stock
304,100 (27.0%)
ZErratic
SKU
31,380 (86.0%)
GMROI
0.38
Sales
751,650 (28.0%)
Turnover
0.96
Stock
585,800 (52.0%)

M1–M3 · margin class

M1High margin
SKU
2,920 (8.0%)
GMROI
1.52
Margin
487,400 (60.0%)
Turnover
3.24
Stock
247,800 (22.0%)
M2Mid margin
SKU
10,210 (28.0%)
GMROI
0.66
Margin
276,200 (34.0%)
Turnover
1.49
Stock
383,000 (34.0%)
M3Low margin
SKU
23,350 (64.0%)
GMROI
0.09
Margin
48,700 (6.0%)
Turnover
0.31
Stock
495,600 (44.0%)

Group focus

Flagship
6 groups38% revenue
14% stock
Strategic
21 groups29% revenue
19% stock
Profitable niche
12 groups6% revenue
3% stock
Big but inefficient
4 groups7% revenue
13% stock
Inefficient
23 groups3% revenue
12% stock
Centralise
140 groups4% revenue
15% stock
Watch
61 groups11% revenue
20% stock
Mix (small groups)
3 groups2% revenue
4% stock

How it works

  1. 1Real demand

    The sales rate is measured only on days the item was in stock, so a stock-out never reads as weak demand. Interchangeable items from different brands can be counted together as one group.

  2. 2A buffer per item and store

    The buffer is the most that can sell before the next delivery arrives — based on the lead time, the cover you want and seasonality.

  3. 3Zones and priority

    Stock is compared with the buffer: Critical, Urgent, Soon, OK or Overstock. Orders go first where the buffer is most depleted and sales are already being lost.

  4. 4Order and allocation

    The order tops up what was sold back to the buffer. It is split across stores by the chance of a sale, following any rules the company has set.

What you see at a glance

In day-to-day work

What it includes

  • How much you lose to stock-outs — in money
  • How much capital is tied up in overstock
  • What, how much and for which store to order
  • TOC ordering instead of guesswork

A good fit if

  • Some items run out while others gather dust
  • Supplier orders are made by gut feeling
  • Our cash sits frozen in the warehouse

Technology

AppSQLERP

Frequently asked questions

Who is it for?

Retailers and distributors with many items and locations — chains, wholesale and retail — especially with a central warehouse and interchangeable brands.

Why is it better than ordering from a forecast?

Instead of guessing the future, the system tops up what was sold to a buffer computed from real demand. The method follows the Theory of Constraints (TOC): more sales with less capital tied up and higher turnover.

What data do we need?

Sales by store and month, days in stock, current stock, purchase costs and item groups. Data is read straight from your ERP database, with no manual entry.

Do we have to replace our ERP?

No. The system reads from your ERP, and the finished order is copied to Excel or exported as CSV for your ERP.

Can we adjust the order by hand?

Yes. Any quantity changes with a click, lines can be left out of the order, and the item card explains why that quantity was suggested.

Where does it run?

A web app on your own server or in Microsoft Azure, used in the browser. Data reloads from the database with one button, for every user at once.

Want this solution for your business?

Tell us how you work today — we will show you what the solution looks like with your data.

Get in touch