Staff filter in-stock products and step each size through a fixed set of discounts. Sale price, dates and a sale flag are saved back to Microsoft Dynamics RMS.
Pricing & Promotions
Footwear retail
Dashboard feature
Productised
Hybrid
2026
The problem
Sale prices live on Microsoft Dynamics RMS, while staff work from the OpenCart catalogue. Percentage edits were typed size by size, so a six-size style meant six chances to mistype the price or the end date. There was also no warning when Microsoft Dynamics RMS could not be reached.
What it does
The screen lists in-stock products and lets staff step every size through a fixed discount ladder. One save writes the sale price, the dates and the sale flag back to Microsoft Dynamics RMS. A warning shows when Microsoft Dynamics RMS is unreachable, so nobody mistakes a failed save for a live price.
Outcomes
A whole size run is reduced in one step, with no typing into each box.
Sale dates and the sale flag are saved with the price.
An unreachable Microsoft Dynamics RMS connection shows up before staff leave the page.
Simplified mockup
Interactive preview with sample data. Nothing is sent to a server.
In-stock shop styles
In stock
4
Styles with pairs
Already on sale
1
Ridge Chelsea at 20%
Held, no pairs
2
Hidden until All
Shop catalogue
Style
Colour
Pairs
Till
Sale
Wrenfield Harbour Loafer
Cognac
14
£129
–
Calderwell Ridge Chelsea
Black
9
£149
£119
Larch & Co Marsh Brogue
Oak
22
£175
–
Sable Row Quay Sandal
Sand
7
£89
–
Fenrow Court Pump Locked
Burgundy
0
£110
–
Greywell Penny Locked
Navy
0
£135
–
Wrenfield Harbour Loafer
Cognac · till £129 · nearest pound
Discount ladder
One step fills every size. Nothing is written until Save.
Size run
Size
Lookup
Till
Sale
Off
Flag
Saved
6 sizes of Harbour Loafer at £103
(20%). Sale flag on, 10 Oct 2026 to 2 Nov 2026.
Till offline
The till could not be reached. Sale prices, dates and the sale flag were left unchanged.
Choose a step, then save
Till log
Size runs stepped this week
When
Style
Step
Sizes
By
Result
9 Oct 2026
Ridge Chelsea
20%
6
Priya Shah
Saved
8 Oct 2026
Marsh Brogue
30%
6
Rowan Hale
Saved
7 Oct 2026
Court Pump
50%
0
Priya Shah
Till offline
4 Oct 2026
Quay Sandal
10%
4
Saffi Croft
Saved
How it works
Staff filter the OpenCart catalogue to products that are in stock.
Each size row shows the current Microsoft Dynamics RMS price.
A step control applies the next fixed discount to the selected sizes.
Set the sale start, sale end and sale flag on the same rows.
Save to write those fields back to Microsoft Dynamics RMS and confirm the result.
If Microsoft Dynamics RMS cannot be reached, warn and leave the price unchanged.
Pipeline
flowchart LR
A[InStockFilter] --> B[SizeRows]
B --> C[DiscountStep]
C --> D[DatesAndFlag]
D --> E[RMS save]
E --> F[ConfirmOrWarn]