If you run a plumbing, heating or other trade business, comparing old and new supplier prices sounds simple. In practice, it often turns into a messy job. Spreadsheets are out of date, item names do not match, and nobody is fully sure which price is the current one.
That becomes a bigger problem in autumn, when many UK trade businesses are preparing for a busy heating season. If your material costs have moved but your selling prices have not, your margins can shrink quietly across dozens of jobs.
For ServiceM8 users, the goal is not just to spot supplier price changes. It is to compare them properly, decide what needs updating, and make sure your team is working from one reliable price list.
Why comparing supplier prices matters more than most businesses think
A small increase on one item may not feel important. A small increase spread across cylinders, valves, pumps, fittings and controls soon adds up.
If you do not compare old and new supplier prices clearly, you can run into a few common issues:
- engineers quoting with old figures
- office staff using a different version of the price list
- inconsistent mark-up across similar items
- missed increases on fast-moving stock
- reduced gross profit without an obvious reason
This is especially relevant for plumbing and heating firms in the UK heading into colder months, when job volumes often rise and material use increases.
Start with one clean source of truth
Before you compare anything, make sure you are not pulling prices from three different places. Many businesses have supplier spreadsheets, old CSV files, ServiceM8 inventory exports and ad hoc notes all floating around at the same time.
That usually leads to confusion.
The better approach is to choose one master list, often in Google Sheets, then compare the incoming supplier prices against that list. Once reviewed, you can update the figures your business actually uses.
MaterialM8 is built around this kind of practical workflow for ServiceM8 users. Instead of treating price updates as random admin, it helps create a clearer process around your data.
If you want an overview of the platform, you can visit Materialm8.
The best way to compare old and new supplier prices
A proper comparison is about more than placing two columns side by side. You need to be confident that the item in the new file is genuinely the same item as the one already on your list.
Match items using a consistent identifier
The cleanest method is to compare using a unique product code or SKU. If you rely only on product names, you can get false matches.
For example, one list may say:
- 15mm Lever Valve
- Lever Valve 15mm
- 15 mm Isolation Valve
They might all refer to the same product, or they might not. Codes make this easier.
If your supplier file does not line up neatly with your ServiceM8 inventory, it is worth reviewing your internal process before updating anything in bulk.
Compare the fields that actually affect margin
When reviewing old and new supplier prices, check more than just the buy price. A useful comparison normally includes:
- supplier product code
- product name
- old cost price
- new cost price
- difference in pounds
- percentage change
- current sell price
- whether the sell price needs changing
This gives you a clearer picture of which increases matter most.
What to look for when reviewing the changes
Not every price movement needs the same response. Some changes are minor. Others can have a direct impact on quoting and job profitability.
Focus first on:
- high-volume items used every week
- high-value materials where even a small percentage rise matters
- items with very tight margins
- products used in winter-heavy work such as heating repairs and replacements
- lines where the supplier description has changed unexpectedly
If you manage stock or materials in ServiceM8, this is also a good time to check for duplicate items. Duplicate records can make price comparison much harder because the same product may appear more than once under slightly different names.
A simple review process for trade businesses
If you want a process your office can actually stick to, keep it simple.
A practical monthly or seasonal routine
Try this:
- request the latest supplier price file
- compare it against your current master list
- flag items with meaningful increases or decreases
- review whether your sell prices and mark-up still make sense
- approve the changes before they are pushed into your working system
- update ServiceM8 only after the review is complete
Autumn is a particularly good time to do this. For many plumbing and heating businesses, September and October are when demand starts building. Getting your prices right before winter work ramps up can help you avoid margin leaks during your busiest period.
Common mistakes to avoid
When comparing old and new supplier prices, a few errors come up again and again:
- comparing files with mismatched columns
- relying on product names alone
- updating cost prices but forgetting sell prices
- importing changes without checking duplicates
- making changes directly in ServiceM8 without a reviewed master list
- failing to keep a record of what changed and when
These problems are rarely dramatic on day one. The issue is that they create gradual pricing drift, and that drift becomes expensive over time.
Make the comparison step easier next time
The easiest way to handle supplier price changes is to make future comparisons easier, not harder.
That means:
- keeping one central price list
- using consistent product codes
- storing previous prices for reference
- reviewing changes before syncing them into ServiceM8
- making sure the office and engineers use the same numbers
For ServiceM8 users who want a better way to manage that process, Materialm8 is designed to help connect your spreadsheet-based master list with your ServiceM8 inventory, so price updates are easier to review and manage.
Final thoughts
Comparing old and new supplier prices is not just an admin task. It is part of protecting your margins, keeping quotes accurate and making sure your team is working from the same information.
If your current process involves too many files, too much manual checking or too much guesswork, it may be time to tighten it up before the busy winter period.
To see how MaterialM8 helps ServiceM8 users manage pricing data more clearly, visit Materialm8 and explore a simpler way to stay on top of supplier price changes.