Inventory Manager
Know what to reorder and what is dead stock from a pasted spreadsheet
The problem
Most small retailers and wholesalers reorder by gut feel: walk the shelf, notice a gap, phone the supplier. The result is predictable. Best sellers run out during the exact weeks they sell hardest, while the back room holds thousands of dollars of product that hasn't moved since last year. The data to fix this already sits in your POS export. Nobody has time to do the math on it.
The tool
Once installed, this skill turns your AI assistant into an inventory analyst that knows your supplier lead times, order minimums, and how you'd rather err (a stockout versus an overstuffed back room). Paste in a sales and stock export and it does the arithmetic you never get to: reorder points per item with every assumption stated, and a dead stock list with an estimated carrying cost attached to each slow mover.
Before: reordering happens when a shelf looks empty, and dead stock is invisible because it's paid for. After: a reorder-now list sized against your actual lead times, a ranked stockout-risk warning for the items where the margin loss would hurt most, and a dead stock report that prices the problem ("these 14 SKUs tie up about $6,200 and cost you roughly $95 a month to hold"). It is blunt about its limits: it sees only what you paste, it is not connected to your POS, and it will tell you when the data is too thin to trust.
What's inside
- Reorder points per item with the arithmetic and every assumption shown
- Dead stock flags with an estimated monthly carrying cost per item
- A reorder-now list sized against supplier lead times and order minimums
- Stockout-risk warnings ranked by the margin actually at risk
- Data quality checks that catch gaps before they become bad decisions
- A plain-English monthly inventory summary you can read in three minutes
How to use it
- 1Click "Install skill" on this page and copy the install prompt.
- 2Paste it into your AI assistant (Claude, ChatGPT, Cursor. Anything that can fetch a URL or accept pasted text).
- 3Answer the setup questions about your suppliers, lead times, and storage costs.
- 4Export sales by item for the last 8 to 12 weeks plus current stock on hand, and paste both in.
- 5Review the reorder-now list against what you know (a promo, a season ending) before placing orders.
- 6Repeat monthly. The more history it has seen, the better its seasonal sanity checks get.
Example
Say you run a bike shop with about 400 SKUs. You paste a 12-week sales export and current stock counts. Output (condensed): "Reorder now: floor pumps. You sell 9 a week on average, your supplier takes 3 weeks, and you have 21 left. That covers about 2.3 weeks, so you'd likely run out before the order lands. Suggested order: 40 units (assumption: demand holds and lead time stays 3 weeks; both stated below). Dead stock: 11 SKUs with zero sales in 12 weeks, tying up about $3,800 at cost. At your stated 1.5% monthly holding estimate that is roughly $57 a month to keep them. Candidates for a clearance bin: the three oldest. Data note: your export has no costs for 6 SKUs, so they're excluded from the carrying-cost math."
Pro tip
Paste one export from the same period last year alongside the current one. Reorder math built on the last 8 weeks is blind to seasonality, and a single year-ago snapshot is often enough for the skill to say "this item looks dead now but sold 30 units last November, hold it until December."
Related tools
Want this customized and automated for your business?
We take the tools in this toolbox and wire them into your business: your data, your brand voice, running on autopilot.
Talk to Vexlo