Start Your Project
Case study · BBCS-03
Retail Intel · retail & sportswear

Eyes on every product, from the loading bay to the sale

A global sportswear brand trades inside one of London's great department stores, and the store's own intake process meant the brand never knew when its products actually reached the rails. We designed and built the platform that instruments that journey: courier feed in, barcode scans through the stockroom and onto the floor, and sell-through analytics that finally run on true dates.

Sector
Retail & sportswear
Setting
London flagship concession
Scope
Design to production
Users
Brand HQ / store team / VM
Output
Platform + iPad capture + integrations
What the platform does

From stockroom scan to shop-floor decision

Everything from the stockroom scan to the shop-floor heat map, on one platform.

Inventory tracking
Barcode capture
Journey tracking
Stock ageing
Sell-through analytics
Discrepancy management
Visual merchandising
Heat maps
POS integration
The problem

The last mile of wholesale was a black hole

Once products shipped to the store, the brand lost sight of them completely - what arrived in the stockroom, what made it onto the floor, what was selling, what was ageing on the shelf. Decisions for one of its most prestigious accounts ran on guesswork and quarterly reports that landed weeks too late.

01

Launch dates that lied. A product "launched" on the 1st might not touch a rail until the 8th. Week-one sell-through was understated by design, and the buying and allocation decisions built on it inherited the error.

02

A host store's intake, not the brand's. Deliveries moved through the department store's own receiving process - complex, shared with every other brand in the building, and invisible from HQ. Chasing a delivery meant phone calls.

03

Mis-deliveries surfaced weeks late. Stock that arrived by mistake, or carried a barcode the brand's master inventory did not recognise, was only discovered at the next manual count - long after anything could be done about it.

The cost of getting it wrong
Sell-through
The number

Sell-through rate is the number a wholesale brand runs on - it drives buying, allocation and markdown decisions. Diluted dates dilute all three.

Last-mile visibility
Zero

From the moment stock left the warehouse to the moment it sold, the brand had no view of it at all - not arrival, not the floor, not what was ageing.

Between counts, darkness

From one manual count to the next, the stockroom was invisible: no ageing picture, no mis-delivery alerts, no floor-coverage view.

Figures from the engagement; client references under NDA
What we built

One platform, three systems, every timestamp that matters

Six screens from the platform, each shown as it runs on the device you are reading this on. The first four are the stock intelligence system; the last two are the visual merchandising layer that grew on top of it once the data existed.

Part one · Stock intelligence

Live Overview

Kingsgate Concession - Real-time stock intelligence

Last scan 2m ago
12%
147
Stock In Today
8%
89
Moved to Floor
23%
34
Units Sold
5%
12
Returns
Stock Journey Status
58
In Transit
234
Stockroom
412
On Floor
1,847
Sold (MTD)
Active Alerts
12 items in stockroom > 7 days
Runner Elite, Court Classic, Street Knit
7 unknown barcodes scanned
Today at 14:32, 11:15, 09:47
Zone C sell-through below target
32% vs 45% target · 7-day trend
Live Activity
Sale Recorded
Indoor Classic / Black / UK 9 - Zone A, Rail A-03
Just now
Moved to Floor
8 items to Zone B - Performance
3 min ago
Sale Recorded
Runner Elite / Core Black / UK 10
7 min ago
Stock Received
DEL-2024-0852 - 47 items logged
12 min ago
Unknown Barcode
UNK-X7F2K9M3 flagged for review
14 min ago
Returned to Stock
3 items - End of Season
23 min ago
Moved to Floor
12 items to Zone C - Footwear
31 min ago
Sale Recorded
Court Classic / Cloud White / UK 8
38 min ago

Live Overview

Kingsgate Concession - Real-time stock intelligence

Last scan 2m ago
12%
147
Stock In Today
8%
89
Moved to Floor
23%
34
Units Sold
5%
12
Returns
Stock Journey Status
58
In Transit
234
Stockroom
412
On Floor
1,847
Sold (MTD)
Active Alerts
12 items > 7 days
Runner Elite, Court Classic…
7 unknown barcodes
Today 14:32, 11:15, 09:47
Zone C below target
32% vs 45% target
Live Activity
Sale Recorded
Indoor Classic / Black / UK 9
Now
Moved to Floor
8 items to Zone B
3m
Sale Recorded
Runner Elite / UK 10
7m
Stock Received
DEL-2024-0852
12m
Unknown Barcode
UNK-X7F2K9M3
14m
R
RETAIL INTEL
Last scan 2m ago
Live Overview
Kingsgate Concession
12%
147
Stock In Today
8%
89
Moved to Floor
23%
34
Units Sold
5%
12
Returns
Stock Journey
58
In Transit
234
Stockroom
412
On Floor
1.8K
Sold MTD
Active Alerts
12 items in stockroom > 7 days
Runner Elite, Court Classic, Street Knit
7 unknown barcodes scanned
Today at 14:32, 11:15, 09:47
Zone C sell-through below target
32% vs 45% target · 7-day trend
Overview
Ageing
Scan
Heat Maps
More
01Live overviewEvery product's position - delivery, stockroom, floor, sold - and today's movement, in one HQ view.
R
RETAIL INTEL
Stock In
Kingsgate Stockroom
Receiving
Scan Products
DEL-2024-0847
Auto-detected from carrier manifest
Ready to Scan
Scanned Items
7items
SKU-007
Indoor Classic / Black / UK 9
UNK-8H2KD01A
Unknown - Not in master database
SKU-001
Runner Elite / Core Black / UK 9
SKU-003
Retro Trainer / Navy Blue / UK 10
UNK-3XPQ77RC
Unknown - Not in master database
SKU-002
Court Classic / Cloud White / UK 8
SKU-005
Street Knit / Grey / UK 11
2 items not found in master database - will be flagged for review
R
RETAIL INTEL
Stock In
Kingsgate Stockroom
Receiving
Scan Products
DEL-2024-0847
Auto-detected from carrier manifest
Ready to Scan
Scanned Items
7items
SKU-007
Indoor Classic / Black / UK 9
UNK-8H2KD01A
Unknown - Not in master database
SKU-001
Runner Elite / Core Black / UK 9
SKU-003
Retro Trainer / Navy Blue / UK 10
UNK-3XPQ77RC
Unknown - Not in master database
SKU-002
Court Classic / Cloud White / UK 8
SKU-005
Street Knit / Grey / UK 11
2 items not found in master database - will be flagged for review
R
RETAIL INTEL
Last scan 2m ago
Stock In
Kingsgate Stockroom · DEL-2024-0847
Receiving
Ready to Scan
Scanned Items
7items
SKU-007
Indoor Classic / Black / UK 9
UNK-8H2KD01A
Unknown - flagged for review
SKU-001
Runner Elite / Core Black / UK 9
SKU-003
Retro Trainer / Navy Blue / UK 10
Overview
Ageing
Scan
Heat Maps
More
02Stock captureThe stockroom iPad: batch scanning in and out, built so a Saturday shift can use it without training.

Stock Ageing

Kingsgate Concession - Stockroom dwell time and slow-moving lines

Filter
Export
+3
12
Over 7 Days
+1
3
Critical · 15+ Days
0.3
4.2days
Avg In Stockroom
€210
€1,340
Value At Risk
Aged Inventory
SORTED · OLDEST FIRST
Product
SKU
Location
Age
Status
Action
Runner Elite
Core Black · UK 10
SKU-3062
SR · B-04
21d
Overdue
Court Classic
Cloud White · UK 8.5
SKU-5502
SR · B-02
18d
Overdue
Street Knit
Grey Three · UK 9
SKU-9256
SR · B-05
16d
Overdue
Indoor Classic
Core Black · UK 9
B75807
SR · A-06
13d
Ageing
Retro Trainer
Collegiate Navy · UK 7
SKU-5478
SR · A-08
12d
Ageing
Court Low
Cloud White · UK 11
SKU-7756
SR · B-01
11d
Ageing
Shell Court
White / Black · UK 8
SKU-4958
SR · B-03
9d
Ageing
Campus Retro
Dark Green · UK 9
SKU-8708
SR · A-02
8d
Ageing
SHOWING 8 OF 12 OVER 7 DAYS
View All
Ageing Distribution
234
units in stockroom
0–7 Days Fresh222
8–14 Days Ageing9
15–30 Days Overdue3
30+ Days Critical0
Recommended Actions
Move 6 ageing lines to floor
Markdown 3 overdue SKUs
Return 1 end-of-season line

Stock Ageing

Kingsgate Concession - Stockroom dwell time

Export
+3
12
Over 7 Days
+1
3
Critical 15+
0.3
4.2
Avg Days
€210
€1,340
At Risk
Ageing Distribution
234 UNITS
0–7 Fresh222
8–14 Ageing9
15–30 Overdue3
30+ Critical0
Aged Inventory
OLDEST FIRST
Product
SKU
Age
Status
Action
Runner Elite
Core Black · UK 10
SKU-3062
21d
Overdue
Court Classic
Cloud White · UK 8.5
SKU-5502
18d
Overdue
Street Knit
Grey Three · UK 9
SKU-9256
16d
Overdue
Indoor Classic
Core Black · UK 9
B75807
13d
Ageing
Retro Trainer
Collegiate Navy · UK 7
SKU-5478
12d
Ageing
Court Low
Cloud White · UK 11
SKU-7756
11d
Ageing
SHOWING 6 OF 12 OVER 7 DAYS
R
RETAIL INTEL
Last scan 2m ago
Stock Ageing
Kingsgate Concession
+3
12
Over 7 Days
+1
3
Critical 15+
0.3
4.2
Avg Days
€210
€1,340
At Risk
Distribution
234 UNITS
2220–7d
98–14d
315–30d
030+d
Aged Inventory
Runner Elite
Core Black · UK 10
21d
SKU-3062 · SR B-04Overdue
Court Classic
Cloud White · UK 8.5
18d
SKU-5502 · SR B-02Overdue
Street Knit
Grey Three · UK 9
16d
SKU-9256 · SR B-05Overdue
Indoor Classic
Core Black · UK 9
13d
B75807 · SR A-06Ageing
Overview
Ageing
Scan
Heat Maps
More
03Stock ageingAnything sitting in the back too long is flagged before it becomes a markdown problem.

Discrepancies

Kingsgate Concession - Stock accuracy exceptions

Filter
Export
+2
7
Open Discrepancies
€180
€1,204
Value Variance
+1
3
Unknown Barcodes
+5
18
Resolved · 7 Days
Open Exceptions
SORTED · NEWEST FIRST
Item
Type
Location
Status
Action
Unrecognised scan
UNK-X7F2K9M3
Unknown
Stock In
Flagged
Runner Elite
SKU-3062 · Sys 12 / Found 9 · −3
Count
SR · B-04
Open
Court Classic
SKU-5502 · Sys 6 / Found 0 · −6
Missing
Zone A · A-03
Open
Street Knit
SKU-9256 · Found in Zone D
Misplaced
exp. Zone C
Misplaced
Unrecognised scan
UNK-B3H8L2P5
Unknown
Stock In
Flagged
Retro Trainer
SKU-5478 · Sys 8 / Found 7 · −1
Count
SR · A-08
Open
Unrecognised scan
UNK-M9K4T1W7
Unknown
Stock In
Flagged
7 OPEN DISCREPANCIES
Resolve All
By Type
7
open exceptions
Unknown Barcode3
Count Variance2
Missing Item1
Misplaced1
Bulk Actions
Review 3 unknown barcodes
Queue 2 SKUs for recount
Assign 1 relocation task

Discrepancies

Kingsgate Concession - Stock exceptions

Export
+2
7
Open
€180
€1,204
Value Var.
+1
3
Unknown
+5
18
Resolved 7D
By Type
7 OPEN
Unknown3
Count2
Missing1
Misplaced1
Open Exceptions
NEWEST FIRST
Item
Type
Status
Action
Unrecognised scan
UNK-X7F2K9M3
Unknown
Flagged
Runner Elite
SKU-3062 · −3
Count
Open
Court Classic
SKU-5502 · −6
Missing
Open
Street Knit
SKU-9256 · Zone D
Misplaced
Moved
Unrecognised scan
UNK-B3H8L2P5
Unknown
Flagged
Retro Trainer
SKU-5478 · −1
Count
Open
SHOWING 6 OF 7 OPEN
R
RETAIL INTEL
Last scan 2m ago
Discrepancies
Kingsgate Concession · 7 open
+2
7
Open
€180
€1,204
Value Var.
Open Exceptions
7 ITEMS
Unrecognised scan
UNK-X7F2K9M3 · Stock In
Flagged
Unknown Barcode
Runner Elite
SKU-3062 · Sys 12 / Found 9 · −3
Open
Count Variance · SR B-04
Court Classic
SKU-5502 · Sys 6 / Found 0 · −6
Open
Missing · Zone A A-03
Street Knit
SKU-9256 · Found in Zone D
Moved
Misplaced · exp. Zone C
Overview
Ageing
Scan
Heat Maps
More
04DiscrepanciesUnknown barcodes and mis-deliveries are captured at the door and flagged to HQ the same day, not found at the next count.
Part two · Visual merchandising
Metric
Footfall
Dwell Time
Sales Density
Today
7 Days
30 Days
Last scan 2m ago
Zone A · Lifestyle
Zone B · Performance
Zone C · Footwear
Zone D · Accessories
A-01
A-02
A-03
A-04
A-05
A-06
B-01
B-02
B-03
B-04
C-01
C-02
C-03
C-T1
C-T2
D-01
D-02
M1
M2
Fitting
2 METRES
94
88
78
61
32
Main Entrance
Low
High
Insights
TODAY
Peak Zone
Zone C · Footwear
94
Intensity index
Zone Intensity
Zone C · Footwear94
Zone A · Lifestyle78
Zone B · Performance61
Zone D · Accessories32
1,847
Footfall Today
3:12
Avg Dwell (min)
Footfall
Dwell
Sales
Today
7D
30D
Zone A · Lifestyle
Zone B · Performance
Zone C · Footwear
Zone D · Accessories
A-01
A-02
A-03
A-04
A-05
A-06
B-01
B-02
B-03
B-04
C-01
C-02
C-03
C-T1
C-T2
D-01
D-02
M1
M2
Fitting
2 METRES
94
88
78
61
32
Main Entrance
Low
High
Insights
Peak Zone
Zone C · Footwear
94
Zone Intensity
Zone C94
Zone A78
Zone B61
Zone D32
1,847
Footfall Today
R
RETAIL INTEL
Last scan 2m ago
Heat Maps
Kingsgate Concession · Footfall
Footfall
Dwell
Sales
Zone A · Lifestyle
Zone B · Performance
Zone C · Footwear
Zone D · Accessories
A-01
A-02
A-03
A-04
A-05
A-06
B-01
B-02
B-03
B-04
C-01
C-02
C-03
C-T1
C-T2
D-01
D-02
M1
M2
Fitting
2 METRES
94
88
78
61
32
Main Entrance
Low
High
Zone Intensity
1,847 VISITS
Zone C · Footwear94
Zone A · Lifestyle78
Zone B · Performance61
Zone D · Accessories32
Overview
Ageing
Scan
Heat Maps
More
05Heat mapsSell-through mapped onto the floor itself: which zones earn their space, and which do not.
Kingsgate · Main Floor Draft
100%
Zone A · Lifestyle
Zone B · Performance
Zone C · Footwear
Zone D · Accessories
A-01
A-02
A-03
A-04
A-05
A-06
B-01
B-02
B-03
B-04
C-01
C-02
C-03
C-T1
C-T2
D-01
D-02
M1
M2
Fitting
2 METRES
Properties
Fixtures
Properties
Rail A-03
ID · A-03
Asset Code
A-03
Zone
Zone A · Lifestyle
Width (cm)
120
Depth (cm)
60
Capacity (SKUs)
24
Notes
Optional notes…
Main Floor Draft
Zone A · Lifestyle
Zone B · Performance
Zone C · Footwear
Zone D · Accessories
A-01
A-02
A-03
A-04
A-05
A-06
B-01
B-02
B-03
B-04
C-01
C-02
C-03
C-T1
C-T2
D-01
D-02
M1
M2
Fitting
2 METRES
Fixtures
Fixtures
Properties
Drag to canvas
Rail
Table
Wall Unit
Mannequin
Fitting
Till
Seating
POSM
R
RETAIL INTEL
Last scan 2m ago
Floor Plan Editor
Kingsgate Concession · Main Floor
Draft
Zone A · Lifestyle
Zone B · Performance
Zone C · Footwear
Zone D · Accessories
A-01
A-02
A-03
A-04
A-05
A-06
B-01
B-02
B-03
B-04
C-01
C-02
C-03
C-T1
C-T2
D-01
D-02
M1
M2
Fitting
2 METRES
Main Floor
Selected Fixture
Zone A
Rail A-03
ID · A-03 · Lifestyle
Width
120 cm
Depth
60 cm
Capacity
24 SKUs
Zone
A · Lifestyle
Overview
Ageing
Scan
Heat Maps
More
06Floor plan editorLayouts drawn, versioned and A/B tested against the sell-through they produce.
Our part

The calls we made

Paul Banks, Founder and Lead Consultant
Paul Banks
Founder & Lead Consultant
Led end to end by a senior team, from the first call through to handover.

The department store's intake process was never going to change for one brand. We built around it: a courier feed for arrival, scanners at the stockroom door and the floor door, and let the store keep working exactly as it always had.

Capture had to survive retail reality - seasonal staff, rush deliveries, no training window. Batch scanning into one window, one submit, and the platform does the thinking.

A scanner that rejects a barcode blocks a delivery. We accepted everything, synced every scan against the brand's master inventory, and turned the unknowns into same-day discrepancy alerts at HQ - mis-deliveries became information instead of surprises.

Sell-through only means something if day one is the day customers could buy. Every metric in the platform runs from the floor scan, integrated with the sales tool so the sale closes the loop automatically.

Built by a senior team end to end and handed over with the client owning the platform outright.

Paul Banks, Founder and Lead Consultant Paul Banks, Founder and Lead Consultant
Paul Banks
Founder & Lead Consultant
Led end to end by a senior team, from the first call through to handover.
Outcome

Sell-through the brand could finally trust

Every product timestamped from the loading bay to the sale. Mis-deliveries flagged the day they happen. And a floor that gets measured, redrawn and tested like the asset it is.

Data accuracy
+32%

Every product now tracked from warehouse dispatch through stockroom arrival, floor placement and point of sale. For the first time the brand had genuine sell-through intelligence at store level.

0→100%
Last-mile visibility, from a complete blind spot to the full journey warehouse to sale
3
Systems connected - HQ platform, in-store iPad capture and point-of-sale integration
Real time
Stock position, ageing and sell-through, replacing quarterly reports that arrived weeks late

Buying and allocation decisions now run on dates that are true.

Built to standard

Handled to the standard the work demands

Brand data isolation

The brand's master product inventory synced into the platform; store-side data captured and segregated to the concession. Nothing crosses the host store's systems that should not.

Retail-floor reality

Capture built for the stockroom as it is - batch scanning, graceful handling of unknowns, and interfaces seasonal staff use without training.

Client-owned, references under NDA

Built senior-only and handed over with the client owning the platform outright. Client names available under NDA.

Get in Touch

Ready To Transform?

Let's discuss how we can build the systems
and intelligence your business needs.

Paul Banks
Paul Banks Founder & Lead Consultant I handle all enquiries personally and look forward to hearing about your project.

Quick Assistance

Chat with us directly on WhatsApp.

Open WhatsApp →

Email Us

Gmail, Outlook, Yahoo & more.

Choose your email app →

BY BANKS L.L.C-FZ

License No. 2425027.01

Meydan Free Zone, Dubai, UAE

Procurement-ready · UAE registered

Web clients open in a new tab

Still exploring?

We'd love to help you find what you're looking for. Whether you have a project in mind or just want to learn more about what we do.