About Services Tools Blog Contact us

Sale and Brand Range Sync

Matches till departments to OpenCart categories, then sends a sale or one brand range to the website with a sort rule and a list of styles that could not be matched.

  • E-commerce Integrations
  • Footwear retail
  • Scheduled worker
  • Productised
  • Hybrid
  • 2026

The problem

The till's category tree and the shop's category tree share no reference numbers, so someone filed each new colourway by hand. Every sale or brand drop meant matching categories again and sending products across. If sale lines landed in the wrong place, someone fixed the order by hand.

What it does

Each till department stores one or more OpenCart categories, and the older category list can fill them in where the names still match. A run sends the sale or one brand range, a sort rule puts sale lines at the top or the bottom, and styles that could not be matched are listed. The matching screen is in place. A full hands-off sale launch is not, so someone checks each run.

Outcomes

  • New colourways land in the mapped OpenCart categories.
  • A sale or one brand range can be sent without remapping the whole tree.
  • Sale lines sit at the top or the bottom by rule.
  • Unmatched styles are listed before the sale is launched.

Simplified mockup

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

Category map

Boots · 2 shop paths
Till tree
Footwear
Sale
Shop tree
Footwear
Boots
Trainers
Sandals
Sale
Paths saved on the selected node

Boots files to Footwear / Boots / Chelsea and Sale / Boots

Tick two shop categories and the path names appear on the till node. Sandals is still empty, so new colourways there would be filed by hand.

Push the sale

Checked run
Map is saved. The sale has not been pushed.

One brand range

Scope before the run
BrandDepartmentsThis run
HearthsideBoots, TrainersIncluded
DunlinBootsLeft as is
OakmereTrainersLeft as is
Calder & WrenSandalsLeft as is
Other departments stay untouched

How it works

  1. Load the till's category tree and the OpenCart category tree.
  2. Save one or more OpenCart categories against each till department.
  3. Match departments whose names agree with the older list, and show the matches before saving.
  4. Send a sale or one brand range to the website.
  5. Place sale lines above or below full-price lines.
  6. List styles that could not be matched so they can be filed before launch.

Pipeline

flowchart LR
  A["Till tree"] --> B["Category map"]
  C["OpenCart"] --> B
  B --> D["Push range"]
  D --> E["Sort rule"]
  D --> F["Unmapped list"]