About Services Tools Blog Contact us

Till to Web Product Matcher

Matches each website style to its Microsoft Dynamics Retail Management System till item using the box barcode, colour and a brand code list, then copies details across. Unsafe matches go on an exceptions list.

  • Product Enrichment & Import
  • Footwear retail
  • Scheduled worker
  • Productised
  • Hybrid
  • 2026

The problem

Styles sat in Microsoft Dynamics Retail Management System and never appeared online. Some sizes existed on OpenCart with no till record, and some colours or genders were attached to the wrong item. Because staff repaired the link by hand, the title, colour, material, fastening and size run drifted apart.

What it does

The matcher links each OpenCart style to the till item using the box barcode, the colour and a brand code list. For safe matches it can take updated details from the till. Anything ambiguous, such as a wrong gender or a size with no till record, goes on an exceptions list and is not forced. Copying updates automatically is only partly in place. Daily logs exist, but it has not been switched on.

Outcomes

  • Fewer styles sit on the till with no OpenCart page, or on OpenCart with no till record.
  • Wrong colour or gender matches are listed and not published.
  • Linked styles can take title, material, fastening and size updates.
  • Each run leaves a log of what was safe to change.

Simplified mockup

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

Till and web

Queue push is partial. The nightly log is kept. The live push is not switched on, so this screen only shows what a run would link.
Web styles
  • 1Harbour Loafer Cognac · Women · WF 0104
  • 2Ridge Chelsea Black · Men · CW 0203
  • 3Marsh Brogue Oak · Men · LC 0302
  • 4Quay Sandal Sand · Women · SR 0401
  • 5Pebble Chukka Taupe · Unisex · QL 0500
  • 6Penny Navy · Women · GW 0708
  • 7Court Pump Burgundy · UK 7 · FR 0609
Till items
  • 1Harbour Loafer Cognac · Women · 0104
  • 2Ridge Chelsea Black · Men · 0203
  • 3Marsh Brogue Oak · Men · 0302
  • 4Quay Sandal Sand · Women · 0401
  • 5Pebble Chukka Taupe · 0500
  • 6Penny Navy · Men · 0708
  • 8Moor Boot Brown · Men · 0807
Match
Eight rows waiting
Resync
Runs after a safe link

Exception list

StyleWhat disagreedReason
Greywell Penny, navy Web says Women, till says Men Wrong gender
Fenrow Court Pump, UK 7 No till item for box 0609 No till row
Moor Boot, brown No web style for box 0807 No web page
Brand code map
WF Wrenfield CW Calderwell LC Larch SR Sable QL Quayline GW Greywell FR Fenrow

Match order is box barcode, then colour, then this code. A code match is not enough when gender disagrees.

Run log

Safe links this week
NightLinkedHeldAttributesPush
9 Oct 202615315Log only
8 Oct 2026949Log only
7 Oct 20261120Push off
6 Oct 2026464Log only

How it works

  1. Read the till item file, the OpenCart catalogue and the brand code lists.
  2. Match on box barcode, then colour, then the brand-specific code.
  3. Put unsafe matches on an exceptions list.
  4. Apply the waiting detail updates from the till to matched rows.
  5. Write a run log and a stock snapshot of what changed.
  6. Keep exceptions for any other shop on the same list instead of a separate spreadsheet.

Pipeline

flowchart LR
  A[TillItems] --> B[BarcodeMatch]
  C[WebStyles] --> B
  B --> D[SafeLink]
  B --> E[Exceptions]
  D --> F[AttributeUpdate]
  F --> G[RunLog]