About Services Tools Blog Contact us

Materials Stock and Order Console

Staff search stock by name, SKU, barcode or camera QR code, open sales orders, and see which purchase orders are overdue or partly received.

  • Stock & Inventory
  • Specialist sheet materials
  • Dashboard feature
  • Productised
  • Hybrid
  • 2026

The problem

Looking up a sheet or part means stepping through Brightpearl, which is slow on the shop floor. Customer service checks on an order are the same slow search. Buyers cannot see in one place which inbound deliveries are late or short.

What it does

A floor console searches a saved copy of the Brightpearl product list and shows stock on hand. Staff can type a barcode or read a QR code with the webcam. Sales orders open with the customer name attached. Open purchase orders show ordered, received and outstanding quantities, with overdue and partial flags.

Outcomes

  • Floor staff see stock without opening the Brightpearl back office.
  • A QR code or barcode opens the product card.
  • Customer service opens an order with the customer name attached.
  • Late and short purchase deliveries show in one list.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Sheet stock Synced 6 minutes ago

20 lines in cache Amber means 3 or fewer
SheetSKUOn hand
Birch plywood 18 mm 2440 × 12202440-1220 990244012201814
Birch plywood 12 mm 2440 × 1220PLY-BIR-12 990244012201222
Birch plywood 9 mm 2440 × 1220PLY-BIR-09 99024401220098
Moisture-resistant MDF 18 mmMDF-MR-18 990183018001831
Moisture-resistant MDF 12 mmMDF-MR-126
Standard MDF 18 mmMDF-ST-18 990183018001144
Hardboard 3.2 mmHBD-32 990032000003257
OSB 3, 18 mmOSB3-18 990183018001919
OSB 3, 11 mmOSB3-1111
Acrylic clear 5 mm 3050 × 2050ACR-CL-5 99030502050054
Acrylic opal 3 mmACR-OP-39
Polycarbonate clear 6 mmPC-CL-6 99030502050063
Foamed PVC white 10 mmPVC-WH-1016
Foamed PVC black 5 mmPVC-BK-57
Aluminium composite white 3 mmACP-WH-3 990305015000312
Aluminium composite anthracite 3 mmACP-AN-35
Laminate, oakLAM-OAK 990305013000828
Laminate, walnutLAM-WAL2
Compact grade black 12 mmCMP-BK-12 99030501300121
Phenolic plywood 18 mmPLY-PHE-189

Shelf code

Camera
Sample shelf code for SKU 2440-1220
Read

The sample code is already in frame. A typed barcode uses the same cache.

Waiting for a frame
Sample code in frame.

Sales orders

Open book Hale returns two
OrderCustomerLinesUpdatedStatus
SO-4418Hale Joinery62 MarOpen
SO-4402Hale Joinery218 FebPicking
SO-4390Penrose Fit-out41 MarDespatched
SO-4388Croft Studios127 FebOpen
SO-4371Whitby Schools821 FebPart shipped
SO-4366Alden Kitchens314 FebOpen

Purchase orders

Open lines
7
Overdue
2
Partial
1
Inbound Ordered, received, still outstanding
POLineOrderedInLeftFlag
PO-1904Birch plywood 18 mm40040Overdue 28 Feb
PO-1908Acrylic clear 5 mm12012Overdue 4 Mar
PO-1911OSB 3, 18 mm20128Partial
PO-1915Foamed PVC white24024Open 18 Mar
PO-1916Compact grade black606Open 20 Mar
PO-1919Laminate, oak15015Open 25 Mar
PO-1922Polycarbonate 6 mm808Open 1 Apr

How it works

  1. Copy the product list from Brightpearl and search it by SKU, name or barcode.
  2. On the product screen, scan a QR code with the camera or type a code.
  3. Show stock on hand and how recent the copy is.
  4. Search sales orders and open one with the customer name.
  5. List open purchase orders with outstanding quantity and overdue or partial flags.

Pipeline

flowchart LR
  A[Cache sync] --> B[Product search]
  C[QR or barcode] --> B
  B --> D[Stock card]
  E[Sales orders] --> F[Order detail]
  G[Purchase orders] --> H[Overdue flags]