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
| Product | Purchase | Sale | Conversion |
|---|---|---|---|
| Copy paper | Box of 5 reams | Ream | 1 box = 5 reams |
| Pens | Box of 50 | Piece | 1 box = 50 pieces |
| Folders | Carton of 20 | Pack of 10 | 1 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.