Customer Garage CRM: VINs, Warranties & LTV

Here is a mindset shift that made me real money, and it took me embarrassingly long to see it. In a normal business, a CRM is organized around a person: name, email, maybe a deal size. Fine. But in film and detail, the relationship isn't really with the person — it's with their garage. People don't protect a paycheck. They protect a specific car they love, and then the next one, and then the household's daily driver, and then the toy they bought when the business had a good year.

So a contact-shaped CRM is the wrong shape for this trade. A row that says "Marcus, [email protected]" tells you nothing you can sell against. A row that says "Marcus — 2019 Raptor (full front, STEK, installed March), 2022 Highlander (nothing yet), warranty active, hasn't been in for 14 months" tells you exactly what to say when the phone rings. Same customer. Completely different conversation. One is a stranger; the other is a relationship you can actually work.

We're all installers before we're business owners, and installers remember cars, not contacts. You'll forget a customer's last name and still recall the weird satin wrap you did on his Tacoma two summers ago. The problem is that memory doesn't scale past a couple hundred cars, and it definitely doesn't survive a new front-desk hire. A customer garage CRM just writes that memory down in a form the whole shop can use.

Start with the thing that fixes the most headaches: one record per customer, and everything lands on it. Contact details and their preferred channel, sure — but underneath that, every vehicle they own, and the money, the messages, the jobs, the warranties and the staff notes all merged into a single timeline, newest first. Not five tabs. Not "let me check the other app." One page that reads like a story.

The magic isn't any one of those pieces — it's that they sit together on the same timeline automatically, while you work. A quote goes out, it lands on the record. The customer texts back, that lands too. You register the warranty, drop a note about the paint condition on the driver door, invoice the job, take the deposit — all of it stacks up in order, without anyone filing anything. Open the customer and you don't reconstruct the history. You just read it.

That is the whole promise of a unified customer record: the story builds itself. When a customer calls, you pull up one page and you know what they bought, what you last said to them, what's under warranty, and what's still owed — in seconds, not after ten minutes of digging through a phone for that one text. You sound like you remember everything, because you do. The record is doing the remembering.

And it matters most on the days you're slammed. When you've got three cars in the bay and a fourth on the way, you do not have the spare brain to piece together a customer's history from memory. The record hands it to whoever's at the desk — you, a new hire, a part-timer — and they all sound equally on top of it. That's the part I'm a little obsessive about: the good customer experience stops depending on which human happens to pick up.

Now the part this whole thing is named for. Under each customer sits their garage — every vehicle you've worked on, stored with the year, make, model and VIN, and the full work history hanging off each one. Not "Marcus's truck." The 2019 Raptor, VIN on file, full front installed in March, this film, this warranty. And right next to it, the Highlander you've never touched.

Why does the VIN matter enough to name the product after it? Because a car is the one thing in this business that's actually unique. Two customers can share a name; no two cars share a VIN. It's the fingerprint. It nails down the exact vehicle a warranty covers, it kills the "wait, which car was that on" confusion when someone owns three, and it makes a returning customer an instant, informed conversation instead of a guessing game. Someone rolls in for a top-up and you already know the film that's on the car, the date it went on, and who did it. You look like the most organized shop they've ever dealt with, because for that customer, you are.

The garage view is also where the next sale is hiding in plain sight. One glance and you can see the customer who protected the front of his Raptor but left the rockers bare, or the household with two cars on file where only one has ever been coated. You're not inventing work — you're noticing the work the car is already asking for. The leads that turn into these records start life over in vehicle-aware lead capture, so the car is attached from the very first inquiry, not bolted on after the fact.

Let's be honest about what a warranty actually is in a film shop. Half of it is real coverage — the film maker's promise plus whatever your shop stands behind on the install. The other half, the part nobody says out loud, is a reason to talk to the customer again. A warranty is a scheduled excuse to reconnect. If you can find it.

On the record, you register coverage against the customer and the exact vehicle — not floating in the abstract, but tied to that VIN. It gets a real warranty number, drawn from the same per-shop counter as your invoices, so it's a proper W-number you can quote back, not a sticky note. You set the type — manufacturer, shop, or extended — what's covered, the start date and the term, and the expiry computes itself. When coverage lapses, the record shows it. You don't do warranty math in your head at the counter.

That does two jobs at once. At claim time, you look like a professional: the coverage is documented, dated, tied to the right car, and you can pull it up while the customer is still talking. No "let me see if I can find the paperwork." And at renewal time, the computed expiry is a built-in prompt to reach back out before the coverage runs dry — which, not coincidentally, is a great moment to talk about the top-up or the second car. Pair the record with warranty and renewal reminders and the reach-out fires on time without you keeping a mental calendar of who's coming due.

I want to be careful here, because warranties are where shops oversell. A warranty is a promise with terms, not a magic force field — what it covers is exactly what you wrote down, no more. But a coverage record that's findable, numbered and correctly dated is worth a lot on its own: it's the difference between looking buttoned-up at claim time and looking like you run the place out of a shoebox.

Here's the number most owners never look at, because it's too annoying to add up by hand: what a customer is actually worth to you over the whole relationship. Not this job. All of it. On the record, lifetime value sits right there, computed live from your paid invoices — what's actually been collected, not what you hoped to collect — with the balance due tracked the same way. Nobody maintains it. It just reflects the truth every time you look.

And the record grades itself. Every customer carries a status — New, Active, Repeat, or At-risk — that derives from real activity, not from somebody remembering to re-tag them. The customer who's come back three times shows as Repeat. The one who went quiet for a year surfaces on his own as At-risk, which is really just a polite way of saying call this guy. You don't have to hunt for the people worth reconnecting with. The record raises its hand.

That changes where you spend your energy. Follow-up is a limited resource — you've only got so many calls and texts in a day — and most shops spray them randomly or not at all. When you can sort the book by lifetime value and filter it by status, you spend that energy on the customers who've earned it and the ones about to slip away, instead of blasting everyone the same. The list stops being a filing cabinet and starts being a to-do list with revenue attached.

To make the idea concrete, here's a made-up customer showing how value can stack up over time. These numbers are an illustration, not an average — your customers are your own — but the shape is the point.

The best marketing in this trade still walks in on someone's recommendation. A guy sees his buddy's wrapped hood, asks who did it, and now you've got a customer who arrived pre-sold. The problem is that most shops have no idea who their real promoters are. You've got a vague sense that "a few people send me work," and that's where it ends.

On the record you set "referred by" on any customer, and it reads in both directions — who sent them, and everyone they've sent you — with the actual revenue each referrer has produced, computed from paid invoices. Your top promoters stop being a hunch and become a number. So when it's time to say thank you — a detail on the house, a bit off the next job, a genuine phone call — you're rewarding the people who actually moved the needle, not the loudest person in your contacts.

Treat that number as a relationship, not a leaderboard. The guy who sent you three cars this year is worth a real thank-you, and the point of tracking it is so you don't let that slide. Word of mouth is the cheapest, best channel you'll ever have — the least you can do is know who's running it for you.

Zoom all the way out, because this is the part that actually matters. The record isn't about tidiness. It's about time. A shop that forgets its customers is condemned to keep chasing new ones — re-buying the same lead over and over, always starting cold, always at the top of the funnel. A shop that remembers plays a completely different game.

When the car, the history, the warranty and the value all live on one record, a single job stops being a single job. It becomes the first entry in a garage you'll service for a decade: the front today, the full wrap in two years, the ceramic maintenance every season, the wife's SUV when she finally gets tired of the rock chips, the kid's first car when he turns sixteen. That is a real business — recurring, referral-fed, and mostly protected from whatever the ad market is charging this month.

You don't get there by being the best installer in town, though it helps. You get there by being the shop that remembers — the one that calls before the warranty lapses, that already knows which car and which film, that treats a customer like the ten-year relationship he could be instead of the one invoice he is today. The record is how you keep the garage. If you want to see where it lives in a full shop system, the customer garage inside detailing software is the whole thing in context — and the plan that fits your shop is a two-minute look. Play the long game. Keep the garage.