Keg fleet tracking for self-distributing breweries

Micro-SaaSWeb1 weekNext.jsSupabaseStripe

The idea

A small brewery self-distributing to 40 bar accounts leaks kegs constantly. A keg goes out on a Tuesday drop, the bar’s cellar swallows it, and eight months later nobody remembers it exists. At 100-150 USD per stainless keg and roughly ten percent annual loss, a 300-keg fleet quietly burns thousands a year, and the owner’s tracking system is a whiteboard.

Kegshoe and Kegstar exist, but they are priced and designed for mid-size distributors with logistics staff. A self-distributing brewery needs one thing: a driver’s phone, a QR sticker, and two buttons. The wedge is being the dumbest possible version of keg tracking, done well.

Who pays

The brewery owner pays 25 USD/month flat. One recovered keg pays for four to six months of the subscription, which makes the pitch a single sentence. Distribution: state brewers guild newsletters, the ProBrewer forum, and craft brewery owner groups, plus cold outreach to breweries listed as self-distributing on state licensing databases.

MVP scope

  • Keg registry with printable QR label sheets
  • Mobile web scan page: scan, pick account, Deliver or Return
  • Dashboard with at-home, at-account, and aging buckets
  • Weekly keg-aging email flagging accounts holding kegs 45+ days
  • Immutable movement log per keg
  • Skip for v1: native apps, GPS tracking, invoicing, deposits, distributor multi-tenancy
// Build prompt — paste into Cursor / Claude Code / Lovable / Bolt
Build KegLedger, a web app that tracks a small brewery's keg fleet with QR scans.

Stack: Next.js (App Router), Supabase (Postgres + auth), Stripe for billing. No native app; the driver flow is a mobile web page using the browser camera via a QR-scanning library.

Core flow: the brewery registers kegs (size, serial), and the app generates a printable PDF sheet of weatherproof-format QR labels, one per keg. On delivery, the driver opens the scan page on their phone, scans a keg's QR, picks the account (bar or restaurant, searchable list), and taps Deliver. The keg's status flips to at-account with a timestamp. On pickup, scanning the same QR and tapping Return flips it home. Every scan writes an immutable movement log row.

Pages: magic-link login, fleet dashboard (kegs at home, at accounts, aging buckets), account detail showing kegs held and days out, mobile scan page, label print page, movement history, settings, billing.

Implementation details: the scan page must work in one hand in a parking lot, so after each scan pre-select the last-used account and make Deliver a single large button. A weekly cron sends the owner a keg-aging email listing every account holding kegs 45+ days, sorted worst first, with keg serials.

Pricing: 25 USD/month flat per brewery via Stripe Checkout, 30-day free trial, unlimited kegs and users.

// More Micro-SaaS ideas