How Wigan Plumbers Can Use AI to Automate Parts Ordering and Supplier Management
You're a plumber in Standish. You're halfway through a bathroom installation when you realise you're short on 22mm compression fittings. You have some in the van but not enough. The nearest Screwfix is a 20-minute round trip. The customer is watching. The job runs over by an hour. You invoice the same amount, absorb the wasted time, and make a mental note to stock up, which you then forget to do before the next bathroom job.
Parts management is one of the most consistently annoying parts of running a plumbing business. It's not glamorous, it doesn't feel like it needs a system, and it's easy to manage reactively until the reactive approach costs you a morning. AI tools and basic automation can take most of the friction out of parts ordering without requiring you to become a logistics expert.
The Real Cost of Poor Stock Management
The obvious cost is wasted trips to the merchant or Screwfix. But there are less visible costs too. Keeping too much stock in the van ties up cash in materials sitting unused. Ordering parts job by job from whichever supplier you happen to use means you're probably not getting the best price consistently. And having multiple supplier accounts with no central record of what you've ordered and from where makes it harder to spot patterns, negotiate better terms, or identify which suppliers are consistently slow or unreliable.
For a busy plumber in Wigan covering Atherton, Leigh, and surrounding areas, getting parts management right can save several hours a week and reduce materials costs by 10 to 20 percent.
Building a Simple Van Stock System
Start with a list of the parts you use on almost every job. For most plumbers, this includes: compression fittings in 15mm and 22mm, pipe in both sizes, PTFE tape, solder and flux, isolation valves, flexible hoses, basin waste kits, toilet siphons or flush valves, and a range of push-fit connectors.
Ask ChatGPT to help you build a van stock spreadsheet. Give it your list of common parts and ask it to produce a spreadsheet template with columns for: part name, category, current stock quantity, minimum stock level (reorder point), preferred supplier, unit cost, and last ordered date.
The prompt might look like this:
"Create a van stock spreadsheet template for a plumber. I carry the following parts regularly: [paste your list]. Include columns for current stock, reorder point, preferred supplier, unit price, and last ordered date. Add a column that flags when stock falls below the reorder point."
The output is a clean template you can paste into Google Sheets. Once you're updating it regularly after jobs, you can add a conditional formatting rule that highlights any row where current stock is below the reorder point. That gives you a visible low-stock alert every time you open the sheet.
Comparing Supplier Prices with AI
Most plumbers in the Wigan area have accounts with a mix of national suppliers (Screwfix, Plumb Center, City Plumbing) and local merchants. Prices vary significantly between them, and they change regularly.
ChatGPT can help you write a structured comparison table for common parts. Give it the parts you buy most often and ask it to produce a template where you can enter current prices from each supplier. Once the table is filled in, it's easy to see at a glance which supplier is cheapest for which category of parts.
For parts you buy in volume, it's worth emailing suppliers to ask for a trade discount or a fixed price list. ChatGPT can write that email for you in under a minute:
"Write a short professional email to a plumbing supplier asking for a trade discount based on regular volume purchasing. I'm a sole-trader plumber in Wigan with approximately £1,500 per month in parts spend. I currently split orders across three suppliers and would like to consolidate more spend with one supplier in exchange for better pricing."
A well-written email like this, sent to two or three suppliers, often results in at least one of them coming back with better terms.
Setting Up Automatic Low-Stock Alerts
If you're working in Google Sheets, you can set up an email alert when a stock row hits the reorder point. Google Sheets has a built-in notification feature, or you can use Zapier to create a more customised alert.
A Zapier workflow can watch your stock spreadsheet and, when any cell in the "current stock" column drops below the value in the "reorder point" column, it sends you a text or email listing the parts that need ordering. This means you don't need to remember to check the spreadsheet. The alert comes to you.
For plumbers using job management software like Jobber or ServiceM8, both platforms allow you to attach parts to jobs. ServiceM8 in particular has inventory tracking built in, so every time you mark a part as used on a job, the stock count updates automatically. When it hits your minimum level, ServiceM8 can notify you.
Using ChatGPT for Supplier Queries and Disputes
Occasionally you'll need to query an invoice, chase a late delivery, or raise a complaint about a parts quality issue. Writing these emails in a way that's firm but professional is something most tradespeople find awkward. ChatGPT handles it instantly.
Example prompt:
"Write an email to a plumbing supplier querying an invoice. I ordered 10 packs of 22mm compression fittings at £4.20 each but have been charged £5.10 each on the invoice. I want to request a credit note for the difference. Keep the tone polite but clear."
The output is a professional email that makes your position clear without being aggressive. Send it as-is or adjust a line or two to match your voice. These kinds of disputes, when handled in writing rather than by phone, are easier to track and more likely to result in the supplier conceding the point.
Integrating Parts Tracking with Your Job Management Software
The most efficient setup links your parts ordering directly to your job management system. When you log a job in Tradify or Jobber, you attach the parts you expect to use. After the job, you confirm what was used. The system tracks your materials spend per job, which feeds directly into your invoicing and helps you spot jobs where you're consistently underestimating materials costs.
This kind of data, built up over three or four months, tells you a great deal about your margins. If bathroom installations are consistently running over on materials compared to what you quoted, that's a pricing problem you can fix. If first-fix jobs are always profitable but second-fix jobs aren't, that's worth investigating.
Reducing Van Stock Wastage
Carrying too much stock wastes cash. Parts with long lead times are worth keeping as buffer stock. Parts that are available same-day from Screwfix or a local merchant in Orrell or Wigan town centre don't need to be stockpiled in the van.
Ask ChatGPT to help you categorise your common parts into "always carry" and "order as needed" groups based on availability and how often you use them. Give it your parts list and explain that you're based in Wigan and have same-day access to Screwfix, Plumb Center, and a local trade merchant. The AI will suggest a sensible split that reduces the amount of capital sitting in your van on any given day.