About Services Tools Blog Contact us

Retail Catalogue and Stock Sync

A scheduled job copies products, size names, stock movements and order notes between the till system and OpenCart.

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

The problem

Web stock drifted from the till system, and the till's size names did not match the size list on OpenCart. Staff edited the size translations by hand. When a quantity looked wrong, someone had to check one brand at a time.

What it does

On a schedule the job reads the till system and writes products, sizes and stock movements into OpenCart. A match table for sizes and departments holds the translations that used to be edited by hand. Transaction notes are copied so a web order can be traced in the till system. The log shows whether the last sync finished.

Outcomes

  • Web stock follows the tills on a schedule.
  • Size names match the website size list.
  • A brand-level check shows a disagreement without a full manual export.
  • Order notes travel with the stock movement.

Simplified mockup

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

Till extract

8 styles Not yet mapped
Styles
0
Till units
0
Brands
0
Awkward sizes
0
Pulled from the till at 06:40 Size labels are still the retail wording
StyleBrandTill sizeQty
Harbour Court loaferCalder & WrenUK 8 / EU 4214
Marsh Lane bootDunlin8 1/26
Chapel Walk trainerHearthsideM103
River Path sandalCalder & Wren42EUR11
Mill Court brogueOakmereMens 98
Station Road derbyDunlin10.5 UK2
Orchard Gate chelseaHearthside7H5
Quarry Hill runnerOakmereG4

Run sync

This run
  1. Read products and sizes
  2. Apply the size map
  3. Write stock quantities
  4. Copy the order note
  5. Flag a disagreement
  6. Record the run
Ready when you are

Brand stock check

Till units by brand
Where the till and the website disagree 1 style
StyleBrandTillWebGap
Harbour Court loaferCalder & Wren14140Matched
Marsh Lane bootDunlin660Matched
Chapel Walk trainerHearthside39+6Disagree
River Path sandalCalder & Wren11110Matched
Mill Court brogueOakmere880Matched
Station Road derbyDunlin220Matched
Orchard Gate chelseaHearthside550Matched
Quarry Hill runnerOakmere440Matched

How it works

  1. Read products, sizes and stock movements from the till system.
  2. Apply the size and department map so size names land on the web size list.
  3. Write stock quantities to OpenCart.
  4. Copy transaction notes so a web order can be traced in the till system.
  5. Flag a style where the till quantity and the OpenCart quantity disagree.
  6. Record whether the run finished.

Pipeline

flowchart LR
  A["Till extract"] --> B["Size map"]
  B --> C["Web products"]
  A --> D["Stock figures"]
  D --> C
  C --> E["Disagree flag"]
  C --> F["Run log"]