Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Reorder List: What to Order from Your Stock Exports

    1

    What to reorder today and how many, from your stock and sales exports (Tally, Excel, CSV)

    Free

    2 usesSecurity scanned
    Reorder List: What to Order from Your Stock Exports

    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.

    ProductStatusOn handDays leftOrder qtyLost sales/day
    Tata Tea Gold 500gOut of stock00.0504₹3,422
    Lays Classic 52gOut of stock00.0337₹153
    Parle-G 800gReorder now283.1370
    Maggi Noodles 12pkReorder now343.9354
    Surf Excel 1kgReorder now284.3258
    Fortune Sunflower Oil 1LReorder now405.4289
    Tata Salt 1kgReorder now766.0482

    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

    Generated

    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.

    • 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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    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 forever

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 27 days ago

    • Free with an Agensi account

    Requires

    Python 3.10+
    pandas
    openpyxl

    Permissions

    Terminal / Shell
    Read Files
    Write Files

    File Scopes

    *.xlsx
    *.csv
    *.json

    Reads the stock and sales files you give it and writes reorder_list.csv and summary.json in the working folder. No network access.

    Listed27 days ago

    What's inside

    Frequently Asked Questions

    Any Excel or CSV export with product names, stock quantities, and dated sales: Tally, Vyapar, Zoho, Shopify, POS systems or your own sheet.

    Yes, just tell the agent (for example "my supplier takes 14 days").

    No. The script runs on your files in the agent's own code environment, with no network access.

    New in Business & Operations