- Home
- Skills
- Business & Operations
- Reorder List: What to Order from Your Stock Exports
Works with the AI Agents you already use
Reorder List: What to Order from Your Stock Exports
What to reorder today and how many, from your stock and sales exports (Tally, Excel, CSV)
Free
Reorder List: What to Order from Your Stock Exports
Example session with this skill installed
Here are my stock summary and sales register from Tally. What should I reorder?
- Read your context and instructions
- Compiled the reorder list
- Generated the data export
Summary
41 products checked, using the last 90 days of sales (to 30 Sep 2026).
2 are out of stock and 7 need reordering now. The two out-of-stock items are losing about ₹3,575 of sales a day.
| Product | Status | On hand | Days left | Order qty | Lost sales/day |
|---|---|---|---|---|---|
| Tata Tea Gold 500g | Out of stock | 0 | 0.0 | 504 | ₹3,422 |
| Lays Classic 52g | Out of stock | 0 | 0.0 | 337 | ₹153 |
| Parle-G 800g | Reorder now | 28 | 3.1 | 370 | |
| Maggi Noodles 12pk | Reorder now | 34 | 3.9 | 354 | |
| Surf Excel 1kg | Reorder now | 28 | 4.3 | 258 | |
| Fortune Sunflower Oil 1L | Reorder now | 40 | 5.4 | 289 | |
| Tata Salt 1kg | Reorder now | 76 | 6.0 | 482 |
Settings: lead time 7 days, safety stock 7 days, order for 30 days.
Worth checking: one stock row has a negative quantity (Vim Bar 3x200g, counted as 0), and one product sold recently isn't in the stock list, often a spelling difference between the two files.
Next steps
- Order Tata Tea Gold first: it is losing the most sales.
- Adjust quantities for pack sizes and supplier minimums.
- The full list for all 41 products is in reorder_list.csv.
reorder_list.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
For shops, distributors and online sellers. Give your agent a stock export and a sales history, from Tally, Vyapar, Zoho, Shopify, any POS or a hand-made spreadsheet, and ask "What should I reorder?"
You get:
- What is out of stock, sorted by the sales you're losing each day
- What will run out before new stock arrives, sorted by days of stock left
- How many to order for each item
- reorder_list.csv with every product, ready to send to a supplier
The numbers come from a script, not the model. Language models are fluent but unreliable at arithmetic, so a bundled Python script reads the files, works out average daily sales, days of stock left, reorder points and order quantities, and the agent only explains the result.
Handles messy real-world exports: header rows in the middle of the sheet, "Grand Total" lines, units like "12 Pcs", Indian number formats (1,23,456), day-first or month-first dates, and new products that only started selling recently.
Defaults: 7 days supplier lead time, 7 days safety stock, order for 30 days. Change any of them by just saying so.
Free and open source (MIT), with tests checked against hand-worked examples.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Business & Operations.
- It works from the stock and sales files you give it; it doesn't connect to Tally or any other software directly.
- Order quantities are a starting point: adjust them for pack sizes, supplier minimums and seasonal demand.
- Products are matched between the two files by code or name; a spelling difference can leave a product unmatched (the report lists these).
- Sales averages use the last 90 days by default, so very new or seasonal products need a human check.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
2 uses
Times used to date
Free to use
No account required to browse
Trust & safety
Security scan
Security scan passed 27 days ago
- Free with an Agensi account
- Software
Python 3.10+pandasopenpyxl
Permissions
File Scopes
Reads the stock and sales files you give it and writes reorder_list.csv and summary.json in the working folder. No network access.