Tracking-Number Harvester & Shipment Notifier

The problem this kills

Your order ships. The warehouse drops the carrier and tracking number into a spreadsheet. And then... it just sits there. Nobody emails the customer, or someone does it by hand three days later, or worse - the tracking number gets pasted onto the wrong order and a customer in Ohio gets told their couch is in Oregon.

Meanwhile the "Where's my order?" tickets pile up. CSRs spend their afternoon copy-pasting tracking numbers into emails and hand-building carrier links that sometimes 404. It's slow, it's error-prone, and it quietly burns customer trust at exactly the moment people are most excited about their package.

This kills that. Tracking numbers stop rotting in a spreadsheet and start turning into clean, branded "Your order has shipped" emails - automatically matched, carrier-correct, and sent only after a human gives the thumbs-up.

What you'll build

A small internal web app your shipping clerks and CSRs log into. They drop in a shipped-orders file, and the tool:

• Imports the batch of shipped orders (carrier + tracking number + customer).
• Matches each tracking number to the right order and customer record.
• Drafts a branded ship notice for every shipment, with a correctly formatted tracking link for that specific carrier (UPS, FedEx, USPS, and whatever you actually use).
• Shows the clerk the whole batch to review - right tracking, right customer, right carrier - on one screen.
• Sends the emails through Resend only after the clerk approves, and logs every send.
• Refuses to email the same shipment twice, ever.

What's inside the Implementation Plan

The plan is a single markdown file you paste into Claude Code, an AI coding agent. It builds the whole tool with you step by step - you don't write code, you answer questions and paste prompts.

It opens by interviewing you about your business - your carriers, your order-ID format, how your shipped-orders export is actually shaped, your typical and peak daily volumes, and your messy edge cases (split shipments, missing tracking, re-ships). It reads back a short tailored spec and waits for your thumbs-up, so the tool fits your fulfillment process - not a generic template.

Inside you'll find:

• The exact discovery interview the agent runs first.
• A data model tuned to your real fields and carrier list.
• Step-by-step build prompts, each ending with a ready-to-paste instruction.
• Correct tracking-link formatting per carrier.
• The full governance layer (below).
• A "No API yet?" fallback: import straight from a Google Sheet or CSV and export a clean CSV in your system's exact columns - so it's fully buildable today, even with zero integration work.

The governance it includes (this is the point)

This isn't a script that blasts emails. It's an internal tool with real controls baked in:

• Login so only your team can use it.
• Row-level security so a user only ever sees their own organization's shipments.
• A complete audit trail - who imported, who approved, who sent, and when.
• A hard human-in-the-loop approval gate - the AI drafts the notices, a clerk reviews the batch, and only an approval triggers the actual send.
• Duplicate guards keyed on order ID + tracking number, so the same shipment can never be emailed twice.

Who it's for

Shipping clerks and CSRs who are tired of hand-emailing tracking numbers, and ops leads who want ship notices to go out fast, accurately, and with a record of exactly what happened. No coding background needed.

You've got this - paste the first prompt and let the agent take it from there.