About Services Tools Blog Contact us

End-of-line and Last-chance Flags

Lists styles whose size run has broken and flags final units as last chance, so broken runs are not left at full price.

  • Stock & Inventory
  • Footwear retail
  • Dashboard feature
  • Productised
  • Hybrid
  • 2026

The problem

Broken size runs sit at full price until someone notices the other sizes have gone. Final pairs should be promoted as last chance, but that flag lived only as a category in the notes of the Microsoft Dynamics Retail Management System. Finding both meant walking through the stock report by hand.

What it does

One view lists products whose size run is down to the last few units in one or two sizes and that are not already on sale. A second action finds in-stock products down to their final units and switches on a last-chance category, stored in the notes of the Microsoft Dynamics Retail Management System.

Outcomes

  • Broken size runs are listed before they sit at full price.
  • Styles already on sale are left out of the end-of-line list.
  • Final units get a last-chance flag on the Microsoft Dynamics Retail Management System item.

Simplified mockup

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

Broken size runs

Broken runs
8
One or two sizes left
Pairs still in
15
Full price
Excluded
3
Already on sale
Harbour courtNot on sale

Black leather · child · £42 · 3 left

10111213 21 12
Elm buckleNot on sale

Navy leather · child · £38 · 1 left

891011 11213
Ridge wellyNot on sale

Green rubber · child · £28 · 3 left

101112 2131 12
Marsh loaferNot on sale

Tan suede · adult · £69 · 1 left

3456 178
Quay trainerNot on sale

Grey mesh · child · £36 · 2 left

101112 21312
Field brogueNot on sale

Brown leather · adult · £95 · 2 left

6789 110 111
Orchard sandalNot on sale

Red leather · child · £24 · 1 left

89 110111213
Canal deckNot on sale

Navy canvas · adult · £78 · 2 left

5678 2910

3 styles already on sale are excluded from this list: Willow trainer, Cove oxford and Heather ballet.

Final units

Five styles are down to one or two pairs. A toggle writes Last chance into the till notes. The button flags every style that has a single pair left.

To review
Pebble slip-on
UK 6 · 1 pair · £48
Notes: empty
Linen plimsoll
UK 13 · 1 pair · £22
Notes: empty
Ink elastic
UK 8 · 2 pairs · £75
Notes: empty
Bramble mule
UK 5 · 1 pair · £39
Notes: empty
Frost boot
UK 7 · 2 pairs · £110
Notes: empty
Flagged

None yet. Notes stay empty until a toggle or the 1-pair write.

Till notes preview
No flags written yet.

Already on sale

These three would have qualified as end of line, and they are absent from that list because the till sale flag is already on.

Willow trainerOn sale

Child · now £32, was £40 · 1 left

101112 11312
Cove oxfordOn sale

Adult · now £70, was £98 · 2 left

67 18 191011
Heather balletOn sale

Child · now £18, was £26 · 2 left

910 21112131

How it works

  1. Read shop quantities by size and the sale flag from the Microsoft Dynamics Retail Management System.
  2. Keep styles that are not on sale and whose remaining sizes fall below the cut-off for a broken run.
  3. Show those styles as cards the buyer can mark.
  4. Separately, find in-stock styles at or under the final-unit threshold.
  5. Set or clear the last-chance flag in the notes of the Microsoft Dynamics Retail Management System.

Pipeline

flowchart LR
  A[Size quantities] --> B[Run check]
  C[Sale flag] --> B
  B --> D[End-of-line cards]
  A --> E[Final units]
  E --> F[Last-chance flag]