SuppliersPublished

Keeping supplier catalogue data current

Prices move, colours retire and styles disappear. Stale product data quietly sells things you cannot deliver at prices you cannot honour.

  • 12 min read
  • 1,032 words
Keeping supplier catalogue data current — warehouse at a print shop
Suppliers12 min readA1printsoft EditorialPhoto: MAK / Unsplash
On this page7 sections

The short answer

  • Prices, colours, sizes and availability all change without notice
  • Stale data sells what you cannot deliver at prices you cannot honour
  • Manual updating works only for a deliberately narrow range
  • Integrations move the maintenance to the supplier
  • Live stock at the point of quoting prevents most of the damage

Every quote, storefront and price list a decorator produces rests on supplier product data, and that data starts going out of date the moment it is copied. The failure is quiet: nothing breaks, and then one day an order cannot be filled at the price it was sold for.

What goes stale

DataChangesEffect when wrong
Cost priceAnnually, sometimes moreMargin quietly disappears
AvailabilityHourlySold what cannot be shipped
ColoursSeasonallyOrder placed for a retired colour
Size rangeOccasionallyMissing sizes at close
Style discontinuedAnnuallyThe worst case — no substitute
Images and specsBetween seasonsMockups show the wrong garment

Cost price is the one that hurts continuously rather than dramatically. A blank that rose several times over two years, quoted from an old figure, has been eroding margin on every order since — and nobody notices, because each individual quote still looked profitable.

A discontinued style is an emergency. An out-of-date cost price is a slow leak, and it costs more.

What it costs

Three distinct kinds of damage, and only one of them is visible.

Margin erosion from old cost prices. Invisible until you look at the numbers, and by then it has been running for a year — which is exactly why gross margin is worth checking monthly.

Undeliverable orders when a style or colour has gone. The customer has paid, the store has closed, and the substitution conversation is entirely yours to have — the full recovery is in what to do when a blank disappears.

Lost time checking availability by hand. Every quote requiring somebody to open a supplier site is minutes that repeat all day and are never billed.

Manual updating

Workable, but only for a narrow range and only if somebody owns it.

If you do it by hand

  • Keep the range deliberately short — twenty styles, not two hundred
  • One named person responsible
  • A calendar reminder, quarterly at minimum
  • Immediate updates when a supplier announces a price change
  • A dated record of when each style was last verified
  • Remove anything you have not sold in a year

The date stamp is what makes manual maintenance honest. Without it nobody knows whether a figure is from last month or from three years ago, and the natural assumption is always the optimistic one.

Manual updating fails predictably as the range grows. A shop offering a hundred styles across a dozen suppliers cannot keep that current by hand, and the pretence that it can is where the undeliverable orders come from.

Feeds and integrations

Most major blanks suppliers publish product data and stock information to account holders, and connecting to it moves the maintenance burden to the people who own the data.

What an integration gives you

  • Current cost prices without retyping
  • Live or near-live stock by size and colour
  • Discontinued styles flagged automatically
  • New colours appearing as they launch
  • Product images and specifications maintained
  • Warehouse-level availability where the supplier provides it

The practical gain is not the data itself but where it lands. Product information flowing into the catalogue your quoting and storefronts use means a price change reaches the quote and the store at the same moment, without anybody remembering to act on it.

It also changes what a storefront can offer safely, because a store showing only what is genuinely available cannot sell a retired colour — the broader case is in what a supplier integration actually gives you.

Narrowing the range

The most effective data maintenance strategy is having less data to maintain. Most decorators sell a small number of styles repeatedly and carry a long tail that generates work without generating revenue.

Pruning the list

  • Rank styles by orders over the last year, not by margin
  • Keep the ones that sell; retire the rest from the price list
  • Cover each need once — one good mid-weight tee, not five
  • Quote unusual requests individually as they arise
  • Prefer suppliers whose data you can actually get

A short tested range is easier to maintain, easier to sell and easier to recommend from — the same argument as choosing store products deliberately rather than offering everything.

Live stock

Of everything on the list, availability changes fastest and causes the most immediate damage. A price that is slightly wrong costs margin; stock that is wrong costs the order.

Check availability at the point of quoting for anything time-sensitive, and check again before a store closes. A store that ran for three weeks was quoting against stock levels that no longer exist by the time the order is placed.

Where availability is visible inside your own system, that check happens without anyone doing it — and the sizes that are short surface while the store is still open, which is the only moment the problem is still cheap to fix.

A maintenance routine

Whatever your method

  • Quarterly: verify cost prices on your top styles
  • Seasonally: check colour ranges and discontinuations
  • Annually: review the whole list and prune it
  • Immediately: act on any supplier price announcement
  • Before every store opens: confirm what it will offer

Put those on a calendar with a name against each, because product data maintenance is exactly the kind of task that is important, never urgent, and therefore never done.

Tell customers when a price changes rather than absorbing it silently. A short note explaining that blank costs moved is easier to accept than an unexplained increase discovered on a quote, and it separates your pricing from the impression that you simply put it up.

Keep a note of when a style last sold as well as when it was last verified. A garment nobody has ordered for eighteen months is one you can remove without consequence, and removing it is the cheapest maintenance available. The rest of the suppliers archive assumes the price you quoted is the price you will pay.

Filed underSuppliers
Share
Written byA1printsoft Editorial
175 articles

The print production desk at A1Printsoft. Writes the practical side of running a decorating shop: what things cost, how long they take and what to charge, checked against published trade figures.

Keep reading

More on suppliers

All Suppliers articles

Set up in an afternoon. From what you already do.

Free for 14 days · no card · pick what you make and we preload the methods, products and price tables.