Hazmat & Restricted-Item Ship Check

The problem this kills

A restricted or hazmat item shipped without the right paperwork is not a small mistake. It can mean a carrier refusal, a returned pallet, a fine, or a safety incident - and it almost always means an angry phone call after the truck has already left.

Right now the safeguard is somebody's memory. A shipping clerk is supposed to remember that this aerosol can't go air, that lithium batteries need a label, that you don't ship that chemical to certain states, that one carrier won't take a SKU another one will. On a slow day that works. On a peak day, with a queue of orders and a cutoff looming, it doesn't - and the orders that need the most care are exactly the ones that get rushed.

This tool moves that knowledge out of one person's head and into a screen that checks every pending order, every time, before it ships.

What you'll build

A small, login-protected web app for your fulfillment and compliance team:

• Pull in a batch of pending orders (CSV export, or a Google Sheet) and your restricted-SKU + rule table.
• The tool scans every order line against your rules and flags orders that contain a restricted or hazmat SKU, ship to a restricted destination, or use a carrier that won't take the item.
• Each flagged order shows exactly why it tripped and what it needs - the required documents, labels, and handling notes.
• A human gate: compliance or a fulfillment lead reviews each flagged order and either approves it (special handling confirmed) or holds it (kicked back, with a reason).
• The output is a clean cleared-to-ship list plus a held list - and a full record of who decided what, and when.

What's inside the Implementation Plan

• It starts by interviewing you about your business. Before writing a line of code, the plan has the AI agent ask about your actual orders, your restricted SKUs, your carrier and destination rules, your volumes, and your messy exceptions - then it tailors the data model, the checks, and every later step to your answers. You get a tool built for how you ship, not a generic demo.
• A step-by-step build, each step ending in a prompt you paste straight into your AI coding agent.
• The restricted-rule engine: SKU-level, destination-level, and carrier-level checks, all driven by a table you control.
• The approve / hold gate and the cleared-to-ship export.
• A "No API yet?" path so you can build the whole thing today from a spreadsheet, with no connection to your existing order system required.

The governance it includes (this is the point)

This isn't a toy. The plan builds in the controls a compliance team actually needs:

• Login so only your team can open the tool.
• Row-level security so each organization only ever sees its own orders and rules.
• A complete audit trail - every flag, approval, and hold is recorded with the person and the timestamp.
• A hard human-in-the-loop gate - the tool flags and drafts the required handling, but nothing reaches a cleared-to-ship list until a person approves it.
• Duplicate guards keyed on order ID, so the same order can't be cleared twice.

Who it's for

Shipping clerks who need a fast, reliable second pair of eyes at the pack bench. Compliance staff who need proof that restricted goods were reviewed before they shipped. Fulfillment leads who own the cutoff and can't afford a refusal or a fine.

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