runbookify
← All plans
Customer Support & Service / Returns, Warranty & RMA

Warranty Claim Validator

Build an internal tool that checks every warranty claim against purchase date, serial/SKU coverage, and covered failure types - so out-of-warranty and excluded claims get caught before someone approves a costly remedy.

IntermediateA weekendBuilds onNext.js (App Router) on VercelSupabase (Postgres, Storage, Auth + RLS)Resend (email notifications)
What you'll build

A claim comes in, the tool matches the serial/SKU, computes coverage, and proposes covered / not covered / needs proof with a clear reason. An agent reviews and approves, then the customer is notified by email and every step is logged.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.

Before you start

  • A free Supabase account
  • A free Vercel account
  • A free Resend account
  • Your warranty terms per product and a list of past purchases/registrations (a spreadsheet is fine)

The problem this kills

Warranty claims are easy to get wrong and expensive to get wrong. An agent eyeballs a claim, can't quickly tell if the purchase date is inside the warranty window, isn't sure the serial number is even one of yours, and can't remember whether "this kind of failure" is actually covered. So claims get approved that never should have been - out of warranty, wrong product, excluded damage - and that money is gone. Meanwhile the genuinely covered customers wait while someone digs through spreadsheets and old emails.

The fix isn't a bigger spreadsheet. It's a small internal tool that does the boring checks every single time, the same way, and shows its work - then hands a clean recommendation to a human to approve.

What you'll build

A simple, login-protected web app for your support team:

  • An agent pastes or uploads a claim - serial number, SKU, purchase date, and what failed.
  • The tool matches the serial/SKU against your purchase/registration records and your warranty terms.
  • It computes coverage: is the purchase date inside the warranty length? Is this serial/SKU one you cover? Is this failure type covered or excluded?
  • It returns a recommendation - covered, not covered, or needs proof - with a plain-language reason.
  • It flags anything suspicious, like the same serial being claimed twice.
  • A human reviews the recommendation and the reason, then approves. Only then is the claim accepted or denied and the customer emailed.
  • Every check, decision, and approval is logged.

What's inside the Implementation Plan

The plan is a complete, paste-and-go runbook for an AI coding agent. You don't write code - you paste, answer questions, and approve.

The very first thing it does is interview you about your business - your products, how your serial numbers and SKUs are actually formatted, where your purchase/registration data lives, your warranty lengths per product, which failure types you cover vs. exclude, and your messy edge cases. It reads back a short tailored spec for your thumbs-up, then builds the tool around your rules - not a generic template.

From there it walks you step by step: the database, the login, importing your warranty terms and purchase records, the coverage engine, the human approval screen, the customer email, and a CSV export for your warranty system. Each step ends with a prompt you copy and paste.

The governance it includes (this is the point)

This isn't a toy. Governance is built in from the start:

  • Login so only your team can use it.
  • Row-level security so each organization only ever sees its own claims and data.
  • A complete audit trail - who checked what, what the tool decided, who approved, and when.
  • A human approval gate before any claim is accepted or denied - the AI drafts the finding, a person reviews and approves, and only then is anything committed.
  • Duplicate guards so the same serial + failure type can't be processed twice, and repeat claims get flagged.

Who it's for

Warranty and support agents, service coordinators, and the team leads who own returns/RMA. If you handle claims today with a spreadsheet, a PDF of warranty terms, and your best judgment, this turns that judgment into a consistent, auditable check - with you still making the final call.

You've got this - paste the first prompt and let the agent interview you.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.