Here’s a number that should scare any distributor: 214. That’s how many wrong shipments a 40-person plumbing supply company sent out in one year. Customers received the wrong valve, the wrong thread size, or the wrong quantity — and the company only found out about 61 of those mistakes because someone complained. The rest surfaced months later as lost reorders.
When the general manager finally studied the return data, the errors clustered around one thing: order entry, not picking. Pickers pulled the right products off the shelf every time. The mistake was happening at the computer screen, and that’s where the ERP Consulting engagement began.
One wrong digit was behind most of the damage
The sales team typed part numbers from memory. A 1/2-inch brass adapter and a 3/4-inch adapter differ by a single digit, and the dropdown list didn’t show the dimension unless you clicked deeper into the screen. Multiply that by ten sales reps, four thousand products, and a target of 60 seconds per order, and you get 214.
I’ve walked through this exact scene in other businesses. The fix is not retraining people to type more carefully. Careful people still make typos under pressure. The fix is building guardrails into the order screen, and those guardrails don’t cost a dime in new software.
Three small screen changes that cut errors by 85%
- When a sales rep selects a part, the full description plus a photo appears before the order can be saved — one extra click, zero extra typing.
- The system warns if the customer ordered the same item in the past six months and the new quantity differs by more than 30%.
- High-return SKUs carry a visible flag on the order line, so the rep double-checks before confirming.
Within 60 days, the wrong-shipment rate fell from 2.6% of orders to 0.4%. The owner estimated the change saved $47,000 a year in freight, restocking labor, and refunds — plus the customers he stopped losing to angry follow-up calls.
The ERP Consulting follow-up call at month three checked one thing: were the guardrails still slowing anyone down? Nobody complained. The team had one question for the system — “is this the right part?” — answered at the moment it mattered most, instead of when a customer found the problem for them.