Managing cross-referenced part numbers
Choose one internal code as the primary identifier and store OEM and aftermarket numbers as searchable aliases. Staff should find the item from any known number.
- Primary internal code, for example AP-BRK-00123.
- Alias fields for OEM number, supplier code and common trade name.
- Vehicle fitment attributes: make, model, year, engine.
- Photos or notes for ambiguous parts.
Serving the counter quickly
Counter speed depends on lookup, not on typing. Search by part number, alias or vehicle attributes and show stock across warehouses before quoting.
- Barcode or QR labels on shelves for fast movers.
- Stock by warehouse visible during the search.
- Last selling price and customer-specific price shown automatically.
- Print a 2-part or 3-part sales form with part number and fitment notes.
Slow movers and obsolete stock
Auto parts catalogues accumulate dead stock. Review ageing by category and part, and set a rule for discounting or returning to the supplier.
| Age | Action |
|---|---|
| 0–6 months | Normal stock, monitor demand |
| 6–12 months | Promote or bundle |
| 12–24 months | Return to supplier if allowed, or discount |
| Over 24 months | Write down and stop reordering |
Workshop accounts and returns
Workshops often buy on account and return unused parts after a job. Apply returns against the original invoice, put the part back into stock in sellable condition, and reduce the receivable at the same time.
- Set credit limits per workshop and review before large orders.
- Post returns with the original invoice reference.
- Separate damaged returns from resellable returns.
- Send statements before the agreed payment date.