Stock counts roll in, par levels get checked automatically, and reorder alerts go out before a location runs short.
Each location counted inventory by hand and compared it to what they needed by memory. Reorders were often placed late, or missed entirely — especially for slower-moving stock that nobody was tracking closely.
By the time a shortage showed up, it usually meant a rushed order or a substitution on the fly.
A script pulls in each location's current counts, compares them against par levels, and calculates exactly how much to reorder. If a location's numbers haven't been updated, or a reorder hasn't gone in by a set day of the week, it sends an alert automatically — so nothing gets missed at order time.
| Item | Par | On Hand | To Order | Alert | |
|---|---|---|---|---|---|
| 1 | Flour, 50lb | 40 | 34 | 6 | — |
| 2 | Butter, case | 18 | 5 | 13 | Reorder now |
| 3 | Eggs, flat | 25 | 20 | 5 | — |
| 4 | Sugar, 50lb | 30 | 9 | 21 | Reorder now |
| 5 | Cake boxes, 10" | 200 | 160 | 40 | By Thu |
Sample pattern, not real data. Item names and counts are illustrative.
Each location logs its current stock in a shared sheet.
Apps Script compares on-hand counts to what each item needs to stay stocked.
The reorder amount works out automatically, item by item.
If a count's missing or a location falls behind schedule, an alert fires automatically.