✅All items are above reorder points
📉 Most frequently low stock
📦 Scans per day
🔁 Most reordered items
Recent scan log (from Google Sheets)
DateItemCountCategory
Month-end inventory report
Loading…
—
In stock
—
Low stock
—
Critical
Connection & store info
Update your Google Apps Script URL, API key, or manager contact details here.
📋 Google Sheets setup guide
Step 1 — Create a new Google Sheet. Add 3 tabs named exactly: Inventory, ScanLog, Settings.
Step 2 — In the Sheet, go to Extensions → Apps Script. Paste the Apps Script code (download below).
Step 3 — Click Deploy → New deployment → Web app. Set "Who has access" to Anyone. Copy the web app URL and paste it above.
Step 4 — Paste the URL into this app's settings and tap Save. That's it — all data flows through your sheet.
Manage inventory items