About Services Tools Blog Contact us

Storefront Size Conversion

Converts a raw size from Microsoft Dynamics Retail Management System into the size, filter label and sort order the online shop shows, with a place to pin awkward brands.

  • Size & Fit Tools
  • Footwear retail
  • Tool
  • Productised
  • Hybrid
  • 2026

The problem

Microsoft Dynamics Retail Management System stores sizes as the stock system writes them, including three-digit children's sizes and European sizes, which the shop cannot show as they are. Children's sizes landed on adult filters and a half size had no mapping. A few brands that break the usual rules were fixed by hand.

What it does

Conversion rules turn a raw size into the shop size, the filter label and the sort order, using department, brand and size-range tables. Staff can pin a size group for an awkward brand or category, so the department guess is not trusted. Older conversion rules and their special cases, such as an infant marker inside a children's size, load into the same tables. Automatic children's conversion is not finished yet. The live rules and the exceptions screen are in place.

Outcomes

  • Shoppers see a shop size and no raw stock-system code.
  • Children's sizes stop landing on the adult filter once the rule is pinned.
  • Awkward brands are set as exceptions on a screen and are not fixed by hand in the code.
  • The filter label and sort order stay with the converted size.

Simplified mockup

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

Rewrite a till size

Till context
Rewrite
Ready for c135
Children’s size run c-prefix, divide by 10
TillShop sizeFilterSort
c120UK 12Children’s1120
c130UK 13Children’s1130
c135UK 13.5Children’s1035
42.5UnmappedHeld999999
Sort 1035 is 1135 minus 100 because the product name carries an infant marker. The adult filter is not used. EU 42.5 has no row, so it stays on the to-do list.

Pinned size groups

Exception screen A pin beats the department heuristic
BrandSize groupPreprocessWhy
Meadow Last Children None Till omits the c prefix
New pin

075 is a three-digit till code. Without a pin it stays raw. With this pin it becomes a ladies UK size.

Same raw size, before the pin
No rule
Shop size075
FilterNone
Sort999999
Pin Field & Last to rewrite 075

Held: raw 135 with no department and no pin. Automatic children’s conversion is not finished, so that code is not guessed.

Option list

Tonight’s sync
Three size options Before is the till. After is the shop.
ProductTillBeforeAfter
Infant strap shoe c135 Adult filter Awaiting rewrite
Oxford shoe 075 Raw 075 Awaiting pin
Court pump 42.5 Guessed adult Awaiting rewrite
Shopper’s size buttons
Before, raw till codes
c135 075 42.5
After rewrite
Awaiting Awaiting Awaiting

The children’s option leaves the adult filter. The half size is held. The three-digit brand follows the pin.

How it works

  1. Read the raw size with its department and brand.
  2. Look up the size-range table for that context.
  3. Apply an exception when a brand or category is pinned to a size group.
  4. Apply special cases such as an infant marker inside a children's size.
  5. Output the shop size, the filter label and the sort order.
  6. Put unmapped half sizes and unfinished children's rules on a to-do list and leave them unguessed.

Pipeline

flowchart LR
  A[RawTillSize] --> B[DepartmentAndBrand]
  B --> C[SizeRunTable]
  D[PinnedException] --> C
  C --> E[StorefrontSize]
  E --> F[FilterLabel]
  E --> G[SortOrder]