Inventory
Track items, counts, and low-stock alerts — searchable inventory with automatic unavailable-at-zero.
MangoApps
Overview
Stock runs out on a shelf, not in a spreadsheet. Inventory gives the person standing at that shelf a − / + button and a barcode scan on their phone, and the server applies each tap as a change rather than as an answer — so two people counting the same shelf at the same moment both get counted instead of one quietly overwriting the other. When a count reaches zero the item marks itself Unavailable and the people who need to know are told.
It is a Mini App, which means it is not a fixed product you have to live with. Underneath it is a real table, four saved views, two automation rules and a live board — so you can rename a column, add one, change what "low" means, or point the board somewhere else, without asking anyone to ship a release. Someone who only needs to report a number gets a single door that asks for the SKU and the count, and nothing else.
Highlights
Capabilities
Counting & Capture
-
− / + counter on the quantity field, in the grid, the item drawer, and on a phone
-
Simultaneous counts both land Each tap sends the change, not the total, applied under a row lock — two people counting one shelf can't overwrite each other. Counts floor at zero
-
Barcode and QR scanning into the SKU field from a phone camera
-
"Count stock" door — enter a SKU and how many are left, nothing else Usable by someone with no access to the item list; the confirmation names the item and shows the old and new count
-
A note on any count adjustment, saved to the item's history
-
Printable QR shelf labels that deep-link to the item on a phone
What It Tracks
-
Item, SKU, Category, Quantity on hand, Reorder point, Status, Expiry, Location
-
Category and Status as pick-lists Supplies · Equipment · Consumables · Other, and Available · Low stock · Unavailable
-
Per-item reorder point, so "low" means something different for gloves than for defibrillators
-
Expiry dates with a rolling "expiring soon" window that recomputes itself
-
Add your own fields, or rename and retire the ones that ship
Alerts & Automation
-
Zero quantity sets the item to Unavailable automatically
-
Low-stock alert when quantity falls to the item's reorder point
-
Both alerts notify in-app, never by email to outsiders A mini app's automations can only update a field, notify the person who filed the record, or open a task
-
Retune or switch off either rule without touching code
Views, Board & Access
-
Four saved views: Low stock, Out of stock, Expiring soon, Needs attention
-
A live board ranking what needs attention Pin it to a wall display or a dashboard
-
Search and filter the full list, on desktop or a phone
-
Import your existing list from CSV or Excel
-
Full change history per item — who changed what, old value to new Kept 180 days
-
Its own permissions It's a real app, so people can be given the counting door without the list, or the list without admin
Limits & Specs
-
Fields: 8 out of the box, editable and extendable
-
Saved views: 4 out of the box
-
Automation rules: 2 out of the box
-
QR labels per printed sheet: 120
-
Change history retention: 180 days
-
Runs on: Power Tables and Live Boards, enabled automatically when you turn Inventory on
-
Pricing: No separate charge — its rows bill on the Power Tables meter (per 1,000 rows stored per year)
Use cases
Resources
FAQ
The item sets itself to Unavailable and an alert goes to the people who need to know. Separately, a low-stock alert fires earlier — when quantity falls to that item's own reorder point — so "low" can mean five boxes of gloves and one of something you can't be without. Counts floor at zero rather than going negative, and both rules are ordinary automation rules you can retune or switch off.
Yes, and this is the main reason to stop doing it in a spreadsheet. The − / + buttons send the change rather than the resulting number, and the server applies it under a lock. If a shelf holds twelve and two people each tap − at the same moment, the result is ten, never eleven. Every adjustment is recorded with who made it and an optional note, kept for 180 days.
Yes. Inventory ships a "Count stock" door that asks for a SKU and how many are left, and nothing else — it can't browse, create, or retarget items. Because Inventory is a real app with its own permissions, you can give a frontline team that door alone. The confirmation names the item and shows the old and new count, so the person can see their number landed on the right thing.
You can change them. Inventory is a Mini App — underneath it is an ordinary table with saved views, automation rules, and a board, all of which you own once it's installed. Rename a field, add your own, change what counts as low, retire a view, point the board elsewhere. Renaming is always safe, because everything references fields by identity rather than by label.
A spreadsheet loses the concurrent-count race, has no permission boundary for the person who should only report a number, and can't alert anyone. Procurement is about ordering — suppliers, purchase orders, receiving. Inventory is about what's physically on the shelf right now and who touched it. Teams commonly run both.
There is no separate charge for Inventory. It runs on Power Tables and Live Boards, which are enabled automatically when you turn it on, and its rows bill on the Power Tables meter — pay-as-you-go per 1,000 rows stored per year, with no per-seat charge and no floor. A few thousand items costs a few dollars a year.