NOTES FROM THE OPERATION
Supplier Scorecards for Small Ecommerce Teams
Create a practical supplier scorecard using delivery, quality and issue evidence, with a worked example and clear actions for a small ecommerce team.
A supplier scorecard should help a small ecommerce team decide what to discuss, investigate and change. Start with a few measures based on purchase orders and goods received, show the sample size, and attach actions to exceptions. A colourful overall score is optional; reliable evidence is essential.
The framework below is a proposed educational template. It is not a claim that a particular business has used it or achieved a measured improvement.
Choose measures that support a decision
Begin with delivery reliability, usable quality and issue resolution. Add commercial measures where they affect a real purchasing decision. CIPS supplier performance guidance identifies delivery, quality, service and costs as relevant areas and emphasises agreed objectives and objective evidence.
Define each measure before collecting results. For a small monthly scorecard, a practical starting set is:
- On-time, in-full orders: purchase orders due in the period that arrived complete by the agreed date, divided by all orders due.
- Quality acceptance: inspected units accepted as usable, divided by inspected units received. Show the inspection coverage alongside the result.
- Issue resolution: median business days to close agreed supplier issues, with unresolved cases shown separately.
- Invoice exceptions: invoices requiring a correction, divided by invoices checked, with the reason recorded.
These definitions are proposals, not universal standards. Agree how split deliveries, changed dates and buyer-caused delays are handled. Keep the original promise date and the revised date visible so a repeatedly postponed delivery does not appear automatically on time.
Use a compact evidence record
A spreadsheet can begin with purchase order, supplier, SKU, quantity ordered, agreed delivery date, actual receipt date, quantity received, inspection result and issue reference. Keep commercially sensitive pricing and supplier contact details in an appropriately restricted system.
Link each exception to evidence such as a goods-received note or agreed correspondence. Separate confirmed supplier defects from warehouse damage or an incorrect product specification supplied by the buyer.
This distinction complements the stock discrepancy investigation process: a short receipt needs a different corrective action from stock lost after receipt.
Read the sample size before the percentage
Illustrative example: a supplier had eight purchase orders due this month. Six arrived complete and on time, giving a proposed on-time, in-full result of 75%. Separately, 990 of 1,000 inspected units were accepted, giving a 99% quality acceptance result for that inspected sample.
Do not average 75% and 99% and call the supplier satisfactory. One late order might contain the only replenishment for a fast-selling product. Read the affected SKUs, delay length and available cover before deciding what matters operationally.
If the next month contains only one order, label that small sample clearly. Compare several periods where useful, while keeping recent serious incidents visible. An unresolved safety or compliance concern needs escalation regardless of an otherwise strong score.
Turn the review into agreed actions
Use a short monthly conversation to check the data and agree a response. For each material exception, record the cause, action owner, due date and evidence needed to close it. Ask the supplier to correct factual errors before treating the record as final.
For example, repeated incomplete cartons might lead to an agreed packing-list check and a receipt check on the next delivery. A delivery delay might require earlier confirmation of production readiness. Avoid imposing an arbitrary traffic-light threshold without discussing its commercial context.
Feed findings into replenishment planning
Use observed delivery variability to review planning assumptions rather than treating a quoted lead time as guaranteed. The reorder point guide explains how lead time and demand affect replenishment timing.
The stock reorder calculator can explore a revised lead-time assumption. It uses constant demand and one dated incoming delivery per product; it does not forecast supplier reliability. Keep the scorecard as evidence for human decisions, and revisit whether its measures still help the team act.