Cross-Channel Oversell Guard

The problem this kills

You sell the same SKU on three, five, maybe eight channels - your own store, a couple of marketplaces, a wholesale portal, an EDI feed to a big-box retailer. Each channel thinks it owns the whole shelf. So when one unit is left and four channels still show it as available, you take four orders for one unit. Then comes the ugly part: cancellations, angry buyers, marketplace defect-rate dings, and a planner manually babysitting spreadsheets at 9pm trying to figure out which channel to choke back.

The root cause is simple: nobody is reconciling total open demand across every channel against one shared pool of on-hand stock - and then deciding, with a human's judgment, how much to hold back per channel so you never promise more than you can ship.

This tool does exactly that, on a schedule you control, with a planner in the loop before anything gets published.

What you'll build

A small, private web app that:

• Imports your on-hand stock (one row per SKU) and your open demand per channel (one row per SKU per channel).
• Aggregates demand across all channels and compares it to available stock, flagging every SKU at oversell risk - where committed-plus-open demand exceeds what's on hand.
• Recommends a safe per-channel availability number using a configurable safety buffer per channel (your high-defect-risk marketplace can hold back more than your own store).
• Shows a planner a clean review queue, lets them adjust the recommended buffers and holds, and requires their explicit approval before anything is final.
• Exports an approved per-channel availability CSV in the exact columns your channels expect - ready to push back into each platform or hand to your feed manager.

What's inside the Implementation Plan

• A discovery interview that runs first. Before it builds anything, the plan has the AI agent interview you about your actual channels, how your stock and demand exports are shaped, your SKU and channel naming, your volumes, and your real allocation rules. It reflects a short tailored spec back to you for a thumbs-up - so you get a tool fit to your business, not a generic template.
• A step-by-step build: data model, CSV/Sheet import, the oversell-risk math, the per-channel buffer engine, the planner approval gate, and the availability export.
• A configurable safety buffer per channel, so each channel gets its own cushion.
• A duplicate guard keyed on SKU + channel so the same row can never be counted twice.
• A No API yet? fallback throughout: everything runs off Google Sheets / CSV imports and produces a clean CSV export, so you can ship this today without integrating to any platform.
• Copy-paste prompts at every step - you paste, the agent builds.

The governance it includes (this is the point)

• Login so only your team can open the tool.
• Row-level security so each organization only ever sees its own stock and demand.
• A complete audit trail - who imported what, who changed which buffer, who approved, and when.
• A hard human-in-the-loop approval gate: the AI recommends buffers and holds, a planner reviews and approves, and only then is the availability published and exported. Nothing touches your channels automatically.
• Duplicate guards on SKU + channel so re-importing a file can't double-count demand.

Who it's for

Ecommerce operations leads and demand/inventory planners who sell the same stock across multiple channels and are tired of cancellations, marketplace penalties, and late-night spreadsheet firefighting. If you can run a spreadsheet and follow instructions, you can build this - no coding background needed.

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