About Services Tools Blog Contact us

Size Guide Product Matching

Picks in-stock products that fit the wording of a size guide and saves the results ahead of time, so a page view never waits for the match.

  • Semantic Search & RAG
  • Footwear retail
  • Pipeline
  • Product
  • Hybrid
  • 2026

The problem

Matching on keywords put the wrong shoes and garments beside a size article. Each size page also asks for products in a slightly different way. Working that out while the visitor waited made the page slow.

What it does

Product descriptions are prepared once and stored. A short code on each page picks the best matches for the guide's wording and reuses earlier results where it can. An overnight job covers every code in use, each gender and category pair, and each currency the site serves. Only in-stock products with a working link are included unless a staff member asks for every product, and the live page reads the saved results.

Outcomes

  • A size article shows products that fit its wording, and shared keywords alone do not qualify a product.
  • A code that has been seen before is served from saved results.
  • Out-of-stock products stay out of the strip unless staff include them.
  • The saved results are refreshed by a job that can be run again, with no manual export.

Simplified mockup

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

Size guide

Footwear · women · trainers

Leave a thumb’s width at the toe

A trainer should hold the heel and still leave room at the longest toe. If the ball of the foot feels pinched, choose the wide fit rather than the next length up. Mesh uppers suit a broader forefoot. Stiff fashion soles rank lower against this wording.

shortcode q="women trainers" cid="trainers"

Cache hit 11 ms · GBP The page read the rank cache. It did not call the model.

In stock, ranked to this guide

Pace Knit

NQ-1044 · wide

0.91 · £89 · In stock

Glide Mesh

NQ-1182 · standard

0.86 · £74 · In stock

Court Light

NQ-1210 · wide

0.81 · £62 · In stock

Warm the rank cache

Next uncached pair

Query children boots

Category boots

Currencies GBP, EUR, USD

Cold page 836 ms if a shopper opens it now

186 guide and converter pairs are already warm. This one is not.

Job
Ready to warm children boots
Before this run
QueryCurrencyLatencySource
women trainersGBP11 mscache
men walking shoesGBP14 mscache
children bootsGBP–missing

Product vectors

Embedded
0
In stock, linkable
0
Excluded
0
Packed vectors by department
Sample rows
SKUTitleStockVectorIn the strip
NQ-1044Pace Knit42768-d packedyes
NQ-1182Glide Mesh17768-d packedyes
NQ-2201Puddle Boot63768-d packedyes
NQ-3310Fell Boot8768-d packedyes

How it works

  1. Prepare and store the text of in-stock products for matching.
  2. Collect each distinct search and category pair from the guides and the converter forms.
  3. Match each pair in the currencies the site serves.
  4. Save the prepared search and the ranked matches.
  5. Let a page view read the saved matches.
  6. Rerun the job safely when products or codes change.

Pipeline

flowchart LR
  Products[In-stock products] --> Embed[Embed and normalise]
  Guides[Guide shortcodes] --> Warm[Warm the rank cache]
  Embed --> Warm
  Warm --> Cache[Rank cache]
  View[Page view] --> Cache
  Cache --> Strip[Product strip]