Inventory Reorder Point Skill

What it catches

Proven on a labeled example

examples/trailhead-coffee-nov/ is a fictional coffee roaster: a 90-day Shopify-style orders export and a 9-SKU inventory snapshot with planted situations (a best seller 12 days from empty on a 21-day lead time, a negative count, a mug that hasn't sold since July, 400 days of white mugs, lumpy filter sales, a gift box not in inventory, a missing lead time). expected.json labels the order quantities (240 and 96, rounded to case packs) and ABC classes; the tests assert those, the reorder-point math, MOQ handling and service level.

What you get

Outputs in out/: purchase_suggestions.csv (what to order now, with cost), plan.csv (every SKU: ABC, XYZ, demand, safety stock, reorder point, cover), abc.csv, findings.csv, report.md, summary.json. Exit 0 = nothing urgent; 1 = something to order or fix now; 2 = an input problem.

Quick start

./run_tests.sh
python3 -m reorder --sales examples/trailhead-coffee-nov/orders_export.csv --inventory examples/trailhead-coffee-nov/inventory.csv \
  --as-of 2026-11-01 --name "Trailhead Coffee" --out out/

Inputs

• Sales lines CSV: date, SKU, quantity, optional price or revenue. Shopify > Orders > Export (Created at, Lineitem sku, Lineitem quantity, Lineitem price) works without mapping.
• Inventory CSV: SKU, On hand; optional Incoming/On order, Lead Time Days, Lead Time SD, Unit Cost, MOQ, Case Pack, Title. One row per SKU (sum locations first).

Use it from your agent

• Claude Code plugin: this folder is a plugin (.claude-plugin/plugin.json). Try it with claude --plugin-dir ./inventory-reorder-point-skill, or add the folder to your own plugin marketplace.
• Skill only: copy skills/inventory-reorder-point/ into ~/.claude/skills/ (or your agent's skills folder) and keep this folder where the agent can run python3 -m reorder.
• No agent: the CLI works on its own; --help lists every flag.

Honest limits

• Demand is the recent average and variability; seasonality, promotions and new products aren't forecast, so adjust those by hand.
• Lumpy SKUs are flagged because the normal-distribution safety stock is a rough guide for them.
• It doesn't create purchase orders or connect to Shopify; it writes the list.

Requirements

Python 3.9+ (tested on 3.10 and 3.13), no dependencies.

Format and license

Zip, 19 KB, v1.0, 14 files. Use and modify it for yourself and for clients you serve; no resale or redistribution of the kit itself. Full terms in LICENSE.txt.

FAQ

Shopify only?

No; any sales CSV with date, SKU and quantity works.

Seasonality?

Not forecast; adjust those SKUs by hand.

Does it create POs?

No; it writes the list.

How do I get the files?

Right after payment, Stripe’s confirmation page shows your download link.

Refunds?

Email hello@youraitools.co within 14 days if it doesn’t work and we can’t fix it.

Can I pay with crypto?

Yes. Pay the same price in USDC or USDT on Base, Ethereum, Arbitrum, Optimism, Polygon or Solana from the "Pay with crypto" button, with no account or KYC. We check the payment on-chain and show your download links as soon as it confirms.

Pairs well with

Related

• Shopify Payments Payout Reconciliation Skill
• Three-Way Match Skill
• All agent skills