AI Skill
Finance & Purchasing
Cannabis Replenishment Planner
Turn sales and on-hand exports into a reorder plan and a draft PO by vendor.
This is a starting template. Change the questions, thresholds and output to fit how you work. AI can make mistakes, so check the output before you act on it. Report an issue
The problem it solves
You reorder by gut feel, so best sellers stock out while dead stock ties up cash.
Upload a sales export and current on-hand, and the skill answers one question: what do I order this week? It calculates sell-through, days of supply and reorder points, rounds to case packs and groups the order into a draft PO by vendor.
Brands and distributors can run it on a retail account's sell-through data to plan what that account needs next. It never sends anything to a vendor.
What you'll need
Have these ready before you start.
- Sales export by SKU: date, product, units, revenue
- Current on-hand by SKU
- Vendor lead times and safety stock days
- Optional: open POs, unit cost and case pack sizes
- An AI assistant that can run Python, such as Claude
What the AI does
- Calculates units sold per day, days of supply and sell-through
- Sets reorder points and order quantities rounded to case packs
- Flags SKUs that sold out, where demand is understated
- Flags dead stock, new SKUs and missing lead times
- Lists every default you didn't set as an assumption to confirm
What you get
A reorder list and a PO draft by vendor. In a sample run on two months of sales with 3 days of safety stock, it recommended 3 SKUs for $4,620 across 3 vendors, flagged a sold-out live resin cart whose order was probably too low, found $350 at cost sitting in pre-rolls unsold for 40 days, and held one SKU with no vendor or lead time.
For brands and distributors, Distru keeps orders, inventory and account history together, so replenishment plans start from what each account actually bought.
Frequently Asked Questions
Let’s answer the most commonly asked questions about Cannabis Software.
How does the replenishment planner decide what to reorder?
It works out units sold per day, days of supply, sell-through and a reorder point for each SKU. Order quantities get rounded to case packs and grouped into a draft PO by vendor with total cost. In a sample run, it recommended 3 SKUs for $4,620 across 3 vendors.
Can brands and distributors use it?
Yes. Brands and distributors use it to plan replenishment for their retail accounts from those accounts' sell-through data. Any sales export by SKU works, including one pulled from a retailer's POS.
Does it place orders with vendors?
No. It builds a draft PO and stops there. Every default you didn't set, like the sales window, days of cover or dead stock threshold, is listed as an assumption to confirm before you order.
What does it flag besides reorders?
SKUs that sold out, since their demand is understated, plus dead stock tying up cash, new SKUs and missing lead times. In the sample run it found $350 at cost in pre-rolls unsold for 40 days and held one SKU with no vendor on file.
