Compares till stock with OpenCart and lists mismatches, missing codes and risky quantities. It keeps layaway separate from free stock.
Stock & Inventory
Footwear retail
Dashboard feature
Productised
Hybrid
2026
The problem
The shop could hold stock that customers could not buy, because the OpenCart size was missing, switched off or at zero. Some OpenCart codes pointed at sizes the till did not know. Negative quantities, over-committed sizes and uncategorised items stayed hidden unless someone queried the till by hand, and layaway was counted as free stock.
What it does
The desk compares on-hand till stock with OpenCart and lists sizes that are missing online, switched off or at zero. A second list shows OpenCart codes the till does not have, and a lookup finds the OpenCart size for any till code. Counts cover negative, over-committed and uncategorised items, with layaway kept out of free stock. Each list downloads as a spreadsheet.
Outcomes
Stock that OpenCart cannot sell is listed by size.
OpenCart codes the till does not know are listed before they break fulfilment.
Negative and over-committed quantities are counted without a hand-written query.
Layaway no longer shows as free stock.
Simplified mockup
Interactive preview with sample data. Nothing is sent to a server.
Sizes the website cannot sell
Mismatched sizes
11
Till units
34
On hand in the shop
Layaway held back
10
Not free stock
Free, unsellable online
24
Till minus layaway
Ready to compare this morning’s extract
4 missing3 disabled4 zero online10 layaway excluded
In stock on the till
Style
Till
Web
Layaway
Free
Reason
Soft apron loaferUK 6 · APL-BLK-060
3
none
1
2
Missing
Soft apron loaferUK 7 · APL-BLK-070
2
0
0
2
Zero online
Waxed country bootUK 8 · WXB-BRN-080
4
off
2
2
Disabled
Low court shoeUK 4 · CRT-BLK-040
1
none
0
1
Missing
Low court shoeUK 5 · CRT-BLK-050
5
0
1
4
Zero online
Suede five-eyeUK 9 · SDE-TAN-090
2
off
0
2
Disabled
Canvas plimsollUK 7 · CVS-WHT-070
6
none
3
3
Missing
Elastic-side bootUK 8 · ELS-BRN-080
3
0
0
3
Zero online
Brogue oxfordUK 10 · BRG-BRN-100
2
off
1
1
Disabled
Bar shoeUK 3 · BAR-BLK-030
4
none
0
4
Missing
Fisherman sandalUK 6 · FSH-TAN-060
2
0
2
0
Zero online
Quantity exceptions
Negative
0
Over-committed
0
Uncategorised
0
Exclusion list applied
Carrier bag, gift box and heel tip stay off this count until you show the exclusion list.
Description
Kind
Qty
Note
Canvas plimsollUK 11 · CVS-WHT-110
Negative
−1
Return posted twice
Elastic-side bootUK 6 · ELS-BRN-060
Negative
−2
Sale after a stock take
Suede five-eyeUK 4 · SDE-TAN-040
Negative
−1
Transfer not received
Low court shoeUK 7 · CRT-BLK-070
Negative
−3
Web order oversold
Waxed country bootUK 9 · WXB-BRN-090
Over-committed
1
3 reserved, 1 free
Brogue oxfordUK 7 · BRG-BRN-070
Over-committed
0
2 reserved, none free
House muleUK 5 · MUL-NAT-050
Uncategorised
2
No web category
House muleUK 6 · MUL-NAT-060
Uncategorised
3
No web category
Slip-on clogUK 8 · CLG-GRY-080
Uncategorised
4
No web category
Slip-on clogUK 9 · CLG-GRY-090
Uncategorised
1
No web category
Garden clogUK 4 · GDN-GRN-040
Uncategorised
6
No web category
Garden clogUK 7 · GDN-GRN-070
Uncategorised
2
No web category
Carrier bag
Excluded
40
Not a size
Gift box
Excluded
18
Not a size
Heel tip
Excluded
12
Repair part
Web codes absent from the till
These sizes can be ordered online and have nothing to fulfil them.
Web code
Style
Size
Web qty
Status
WEB-18442
Soft apron loafer
UK 13
1
No till item
WEB-19003
Low court shoe
UK 2
2
No till item
WEB-17661
Canvas plimsoll
UK 1
3
Enabled
WEB-20114
Elastic-side boot
UK 12
1
No till item
WEB-18890
Brogue oxford
UK 11
2
Enabled
Till code lookup
Resolve one code
Suede five-eye Enabled
SDE-TAN-080
UK 8 · tan · web size row present
Till stock
2
Layaway
0
Free
2
Waxed country boot Disabled
WXB-BRN-080
UK 8 · brown · web row exists but is switched off
Till stock
4
Layaway
2
Free
2
Unknown code Not on the till
ZZZ-000-000 does not match a till item or a website size. Check the orphan list before creating one.
How it works
Load till items with quantity on hand, and OpenCart size rows with their codes.
Flag sizes in stock on the till that are missing, switched off or zero on OpenCart.
Flag OpenCart codes that do not exist on the till.
Count negative, over-committed and uncategorised till items, leaving out descriptions on the exclusion list.
Split layaway or reserved units out of free stock and download the table shown.
Pipeline
flowchart LR
A[RMS qty] --> C[Compare]
B[OpenCart sizes] --> C
C --> D[Mismatch table]
B --> E[Orphan codes]
A --> F[Exceptions]
A --> G[Layaway split]