Product coding everyone can follow
Use a fixed rule such as category + specification + material, for example HW-CB-25-100 for hardware, cable, 25 mm², 100 m. The code need not be complex, but it must be unique. Keep the customer’s common name in the product name so searches still work.
- Set the selling unit as the primary unit and record the purchase conversion as a secondary unit (1 box = 20 packs).
- Store specification, material and brand as product attributes for optional printing.
- Create aliases or shortcuts for fast movers, so typing “CB” finds cable.
- Add barcodes or bin locations so the warehouse picks without memory.
Metres, kilograms and pieces: multi-unit arithmetic
Fix the conversion and decide which unit owns the stock balance. A common approach is to store stock in the smallest selling unit and convert on purchase receipt.
| Product | Purchase unit | Selling unit | Conversion |
|---|---|---|---|
| Cable | Roll (100 m) | Metre | 1 roll = 100 m |
| Screws | Box (20 packs) | Pack | 1 box = 20 packs |
| Steel | Tonne | Kilogram | 1 t = 1,000 kg |
| Boards | Bundle | Sheet | 1 bundle = 10 sheets |
Once the conversion is set, do not change it casually; historical documents and stock will no longer match. For weighed goods, connect a scale to reduce keying errors.
Delivery notes and 3-part forms for site work
Customers are often fitters, sites and small contractors, and documents must survive checking. A delivery note should include the customer and site name, date, vehicle or driver, specification and quantity, price and amount, and the receiver’s signature.
- Use 3-part forms: file copy, customer copy and return-to-office copy.
- Add a custom “site / project” field to group documents by project.
- Print amount in words and payment terms such as “cash on delivery” or “monthly account”.
- Post returns as separate credit documents referencing the original number.
See the 3-part setup guide for alignment.
Site credit and month-end reconciliation
Site customers often pay monthly, and the risk is a lost document the customer refuses to recognise. Bind every delivery note to a customer and project, file signed copies the same day, and export a statement by customer at month end.
- Record project name, contact and agreed payment term in the customer file.
- Apply payments to specific documents, not just a total.
- Send an electronic statement for checking, then a stamped paper copy.
- Filter overdue customers separately for collection.
Stock and replenishment for a long catalogue
Hardware has many low-price SKUs, so the usual pattern is “fast movers out of stock, slow movers tying up cash”. Manage by sales tier:
- Tier A fast movers: safety stock with automatic alerts.
- Tier B regular items: reorder monthly against sales, not to zero stock.
- Tier C long tail: purchase to order to reduce capital tied up.
- Count fast movers monthly and the whole warehouse quarterly.
Resolve count differences the same day: missing document, unsigned delivery or unrecorded return. See the stocktake process.