If your team is quoting from one spreadsheet, ordering from another list, and adding materials in ServiceM8 from memory, it is only a matter of time before prices drift apart. That usually leads to underquoted jobs, inconsistent invoices, and unnecessary office admin.
A master price list gives your trade business one reliable place for material pricing. For ServiceM8 users in the UK, it is one of the simplest ways to reduce mistakes and protect margins, especially in autumn when many plumbing, heating and maintenance firms are gearing up for a busy pre-winter period.
At MaterialM8, we see this issue regularly. The businesses that stay on top of pricing usually do one thing well. They create one source of truth, then make sure everyone uses it.
What is a master price list?
A master price list is a central record of the materials, parts and products your business uses, along with the key pricing details attached to them.
It usually includes:
- product name
- SKU or supplier code
- supplier name
- cost price
- selling price
- VAT status
- unit of measure
- category
- last updated date
- notes or product description
This does not need to be complicated. In fact, the best setup is usually the simplest one your office team will actually maintain.
Why trade businesses need one
Without a master list, pricing tends to live in too many places. One engineer has an old saved list. Someone in the office updates only the top 50 items. Another person creates a new inventory item in ServiceM8 because they cannot find the existing one.
That creates a few common problems:
- Quotes use old material costs.
- Engineers charge different prices for the same item.
- Duplicate items appear in ServiceM8.
- Supplier increases are missed.
- Job margins become harder to track properly.
For plumbing and heating firms heading into September and the colder months, this matters even more. Boiler parts, valves, controls, copper fittings and other commonly used materials can add up quickly across a busy run of reactive and planned work. Small pricing errors repeated over dozens of jobs can quietly chip away at profit.
What should go into your master price list?
A good list should help you quote, invoice and review margins without creating extra admin.
Start with your core fields
At minimum, include:
- item name
- unique item code
- cost price
- selling price
- supplier
- category
- last review date
If you already use ServiceM8 inventory, make sure the naming and codes match your existing setup as closely as possible. That reduces confusion later.
Add useful operational detail
Depending on your workflow, you may also want:
- preferred supplier
- pack size
- labour-related notes
- obsolete or active status
- replacement item code
- markup percentage
The aim is not to build a perfect spreadsheet for its own sake. It is to create a practical price list your whole team can trust.
Where should your master list live?
For many small and medium trade businesses, Google Sheets is a sensible choice. It is easy to edit, easy to share, and works well as a central product database.
That is especially useful if your prices change more often in one place than they do in ServiceM8. Instead of treating ServiceM8 as the place where pricing starts, many businesses get better results by managing their master list in a spreadsheet, then pushing approved changes into ServiceM8.
If you want a simple overview of the platform, you can visit Materialm8.
How to build your list step by step
1. Gather your current data
Pull together your existing supplier lists, old spreadsheets, and current ServiceM8 inventory export if you have one. Do not worry if it is messy to begin with. Most businesses start there.
2. Choose one naming format
Decide how items will appear across the business. For example, if you stock a 22mm lever valve, choose one consistent name and stick to it.
Consistency matters because it helps your office team find items quickly and reduces the chance of accidental duplicates.
3. Add cost and selling prices clearly
Keep both values visible. If you only track selling price, it becomes much harder to review margin when supplier costs change.
4. Group items into categories
Create categories that reflect how your business works, such as:
- copper fittings
- valves
- boiler spares
- heating controls
- drainage
- consumables
This makes the list easier to review and update in batches.
5. Set a review routine
A master list only works if it stays current. Put a simple review process in place, especially before your busiest periods.
For many UK trade businesses, early autumn is a good time to review heating and plumbing materials before winter demand increases.
Common mistakes to avoid
Even a well-intentioned setup can become difficult to manage if you overcomplicate it.
Trying to track everything at once
Start with your most-used materials first. You can always expand the list later.
Letting multiple versions exist
If people save local copies or keep private spreadsheets, your master list stops being the master.
Updating ServiceM8 manually item by item
This is where a lot of time disappears. It also increases the chance of missed updates and inconsistent pricing.
How this works with ServiceM8
If ServiceM8 is where your team builds quotes and invoices, your master price list should support that workflow, not replace it.
A practical approach is:
- maintain your approved pricing in one central sheet
- review supplier changes there first
- check for mismatches or duplicates
- then sync the right updates into ServiceM8
That gives you more control and makes it easier to keep office staff and engineers working from the same numbers.
For businesses looking to simplify that process, Materialm8 is built to help ServiceM8 users manage pricing from a central source without changing their whole workflow.
A simple rule to follow
If someone in your business asks, “Which price is the right one?”, the answer should always be the same. It should come from your master price list.
That one change can make quoting cleaner, invoicing more consistent, and price reviews far easier to manage.
Final thoughts
Creating a master price list for your trade business is not just an admin tidy-up. It is a practical step towards better control of pricing, fewer mistakes, and stronger job costing.
If your ServiceM8 inventory has grown over time and prices are now spread across different files, autumn is a good time to sort it out before the winter rush. Start simple, keep one source of truth, and make sure your team knows where the correct numbers live.
If you want help connecting your spreadsheet-based price list with ServiceM8, take a look at Materialm8 to see how the process can be made easier.