What a ServiceTitan Pricebook Clean-Up Fixes
A ServiceTitan pricebook that has grown over years usually fails in the same five ways: duplicate items, items with no code, category names spelled several different ways, prices stored as text, and rows priced at or below cost that nobody has noticed. The Pricebook Clean-Up service on this site is a done-for-you file clean-up built around exactly those problems. You send your pricebook export exactly as-is, and you get back a clean, import-ready file plus a plain-English change report. This page explains, fix by fix, what changes — and what deliberately does not.
Duplicates are removed — and every removal is listed
Exact and near-duplicates are taken out: items that share the same code, or the same name and price. Duplicates make a pricebook hard to search in the field and easy to price inconsistently, because two technicians can pick two different rows for the same job. Nothing is silently deleted. Every removal is listed in your change report, so you can see exactly which rows came out and why, and check them against the copy of your original export that you keep as your undo button.
Missing codes are generated
Every item missing a code gets one, made unique across the whole book. A row without a code is a row that is hard to reference, search, and keep consistent when the book is imported back into ServiceTitan. Generating the missing codes during the clean-up means the file you import is complete in one pass, instead of failing on gaps you then have to fix by hand.
Categories are normalized to one spelling
Categories are normalized to one spelling and one consistent structure, instead of variations like “Water Heaters”, “Water Heater”, and “WH” sitting side by side for the same kind of work. Inconsistent category names split what should be one list into several partial lists, which slows down anyone browsing the book and makes reporting harder to read. One spelling per category keeps the book's structure the way you intended it.
Money fields are returned as clean numbers
Prices and costs are returned as clean numbers ServiceTitan accepts, not text such as “$1,250.00”. Money typed as formatted text is one of the most common reasons a pricebook file will not import cleanly. Normalizing every money field during the clean-up means the returned file is in ServiceTitan import format, with IDs left blank for new items, the way ServiceTitan wants them.
Problem rows are flagged, never changed
Every row priced at or below cost, or missing a price or cost, is flagged in the change report for your review — and returned unchanged. This service never guesses at your prices. It is a clean-up service, not pricing advice and not a full pricebook rebuild: it prepares the file you already have, and the pricing decisions stay with you. The live landing's own demo run shows the pattern: from a 60-row sample, 52 rows came out, with 8 duplicates removed, 20 codes generated, 118 money fields normalized, and 5 rows flagged for review.
Frequently asked questions
How much does the clean-up cost, and how long does it take?
The founding run is $99 one-time and flat, with a 48-hour turnaround. The clock starts when your file arrives, not when you pay. The founding run covers Services and Materials in ServiceTitan import format, for books up to 1,000 items.
Do you need my ServiceTitan login?
No. The service never needs — or wants — your ServiceTitan login. It is file in, file out: you export your Services and Materials book to Excel or CSV, send that file, and receive the clean file and change report back.
Can I try it before I pay?
Yes. You can send your messiest 25 rows for a free sample clean before you pay anything. Details are on the start page.
What if the cleaned file does not import?
One free fix round is included if the file does not import — and a full refund if it cannot be made to import. The how it works page walks through importing safely, one category at a time.
Who is this for?
HVAC, plumbing, and electrical contractors on ServiceTitan whose pricebook has grown messy over the years, or whose implementation stalled at pricebook setup. Jobber and Housecall Pro are not included in the founding run.
Pricebook Clean-Up overview · How it works · Start your clean-up — $99