About Services Tools Blog Contact us

Stock Import Problem List

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
LineStyleFaultDetail
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

On the website, missing at the till

6 exceptions open, 0 cleared. 4 styles can still be ordered online.

Lookup codes that blocked the match
StyleWebLookupWhy 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

How it works

  1. Run the stock import and collect the lines that failed.
  2. Flag product categories that are not in the allowed list.
  3. Flag quantities that are negative or still reserved.
  4. Compare website stock with till stock for the linked styles.
  5. List website-only styles beside the style codes that blocked them.
  6. 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]