Managing a large catalogue
Twenty thousand SKUs stay manageable when structure does the remembering: a naming convention, variants under parents, images as identity, one master.
The catalogue that outgrew memory
At a few hundred SKUs, your best salesman is the catalogue.
At twenty thousand — the honest scale of a serious fittings or tiles range — no head holds it, and the business runs on whichever fragment each person remembers. A large SKU catalogue is not managed by trying harder to remember.
It is managed by structure that does the remembering, and four structures carry nearly all of it.
A SKU naming convention that scales
Names are where large catalogues first rot.
The convention that survives:
Add the lookalike rule from hard experience: where two products differ only in one attribute, that attribute goes where hands and eyes cannot miss it, because the picking error lives exactly there.
A fixed attribute order
Category, brand, series, size, finish — always the same sequence.
Readable aloud
A name a human can say at the counter.
Nothing that can change
A rate or a rack in a name is a name that will lie later.
One authority for new codes
The moment two people can invent names, you have two catalogues.
Variants under parents
The same panel in three wattages and two shades is not six unrelated entries — it is one parent with structured variants.
Parent-and-variant structure means the quotation asks which white, the picker sees the difference, and the range reads as families instead of noise.
A flat catalogueThe old way- Six unrelated entries — for one panel in three wattages and two shades
- Multiplies lookalike errors — and buries search
Parents and variants- The quotation asks which white — instead of guessing
- The picker sees the difference — where hands and eyes cannot miss it
- The range reads as families — instead of noise
Images as identity
In these trades a product is chosen by its picture, not its code — so at scale, the image is the identity: one photograph per SKU, on the master, on the quotation line, on the catalogue the customer browses.
The fastest search in a twenty-thousand-SKU business is visual, and every page of this site's trades says the same thing: the estimate with the image wins the argument at home.
One master, one truth
Price lists, quotations, catalogues — all of them generated from the master, never maintained beside it. Every separately-maintained copy is a future contradiction.
The Excel that drifted is how a customer gets quoted a rate that died in March.
One master, everything else derived, every revision dated.
Where the structure comes ready-made
All four structures can be built in spreadsheets with discipline.
The platform version adds the two things spreadsheets resist: supplier price lists extracted into structured data instead of retyped, and a master that everything else — quotation, catalogue, price list — draws from by design:
Bring your ugliest supplier price list to a demo — and watch it become catalogue.
Ask for a demo