How price book pricing rules and supplier price sync stop shorted jobs and ugly invoice prices
Practical walkthrough of using the Trade Books price book: set cost bands, choose markup or margin, round prices, and bulk-update costs from supplier price files so parts prices stay accurate and job costing stays honest.
Why this matters for a trade shop
Parts pricing is a constant bleed if you run it by gut or by spreadsheet. You either slug every part with the same percentage and overcharge small fittings and undercharge big ticket items, or you let techs guess and end up eating the difference. The Trade Books price book model removes that guesswork by matching the price to the part's cost and letting you automate the math so the office and crews see the same clean price every time.
What the system does — the concrete pieces
There are two features that change how you operate day to day:
- Pricing rules by cost band. You assign parts into material cost bands and set a pricing rule for each band. That rule can be a markup or a margin, so a cheap fitting and an expensive condenser do not carry the same percentage treatment.
- Supplier price file uploads. When your supplier sends a price file you upload it to update costs across the entire price book in one pass. Every change is recorded in price history and you can undo the upload as a batch if something looks wrong.
How a day looks after you set it up
Office:
- You maintain the price book. When a new part arrives you add it with its supplier cost and assign it to a cost band. The pricing rules turn that cost into a selling price automatically, using the rule type you picked for that band.
- When you get a new supplier price file, you upload it. Costs update across the price book in one pass. The system records the previous costs in price history so your job costing stays auditable and you can undo the whole batch if the file had mistakes.
- If a tech calls saying a part price looks odd, you check the price history and see whether a recent supplier upload changed the cost or whether someone manually edited a price. That lets you answer quickly and correct the source.
Field tech:
- When they add parts to a ticket the app pulls the selling price from the same price book. They don’t need to calculate margins or guess the right markup; the tech sees the clean price you defined.
- The rules round to a chosen price ending so prices shown to customers don’t look like spreadsheet leftovers. That prevents those awkward invoice artifacts that confuse customers and force edits at the truck.
How markup and margin behave — explained simply
These two words are often mixed up in the wild. Keep this rule of thumb in mind:
- Markup is an amount added on top of cost. You take the supplier cost and add the markup amount to get your selling price.
- Margin is the share of the selling price that is profit. If you set a margin goal, the selling price is the result that leaves that share for profit once cost is removed.
Trade Books lets you specify which math the pricing rule uses for each cost band so you can apply markup to one group of parts and margin to another. That distinction matters when you price big-ticket items differently than consumables.
Rounding: the small detail that saves time
Pricing rules include a rounding choice so the outcome is a clean price ending, not a calculator artifact. In practice this means you don’t get awkward decimals on invoices and techs are less likely to edit prices on the fly. Clean prices speed quoting and reduce customer questions at the doorstep.
What problems this removes, specifically
- It prevents applying one flat percentage to all parts, which underprices expensive items and overprices small ones.
- It stops lost time when suppliers change costs: instead of editing dozens of lines by hand, the office uploads a supplier price file and the system updates costs in one pass.
- It eliminates invoice oddities from raw calculations by rounding prices to a chosen ending, so invoices look professional and consistent.
- It preserves job-cost integrity by keeping a price history and making supplier updates undoable as a batch, so you don’t lose the prior cost data that your past jobs relied on.
Simple math approach to keep in your head
For a markup rule: selling price is cost plus the markup amount you set. For a margin rule: selling price is whatever number gives you that share of profit once the cost is removed.
Don’t get hung up on formula memorization — the important thing is picking the right rule for the right band so your pricing behaves predictably.
How to roll this out in your shop — practical steps
- Inventory your top moving parts and group them into cost bands. For example, separate consumables from mid-range fittings and heavy equipment. Keep the bands broad enough to manage, not every SKU.
- Decide whether each band uses markup or margin. Use markup for low-cost items where you want a fixed add-on. Use margin for higher-cost items where you want a specific profit share of the selling price.
- Pick a rounding rule for each band so customer prices are neat and consistent on invoices.
- Collect a supplier price file and plan a test upload. If you don’t have a supplier file this week, call your main vendor and ask for their latest price list in a common format.
- Upload the supplier price file to update costs across your price book. Review the price history for changes and keep an eye out for any unexpected moves. If you find an error, use the undo batch option to revert the upload and fix the file.
- Train techs to trust the price pulled from the system rather than manually adjusting prices on calls. Reinforce that price history protects job costing so changes won’t erase past job records.
A week-one checklist you can do without buying anything
- List your most common parts and sort them into three to five cost bands on paper.
- Decide which bands would be markup and which would be margin and choose how you want prices to look when rounded.
- Call your main supplier and ask for their current price file or Excel list so you can see raw costs in one place.
When you’re ready to try it in Trade Books
If you want to test the workflow in a live system, Trade Books offers a 30-day free trial, no credit card required, and no contracts. Start by setting up a small price book for your most common parts, upload a supplier price file, and run a quick invoice to see how pricing rules, rounding, and price history behave in practice.
Final note
Automating the parts of pricing that were once manual removes a lot of daily friction: fewer phone calls between techs and the office, fewer edits at the truck, and cleaner job-cost records. Use cost bands plus the right mix of markup and margin, keep supplier costs current with file uploads, and you stop losing profit to inconsistent pricing and broken updates.
Start a trial or take the week-one checklist to your parts manager and supplier to get this under control before it costs you more jobs than it should.