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.

AgeAction
0–6 monthsNormal stock, monitor demand
6–12 monthsPromote or bundle
12–24 monthsReturn to supplier if allowed, or discount
Over 24 monthsWrite 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.

  1. Set credit limits per workshop and review before large orders.
  2. Post returns with the original invoice reference.
  3. Separate damaged returns from resellable returns.
  4. Send statements before the agreed payment date.