Admin Panel

Everything to buy to cover the pending orders, after subtracting what's already on the warehouse shelves — grouped by store / distributor. Orders that are already packed are excluded (their stock has been pulled). Kegs and untracked products show the full ordered amount.

The Google Sheet, rebuilt in-site — every order line as a spreadsheet row, plus the Weekly Summary and Revenue roll-ups. Store shopping lists live in 🛒 Buy List; per-client history is in Clients. Use ⬇️ CSV to open the rows in Excel / Google Sheets.

Anyone can browse both catalogs and order kegs. Flip the toggle to let a client place Snack & Pantry orders. New signups start OFF. 🗄 Archive retires old or test accounts from every client list — nothing is deleted.

Every line-cleaning client with when they were last cleaned and when they're due. ✅ Mark Cleaned resets the timer to today + the client's interval and logs the visit in one click — open a client to add tech / notes / parts or see full history. (Coffee-machine service gets its own section here later.)

Full-management clients get a weekly visit program: visit days (Mon delivery, Thu restock…) each with a checklist built from the shared step library. The route board auto-fills the visits every week — attached to the client's delivery stop when they have one, otherwise as their own ⭐ stop — and drivers check off / flag / N/A each step in Run mode. Flags ping the ops Slack channel and show on the next visit.

After each weekly list, click Update from latest list below to load the new codes — no SQL needed. Edit a row here only for one-off fixes. Each brewery's code covers all of its kegs and goes into the Google Sheet as-is; the special code self means the brewery self-distributes, so the sheet shows the brewery's own name.

Upload the latest Master Pantry / Snack Sheet (.xlsx). You'll see exactly what changes — added, removed, price changes, and how everything is categorized — before anything goes live. Nothing changes until you click Publish, and you can roll back to any previous version below.