About Services Tools Blog Contact us

Cross-Sell and Upsell Linker

Staff choose associated styles, upsells and what goes with a shoe, and the pairs are saved to the OpenCart shop in their own list.

  • E-commerce Integrations
  • Footwear retail
  • Dashboard feature
  • Productised
  • Hybrid
  • 2026

The problem

Related shoes were chosen by hand on each product page, and there was nowhere to review the links before they went live. Products linked before the new list existed never showed those pairs on the shop. Staff only found out by browsing the pages.

What it does

The linker lists candidate styles. A person ticks associated links, upsells and cross-sells, and the tool saves them to a list of their own in OpenCart, leaving the merchandiser's related list as it is. Adding a garment for a worn shot can add that cross-sell. A catch-up job fills the new list for colourways linked before it existed, and a second run changes nothing.

Outcomes

  • The product page shows the published set and not a hand-typed list.
  • Links stay tied to the style code, so a later import does not drop them.
  • A garment added for a worn shot can become a cross-sell.
  • Products linked before the new list existed are filled in with one run.

Simplified mockup

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

Link from CT-441

Hartley Court Chelsea, black Shop linked
£129.00 · colourway is on the shop
Candidates 2 associated, 1 upsell ticked
UseRoleStylePrice
Associated Derby, black CT-442 £139.00
Associated Loafer, tan CT-510 £119.00
Not linked Trainer, grey CT-220 £89.00
Not linked Sandal, sand CT-118 £79.00
Upsell Northfield boot NF-090 £149.00
Not linked Court shoe, navy QC-775 £109.00
Suggested Ankle socks ML-008 £12.00
Worn shot Waxed field coat QM-014 £180.00
Review before publish

Two associated styles and one upsell. The merchandiser related list is left as it is, so the theme can choose which list to read.

The coat was added for a worn shot. It is not in this publish. The mirror writes it later.

Publish
Colourway already has a shop link

Product page

Publish the ticked set on the linker to preview the product page.

Mirror older links

Scanned
0
Ready
0
No shop link
0
Skipped
Dry-run Not written yet
StylePairSlotState
CT-441Waxed field coatYou may also likeReady
CT-442Ankle socksCross-sellReady
CT-510Loafer, oakAssociatedReady
NF-090Boot treesCross-sellReady

8 more ready in this run. 6 colourways have no shop link and stay skipped.

Apply
Dry-run is ready

How it works

  1. Open a style and list candidate associated products.
  2. Tick associated links, an upsell or a cross-sell, and review the group before publishing.
  3. Save the pairs to OpenCart's own list once the colourway has an OpenCart link.
  4. Leave the merchandiser's related list unchanged.
  5. Test the catch-up first, count colourways with no OpenCart link and skip them.
  6. Run the catch-up for real, so a second run leaves the same entries.

Pipeline

flowchart LR
  A["Style"] --> B["Candidates"]
  B --> C["Choose pairs"]
  C --> D["Review"]
  D --> E["OpenCart table"]
  F["Older links"] --> E