After a stock import, lists failed lines, wrong product categories, negative or reserved quantities, and styles in stock on the website but missing at the tills.
Stock & Inventory
Footwear retail
Scheduled worker
Productised
Hybrid
2026
The problem
The shop and the stock system drift apart. A failed import, a wrong product category, or a quantity that went negative or showed as reserved was repaired by hand over many hours. Customers could also order a pair the tills did not hold, because bad style codes stopped the two systems matching.
What it does
Each import leaves a problem list of failed lines, wrong product categories, and negative or reserved quantities. A second view lists styles in website stock but missing at the tills, with the style codes that stopped the match. A person clears a bad code from the same screen, so the next sync can link the style.
Outcomes
A failed import is a list to work through, and nobody repairs it by hand.
Negative and reserved quantities show after each run.
Website stock that the tills do not hold is listed before a customer orders it.
A bad style code can be cleared from the same screen.
Simplified mockup
Interactive preview with sample data. Nothing is sent to a server.
Exception queue
Exceptions open
6
Failed, class, negative
Cleared
0
Web only
4
Till has none
Committed
1
Listed beside the queue
07:40 import, 7 rows to read
This morning’s import
Line
Style
Fault
Detail
1841
No style
Failed
Barcode 9901841000007 is not on the till
1842
Ivy plimsoll
Failed
Size column is empty
1908
Juniper brogue
Failed
Duplicate of line 1840
1766
Kelp insole
Haberdashery
Allowed class is Footwear.
2210
Fern boot
Negative
UK 4 on hand −2
2214
Gorse welly
Negative
UK 11 on hand −1
2302
Thistle mule
Committed
UK 6 on hand 4, committed 3
3 failed1 bad class2 negative1 committed, not in the 6
On the website, missing at the till
6 exceptions open, 0 cleared. 4 styles can still be ordered online.
Pick a blocked code
Lookup codes that blocked the match
Style
Web
Lookup
Why it failed
Ash court
6
ASH-1044
Code points at a deleted till item
Birch trainer
3
BRH-2201
Same code is on two styles
Cobble sandal
2
CBL-118
Code has a trailing space
Drift loafer
5
DNL-0902
Code belongs to Juniper brogue
6 exceptions open, 1 cleared.
ASH-1044 cleared. Ash court drops off this list and can match on the next sync.
How it works
Run the stock import and collect the lines that failed.
Flag product categories that are not in the allowed list.
Flag quantities that are negative or still reserved.
Compare website stock with till stock for the linked styles.
List website-only styles beside the style codes that blocked them.
Clear a bad code and watch the mismatch drop off the list.
Pipeline
flowchart LR
A[StockImport] --> B[FailedLines]
A --> C[BadItemClass]
A --> D[NegativeOrCommitted]
E[WebStock] --> F[TillCompare]
G[TillStock] --> F
F --> H[BadLookupCodes]
H --> I[ClearAndRelink]