What is this
BeeStocked is the stock system for Smile Sensations' 4 clinics. It is a single file — no server, nothing running behind the scenes. Counts, orders and settings are saved on this device and can be exported as a file to share.
Two ways to count — pick whichever feels natural
| 📱 | On the phone — open the Count tab and tap + as you go, like a hand tally counter. Red = still missing, green = done, "None = 0" marks an empty shelf. The "Missing" button shows only what's left. |
|---|---|
| 🖨 | On paper — tap "Print count sheet" for a clean sheet with every product and how to count it. Count by hand as always, then photo every page and send it in — it gets entered here and the order comes out the same. |
The monthly flow
| 1 | Count — once a month. Pick your clinic, walk the categories (same order as the old paper sheets) and enter how many CLOSED units you see. Every product card shows a photo and tells you exactly what to count (boxes? syringes? packs?) — when in doubt, read the 📦 line. |
|---|---|
| 2 | Order — calculates itself with the same formula as the old Excel. Review, adjust quantities if needed, and click "Copy order" or "Email order" per supplier — or download the CSV. |
| 3 | Register order — when an order is actually sent to a supplier, click "Register as sent". It moves to the Receiving tab. |
| 4 | Receiving — when boxes arrive, open Receiving on a phone and tick each line off (this replaces printing and highlighting the Excel). Anything left unticked is a backorder — visible until it arrives, so nothing gets forgotten again. Items flagged EXPIRES ask for the expiry date on the box and remind you to store new stock at the back (first-in-first-out). |
Settings — the manager's control panel
The ⚙️ Settings tab is the "big spreadsheet" turned into simple switches. For each product, the manager can: turn it OFF (it vanishes from Count and Order in that clinic), tag it EXPIRY yes/no (only tagged items ask for a date at Receiving), and edit the 4-week target and price per clinic. Edited values show a ✎ and can be reset to the original with one tap. This is the configuration the whole system runs on — no spreadsheet editing needed.
The formula (same as the old Excel)
ORDER = round up ( 4-WEEK TARGET − COUNTED ), minimum 0COST = ORDER × UNIT PRICE
The 4-week targets come from your current Masters, per clinic (and can be edited in Settings). A red OUT means counted zero with a target above zero — the #1 pain (running out mid-treatment), so those float to the top.
Where the data comes from
The 4 clinic Excels consolidated: 308 products, 19 categories, 26 suppliers, enriched with photos, pack sizes and counting instructions researched from the Australian suppliers' own sites. . Same data in Excel: Master Catalog (Drive) · project folder.
Roadmap
| v0.5 | Today — counting, ordering, receiving, backorders, expiry capture and a manager Settings panel, all on this page. Try it, break it, tell us what's wrong. |
|---|---|
| v1 | Data lives in a Google Sheet (the source of truth). Counts save with date and history. Low-stock alerts via n8n. |
| v2 | Expiry dates captured by photo (Telegram + OCR) as well as by typing; expiry alerts before money is lost. Stock value per clinic over time. |
| v3 | Estimated consumption from D4W item-numbers reports; data-driven 4-week targets; procedure tags. |