Keeping a large catalogue usable

Group products by category, brand and pack size, and use short codes plus barcode labels. Search should work by name, code and common abbreviation.

  • Category hierarchy: office paper, writing instruments, filing, art supplies.
  • Pack size as an attribute, not part of the name.
  • Fast-mover shortcuts for the counter.
  • Archive discontinued items rather than deleting them.

Box, pack and piece

ProductPurchaseSaleConversion
Copy paperBox of 5 reamsReam1 box = 5 reams
PensBox of 50Piece1 box = 50 pieces
FoldersCarton of 20Pack of 101 carton = 2 packs

Standardise on the selling unit for stock so counter staff do not need to convert mentally.

School and office accounts

Schools and offices order repeatedly and pay on term. Keep a price list per account, record each delivery, and send statements at the agreed interval.

  • Customer-specific price lists for large accounts.
  • Credit limits reviewed before peak season.
  • Repeat-order history to speed up reordering.
  • Statements grouped by document and date.

Peak-season stock planning

Use last year’s sales by category and week to set safety stock before the school term. Review fast movers weekly during the peak and avoid over-ordering slow colours or niche items.

  • Set alerts on high-turnover items, not on the whole catalogue.
  • Bundle slow stock with fast sellers rather than discounting everything.
  • Count fast movers weekly during peak months.
  • Review leftover seasonal stock immediately after the peak.