About Services Tools Blog Contact us

Stepped Sale Pricing for In-Stock Sizes

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
StyleColourPairsTillSale
Wrenfield Harbour LoaferCognac14£129–
Calderwell Ridge ChelseaBlack9£149£119
Larch & Co Marsh BrogueOak22£175–
Sable Row Quay SandalSand7£89–

Wrenfield Harbour Loafer

Cognac · till £129 · nearest pound
Discount ladder
One step fills every size. Nothing is written until Save.
Size run
SizeLookupTillSaleOffFlag
Choose a step, then save

Till log

Size runs stepped this week
WhenStyleStepSizesByResult
9 Oct 2026Ridge Chelsea20%6Priya ShahSaved
8 Oct 2026Marsh Brogue30%6Rowan HaleSaved
7 Oct 2026Court Pump50%0Priya ShahTill offline
4 Oct 2026Quay Sandal10%4Saffi CroftSaved

How it works

  1. Staff filter the OpenCart catalogue to products that are in stock.
  2. Each size row shows the current Microsoft Dynamics RMS price.
  3. A step control applies the next fixed discount to the selected sizes.
  4. Set the sale start, sale end and sale flag on the same rows.
  5. Save to write those fields back to Microsoft Dynamics RMS and confirm the result.
  6. 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]