Final Inspection & Certificate of Conformance: Kill the Word-Template Retype
Select a finished lot, run your final-inspection checklist, auto-fill the customer, PO, and lot details, and generate a clean Certificate of Conformance — but only after the quality coordinator reviews the results and signs, and never if a check failed.
An internal web tool where you pick a finished lot, run the final-inspection checklist, record pass/fail and measured values, and the tool drafts a Certificate of Conformance pre-filled with order, customer, PO, and lot/serial details. The quality coordinator reviews, signs, and only then is the CoC issued as a PDF and the lot released to ship — with a failed check blocking issue until it's dispositioned.
Before you start
- A Supabase account (free)
- A Vercel account (free)
- Exports you already have: an orders/work-orders CSV (with customer + PO details) and your final-inspection checklist
- Your disposition rules for failed checks (rework, scrap, use-as-is, deviation)
- Claude Code or any AI coding agent
The problem this kills
A finished lot is sitting on the bench, ready to ship. Before it can leave, someone has to run the final inspection — confirm the order met spec, count the quantity, capture the lot or serial numbers — and then produce the Certificate of Conformance (CoC), the signed document that travels with the shipment and tells your customer "this conforms to your purchase order."
And the way most shops do it is brutal. Open last lot's Word doc, save-as, retype the customer name, the PO number, the part number, the quantity, today's date, the lot code — squinting between a traveler, a screen, and a sticky note. One transposed digit on the PO and the customer's receiving dock rejects the shipment. A check that quietly failed gets a certificate anyway because the form doesn't know the difference. Two CoCs get cut for the same lot because nobody tracked the first one. Each slip is small. On a busy shipping day they pile up into rejected loads, chargebacks, and an audit finding waiting to happen.
You don't need a six-figure QMS to fix this. You can build the inspection-and-certificate tool yourself, this afternoon.
What you'll build
An internal web tool your inspection and QA team logs into. You pick the finished lot from the order or work order, and the tool pulls the customer, PO, part number, and lot/serial details forward automatically — no retyping. It walks you through your final-inspection checklist, one item at a time, recording pass/fail and the measured value where it matters. The moment any check fails, the tool refuses to draft a certificate until you record a disposition — rework, scrap, use-as-is, or a documented deviation.
When the checks are in, the tool drafts the Certificate of Conformance with every field already filled. Your quality coordinator reviews the inspection results on one screen, signs, and only then is the CoC issued: exported as a clean PDF that ships with the lot, plus a release record that marks the lot cleared to ship. It handles the awkward real-world cases too: one CoC per lot (a hard duplicate guard), a controlled reissue with a version bump when a customer needs a corrected certificate, and serial-level capture for the lots that need it.
What's inside the Implementation Plan
The downloadable plan is a single markdown file you paste into an AI coding agent. It opens by interviewing you about your own inspection and certificate process — your checklist items and their accept criteria, what your CoC has to say to satisfy your customers, your part-number and lot/serial conventions, your disposition rules, and your messiest exceptions — and then it reads a short spec back for your thumbs-up before it builds a thing. That's the difference between a tool shaped to your certificate and a generic template you have to fight.
From there it walks the agent through the data model (orders, lots, checklist items, inspection results, certificates, and release records), importing the order and checklist, the fail-blocks-issue logic, the auto-fill that kills the retyping, the review-and-sign screen, the PDF generation, and the duplicate/reissue handling. Every step ends with a ready-to-copy prompt. There's a full "No API yet?" path: import your orders and checklist from CSV, produce a CoC PDF and a release CSV, and you never have to touch your ERP or QMS API to ship.
The governance it includes (this is the point)
This is quality — the controls are the product. The plan builds them in: a login so only your team can use it; row-level security so each organization only ever sees its own lots and certificates; a complete audit trail of who inspected, dispositioned, signed, issued, and released, and when; a hard human-approval gate so a CoC is never issued until the quality coordinator reviews and signs; and a duplicate guard (on order/WO + lot) so the same lot can't get two certificates by accident. A failed check physically cannot produce a certificate until it's dispositioned — the tool enforces the rule your auditor wants to see enforced.
Who it's for
Final inspectors, quality coordinators, and shipping/QA leads who own the last gate before a lot leaves the building and are tired of retyping certificates and chasing rejected shipments. If you can explain to a new hire how a lot passes final inspection and what has to be on the certificate, you can build this — no developer required.
You've got this — open the plan, paste the first prompt, answer a few questions about how your final inspection actually runs, and you'll cut your first signed Certificate of Conformance this afternoon.