Garage Parts & Stock Control: Getting Your Parts List In Without Typing It
How UK independent garages can turn an Excel sheet, Xero items list or motor factor export into working stock control — without a warehouse system.
16 October 2026 · 6 min read
Most independent garages don't need barcode scanners and warehouse software. They need their regular parts — filters, oils, pads, discs, bulbs, wipers — to drop onto a job and an invoice at the right price without someone looking it up every time.
The good news is your parts list probably already exists somewhere. This guide covers where to find it, how to get it into a spreadsheet the right shape, and how to keep it useful once it's in.
Where your parts list already lives
Before typing anything, check these places:
- An Excel or Google Sheets file you already keep for prices or stock.
- Your old garage system — most can export parts or products to CSV.
- Xero's products and services list, if you invoice parts from Xero.
- Price lists or order history from your motor factors.
- Recent invoices for your most-used parts, if nothing else exists.
What columns you need
Only a name is essential. The rest makes the list more useful:
| Column | Example | Needed? |
|---|---|---|
| Name / description | Oil filter – Ford 1.0 EcoBoost | Yes |
| Part number / SKU | OF-1234 | Recommended |
| Cost price | 4.20 | Recommended for profit reports |
| Retail price | 9.50 | Recommended |
| Quantity in stock | 12 | Optional |
| Reorder level | 4 | Optional |
- Don't worry about exact header names — a good importer recognises common variations like 'Description', 'SKU' or 'Qty'.
- Currency symbols and commas in prices are fine.
- Extra columns can usually be left in; they'll be ignored.
Start with your top 50 parts
You don't need every part number from a motor factor catalogue. Start with the fifty or so parts you fit every week. That covers most jobs, and the list stays easy to keep accurate.
One-off parts can still go on an invoice as a manual line; add them to stock only if they start coming up regularly.
Setting cost and retail prices
Record the price you pay and the price you charge. That way invoices stay consistent across the team and you can see your margin on parts.
When motor factor prices change, update the cost and retail on the part. Invoices already issued keep the price they were raised at.
Keeping stock levels honest
A few simple habits:
- Do a quick count of your top parts once a month rather than a full stocktake.
- Set reorder levels on parts you can't be without.
- Use parts from stock on the invoice, so quantities go down as you use them.
- Don't chase perfection — close enough beats a list nobody trusts.
How Mechanics Hub handles parts import
Mechanics Hub's Inventory page has an Import CSV button with a short guide and a downloadable template. It recognises common headers from Excel, Google Sheets, Xero and other garage systems, shows a preview before anything is saved, and skips parts you already have so nothing is duplicated or overwritten.
Parts then appear when you add lines to a job or invoice. The Workshop plan is £49 a month with unlimited technicians.
Get your parts list in today
Start a 14-day free trial, import your parts spreadsheet and add a part to a real invoice. No card required.
Frequently asked questions
What format does my parts file need to be?
A CSV file, which you can save from Excel, Google Sheets or most garage systems. Only the part name is required; part number, cost, retail price and quantity are optional.
Can I import my Xero products list?
Yes. Export products and services from Xero as a CSV and import it into the Inventory page. Common Xero column names are recognised.
Will importing overwrite parts I already have?
No. Parts that already exist, matched by part number or name, are skipped.
Will changing a part's price change old invoices?
No. Invoices keep the price they were raised at.
Bottom line
Stock control in a small garage is about having your regular parts ready to drop onto a job at the right price. Find the list you already have, import your top parts, and build from there.