If your team uses different names or codes for the same item, pricing problems are almost guaranteed. One engineer might add a valve under a supplier code, someone in the office might use a shortened description, and another person might create a fresh item in ServiceM8 because they cannot find the original.
That is how inventory gets messy, quotes become inconsistent, and margins start to slip.
For UK trade businesses heading into autumn, this matters even more. September is often when plumbing, heating and maintenance firms start gearing up for a busier season. If more heating jobs, repairs and emergency call-outs are coming in, your team needs one clear way to identify materials across quotes, jobs and invoices.
Standardising product codes across your business gives you that consistency. It helps everyone use the same item, the same price and the same source of truth.
Why product code standardisation matters
A standard product code system is not just about tidiness. It directly affects how smoothly your business runs.
When codes are inconsistent, common problems include:
- duplicate inventory items in ServiceM8
- engineers using the wrong material price
- office staff struggling to find the correct item
- supplier spreadsheets not matching your existing inventory
- inaccurate reporting on materials used
- extra admin every time prices need updating
If you use ServiceM8 and manage pricing in spreadsheets, standard codes make life much easier. They give you a reliable matching point between your master price list and your ServiceM8 inventory.
What a good product code system looks like
A useful code system should be simple, consistent and practical. It does not need to be complicated.
Keep one item, one code
Each stock or material item should have one main code that everyone uses. That code should stay the same across:
- Google Sheets
- ServiceM8
- supplier imports
- quoting
- invoicing
- internal price reviews
If one copper elbow has three different names and two different codes, you do not really have one item. You have six opportunities for confusion.
Choose a primary reference
In most trade businesses, the best option is to choose one primary identifier and stick to it. This is often:
- a supplier SKU
- your own internal stock code
- a standard manufacturer product code
The right choice depends on how you buy materials and how often suppliers change their catalogues. If you mainly work from supplier price lists, supplier or manufacturer codes can be a good starting point. If you want more long-term control, an internal code system may be better.
The important part is consistency, not perfection.
How to standardise product codes in practice
You do not need to rebuild everything in one day. Start with a manageable process.
1. Pick your master price list
Decide where your official product data lives. For many smaller trade businesses, Google Sheets is a practical choice because it is easy to update, review and share.
Your master sheet should include columns such as:
- product code
- product name
- supplier name
- cost price
- selling price
- unit
- category
- notes or status
This creates one source of truth for pricing and materials.
2. Audit your current item data
Before you standardise anything, look at what you already have in ServiceM8 and in your spreadsheets.
Check for:
- the same item listed under multiple codes
- missing codes
- outdated supplier references
- inconsistent abbreviations
- items with codes in one system but not another
This step often shows why price updates have been harder than they should be.
3. Create clear coding rules
Write a few simple rules that everyone follows. For example:
- every active item must have a product code
- the code must be entered in the same field every time
- descriptions should follow one naming format
- old or unused items should be marked clearly, not recreated
- new items should only be added by an authorised person
You do not need a long policy document. A one-page guide is usually enough.
4. Train the team on the new system
Even the best coding system fails if people keep doing their own thing.
Make sure your office staff and engineers know:
- which code to search for
- where to find the approved item list
- who can create new items
- what to do if they cannot find a material
This is especially important in busy autumn periods, when speed matters and shortcuts become tempting.
Common mistakes to avoid
A lot of businesses try to tidy up codes but accidentally create more confusion. Watch out for these common issues.
Using too many variations
If some items use supplier SKUs, others use shortened names, and others use job-specific notes, matching records becomes much harder.
Letting everyone add items freely
Without control, your inventory quickly fills with near-identical entries. Standardisation needs ownership.
Ignoring supplier changes
Suppliers sometimes update product ranges or codes. If your master list is not reviewed, those changes can break your matching process.
Where ServiceM8 and spreadsheets fit together
For many UK trade businesses, ServiceM8 is where the team works day to day, while a spreadsheet acts as the central product database. That setup can work very well, as long as product codes are standardised.
Once your codes are consistent, it becomes much easier to compare supplier updates, review price changes and keep ServiceM8 aligned with your latest material data.
MaterialM8 is built around this practical way of working. It helps ServiceM8 users connect a Google Sheet with their inventory data, so updates are easier to manage without changing the whole workflow. If you want to understand the wider approach, you can start with the Materialm8 homepage.
A simple way to get started this month
If your inventory feels inconsistent, do this in September:
- choose one master list
- select one coding format
- review your top 100 most-used items
- fix duplicates and missing codes
- make sure everyone uses the same process
That small cleanup can make a big difference before the colder months bring more heating and reactive work.
Final thoughts
If your prices, materials and inventory records do not line up, standardising product codes is one of the most useful fixes you can make. It reduces admin, cuts down avoidable mistakes and helps your team work from the same information.
For ServiceM8 users, it also lays the groundwork for smoother updates and better control over material pricing.
If you want a simpler way to manage your master price list and keep ServiceM8 aligned, take a look at Materialm8 to see how MaterialM8 can support your workflow.