About Services Tools Blog Contact us

Product Terms and Filter Map

A controlled list of materials and fit terms, with maps from supplier wording and till departments to website categories, filters, colours and shipping weights.

  • Product Enrichment & Import
  • Footwear retail
  • Tool
  • Productised
  • Hybrid
  • 2026

The problem

Each brand file used its own words for features and sizes, and the till used another set of departments, colour names and shorthand prefixes. The same material was typed differently on each style, so the website filters disagreed. Years of attributes also sat in an old export that the new sync had nowhere to put.

What it does

A maintained list of uppers, linings, soles and fit notes keeps website filters consistent. Maps translate supplier wording, shop categories and till codes into website categories, colours and a default shipping weight. Older attribute exports load into the same list of fields, with each one marked as text, a choice or a tick box, and variants are tied back to their main product.

Outcomes

  • Feature edits such as a waterproof range refill from the saved map.
  • Website filters follow shop categories and the till's vocabulary.
  • Colour names and shipping weights are no longer retyped for each style.
  • Older attributes land in a field list the sync can use.

Simplified mockup

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

House materials and fit

House terms
0
Groups
0
Open duplicates
0
water proof / waterproof
Latest supplier file · two spellings of one term
water proof → waterproof Two spellings
Ready to merge
  1. Read both spellings
  2. Collapse to Waterproof
  3. Save the house term
Upper
LeatherSuedeNubuckCanvasTextileMeshSyntheticPatent
Lining
LeatherTextileFleeceWoolSheepskinMesh
Sole
RubberEVAPULeatherCrepe
Fit
StandardWideExtra wideNarrowWide calfExtra wide calf

Supplier words to house filters

Saved map for the autumn file. The wet-weather edit refills Waterproof or Showerproof on the five styles that used a weather phrase.

Phrase → house filter
WP membrane
→
Waterproof
water proof
→
Waterproof
showerproof
→
Showerproof
nubuck
→
Nubuck
wide fit
→
Wide
x-wide calf
→
Extra wide calf
fleece lining
→
Fleece
crepe sole
→
Crepe
Feature edit · wet weather

WP membrane and water proof become Waterproof. Showerproof stays its own filter. Five styles are waiting.

  • Calderwell Ridge, chestnut
  • Fenrow Harbour, navy
  • Quayline Moor, black
  • Greywell Dale, olive
  • Larch & Co Fell, tan
Map loaded, not yet applied
  1. Open the wet-weather edit
  2. Match weather phrases
  3. Write Waterproof on five styles

Till departments to the web

Five till lines waiting
This morning’s till extract
CodePrefixColour phraseWeb category, colour, weight
wmncdwalmond Awaiting
menfnranthracite Awaiting
chdqlnaqua patent Awaiting
bed–– Awaiting
zzxzzzancient moss Awaiting
Women’s default
800 g
Men’s default
1,200 g
Children’s
600 g
Footbeds
150 g

Legacy attribute export

attributes_export.tsv40 columns
ColumnExampleStored id
upperLeather4418-02 child
liningTextile4418-02 child
soleRubber4418-02 child
waterproofYes4418-02 child
heel_height4 cm4418 master
widthG4418 master
removable_insole14418 master
originPortugal4418 master
Showing 8 of 40 columns. Types are not in the file.

How it works

  1. Maintain the house list of materials and fit terms.
  2. Match each supplier attribute and size column to a house category or filter.
  3. Translate till departments, brand prefixes and colour wording into website attributes and a default weight.
  4. Load an older attribute export, working out whether each field is text, a choice or a tick box.
  5. Attach attributes to the main product when the stored ID belonged to a variant.
  6. The next supplier file places matching products into the mapped categories.

Pipeline

flowchart LR
  A[House vocabulary] --> B[Supplier words]
  C[Till codes] --> B
  D[Legacy export] --> E[Field catalogue]
  B --> F[Filters and categories]
  E --> F
  F --> G[Next file placement]