Track stock counts and get an email before an item runs out
Published 2026-10-27
Almost every small team keeps some kind of stock: products on a shelf, supplies in a closet, printed materials, spare devices, gift cards. The count usually lives in a spreadsheet that one person updates when they remember, and the first sign of trouble is someone reaching for an item that is not there. ChatGPT or Claude can help you work out a sensible reorder point for each item if you paste in the numbers. It cannot hold the numbers between chats, take updates from the people who use the items, or warn you on its own when one gets low.
What a chat cannot do alone
A chat forgets the count when the thread ends, so every question starts with pasting the list again. It has no form that a teammate can open to record what they took. It cannot check the counts on a schedule, and it cannot send an email to anyone. The warning still depends on someone opening the sheet and noticing.
What your assistant builds with Sails
Sails is a coding agent you connect over MCP, with cloud deployment built in. Your assistant writes the code and Sails runs it in the cloud. For stock tracking it builds a few small pieces.
A table of items, with a name, a location, the current count, a reorder point, a usual reorder quantity, and the supplier's name and email. A second table logs every change: which item, how many were added or removed, who made the change, and when.
A short form on your domain for updates. A teammate picks the item, enters how many they took or received, and submits. The handler writes the change to the log and adjusts the count, so the total always matches the history.
A scheduled job written as ordinary shell code with no model in the loop. Every weekday morning it reads the table, finds every item at or below its reorder point, and emails you one short list with the count, the usual quantity, and the supplier. If nothing is low, it sends nothing.
A small page that shows every item and its count, so anyone can check before they ask.
Why it works
The count lives in one table instead of one person's memory, and every change has a name and a time attached, so a wrong number is easy to trace. The morning email arrives only when something needs action. Because the history is stored, your assistant can read it in any later chat and tell you which items run out fastest or whether a reorder point is set too low.
Hand it off
Copy this into your assistant:
Add Sails from https://sails.app/start. Build a stock tracker on my domain. Keep a table of items with name, location, current count, reorder point, reorder quantity, and supplier name and email, plus a log table of every change with the item, the amount, who made it, and when. Host a short form where my team records items taken or received, and update the count from the log. Host a page that lists every item and its count. Write a weekday morning scheduled job in plain shell code with no model involved that emails me every item at or below its reorder point, and sends nothing when the list is empty. Ask me anything you need before you start.