About Services Tools Blog Contact us

Till and Website Stock Reconciliation

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
In stock on the till
StyleTillWebLayawayFreeReason
Soft apron loaferUK 6 · APL-BLK-0603none12Missing
Soft apron loaferUK 7 · APL-BLK-0702002Zero online
Waxed country bootUK 8 · WXB-BRN-0804off22Disabled
Low court shoeUK 4 · CRT-BLK-0401none01Missing
Low court shoeUK 5 · CRT-BLK-0505014Zero online
Suede five-eyeUK 9 · SDE-TAN-0902off02Disabled
Canvas plimsollUK 7 · CVS-WHT-0706none33Missing
Elastic-side bootUK 8 · ELS-BRN-0803003Zero online
Brogue oxfordUK 10 · BRG-BRN-1002off11Disabled
Bar shoeUK 3 · BAR-BLK-0304none04Missing
Fisherman sandalUK 6 · FSH-TAN-0602020Zero 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.

DescriptionKindQtyNote
Canvas plimsollUK 11 · CVS-WHT-110Negative−1Return posted twice
Elastic-side bootUK 6 · ELS-BRN-060Negative−2Sale after a stock take
Suede five-eyeUK 4 · SDE-TAN-040Negative−1Transfer not received
Low court shoeUK 7 · CRT-BLK-070Negative−3Web order oversold
Waxed country bootUK 9 · WXB-BRN-090Over-committed13 reserved, 1 free
Brogue oxfordUK 7 · BRG-BRN-070Over-committed02 reserved, none free
House muleUK 5 · MUL-NAT-050Uncategorised2No web category
House muleUK 6 · MUL-NAT-060Uncategorised3No web category
Slip-on clogUK 8 · CLG-GRY-080Uncategorised4No web category
Slip-on clogUK 9 · CLG-GRY-090Uncategorised1No web category
Garden clogUK 4 · GDN-GRN-040Uncategorised6No web category
Garden clogUK 7 · GDN-GRN-070Uncategorised2No web category

Web codes absent from the till

These sizes can be ordered online and have nothing to fulfil them.

Web codeStyleSizeWeb qtyStatus
WEB-18442Soft apron loaferUK 131No till item
WEB-19003Low court shoeUK 22No till item
WEB-17661Canvas plimsollUK 13Enabled
WEB-20114Elastic-side bootUK 121No till item
WEB-18890Brogue oxfordUK 112Enabled

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

How it works

  1. Load till items with quantity on hand, and OpenCart size rows with their codes.
  2. Flag sizes in stock on the till that are missing, switched off or zero on OpenCart.
  3. Flag OpenCart codes that do not exist on the till.
  4. Count negative, over-committed and uncategorised till items, leaving out descriptions on the exclusion list.
  5. 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]