Warranty/Defect Return Tracker

The problem this kills

A defective unit comes back and the clock starts ticking - but nobody's sure if it's still under warranty, what kind of defect it is, or whether the vendor owes you a credit. So warranty units quietly get scrapped, or worse, restocked into sellable inventory and shipped to the next customer. Meanwhile the vendor recovery you were owed - the repair, the replacement, the credit - expires because no claim was ever filed.

The real damage isn't one return. It's the pattern: serial and lot numbers scattered across emails and sticky notes, no consistent way to check the purchase date against the warranty period, defective stock mixed in with good stock, and the same unit getting "processed" twice by two different people. Every one of those gaps is money walking out the door.

What you'll build

A private, login-protected web app where your team logs each warranty or defective return, and the tool does the disciplined parts for you:

• Validates warranty by checking the serial or lot and purchase date against your actual warranty terms - in warranty, out of warranty, or needs review.
• Classifies the defect using your own defect taxonomy so the data is clean and reportable.
• Segregates defective stock from sellable so nothing gets accidentally restocked and shipped.
• Routes a resolution - repair, replace, credit, or return-to-vendor (RTV) - that a coordinator must approve before anything happens.
• Files the recovery by exporting a clean vendor warranty claim, so the credit you're owed actually gets requested.

It works even if you can't connect to your ERP today: import returns from a Google Sheet or CSV, and export actions and claims as CSV in exactly the columns your system expects.

What's inside the Implementation Plan

The plan is a single file you paste into an AI coding agent (Claude Code). It builds the whole tool with you, step by step, in plain language - no coding background needed.

It opens by interviewing you about your business - your current returns process, your systems and spreadsheets, how your serials and lot codes are actually formatted, your warranty terms by product, your defect taxonomy, your typical and peak return volumes, and your messiest edge cases. It then reads back a short tailored spec for your thumbs-up, and shapes the data model, the warranty validation, and every later step around your answers. This is the difference between a tool that fits how you really work and a generic template you'd have to fight.

From there it walks through accounts, the database, the return-logging screens, warranty validation, defect classification, the approval gate, stock segregation, and the CSV exports - each step ending in a ready-to-paste prompt.

The governance it includes (this is the point)

This isn't a loose spreadsheet replacement. The plan builds in the controls that make a returns process trustworthy:

• Login so only your team can use the tool.
• Row-level security so people only ever see their own organization's data.
• A complete audit trail - who logged, validated, classified, and approved each return, and when.
• A hard human-in-the-loop approval gate - the tool drafts the warranty determination and resolution path, but a coordinator must review and approve before any action or vendor claim is issued.
• Duplicate guards so the same serial/lot and claim can't be processed twice.

Who it's for

Warranty and returns coordinators, quality teams, and customer service staff who handle defective product and need to recover value from vendors without losing units to the scrap pile or the restock shelf. If you live in spreadsheets and email and wish the warranty math and the vendor claims just happened reliably, this is for you.

You've got this - paste the first prompt and let the interview tailor the build to your business.