How many days of stock are left: an automatic report
The report arrives on Monday morning: what runs out this week, what runs out in two, and how fast it has been selling. No file exports, no hand-written formulas.
How it works
- Monday at seven
The scenario runs on a schedule. The time and the days are yours to pick.
- Sales and stock
Oxta pulls current stock and recent sales from your CRM, shop or database.
- Report to chat
It works out how many days each line has left, sorts the worst first, and sends it to Telegram or email.
What you need to connect
- A source of stock and sales: CRM, shop or database.
- The chat or mailbox the report goes to.
- Optionally a threshold: how many days of cover counts as alarming.
What a run looks like
A report is where a silent failure costs the most: if the scenario quietly stopped counting, you find out when the shelf is empty.
So every run is kept in full: how many lines came from the CRM, which of them made the report, and why. If the source returned an empty list you get a warning, not an empty report.
What it costs
One report is one run, however many product lines it covers. A weekly report is about four runs a month, so the free tier covers it many times over.
The essentials, briefly
How is “days of cover” calculated?
Current stock divided by average daily sales over a period you choose. Both the period and the alarm threshold are configurable.
Can I get the report more often?
Yes, the schedule is free-form: daily, twice a week, working days only.
Can it go to a Google Sheet instead of a chat?
Yes — a chat and a sheet are simply different last steps of the same scenario.