What a Good Weekly Cannabis Reorder Report Contains

A cannabis reorder report answers one question each week: how much of each product should each store order right now? Brands selling wholesale into dispensaries use it to suggest orders to buyers, and dispensary buyers use it to place their own. Done well, it is a short, checked list that a buyer can approve in minutes. Done poorly, it doubles orders, misses stockouts and erodes trust in every number on the page.

This guide covers what goes into a good weekly report, the math behind each line, the errors that inflate orders and the checks we run before anything reaches a buyer. For the underlying formulas (sell-through, days on hand, reorder points and par levels), see our guide to cannabis sell-through and reorder points.

The Inputs a Cannabis Reorder Report Needs

Every reorder line is built from a handful of inputs. If any one is missing or stale, the recommendation is wrong, so it helps to list them and where each comes from.

• Sales by store and SKU. Units sold per store, per product, for a fixed lookback window such as the last four weeks.
• On-hand inventory. Current units on the shelf and in the back room at each store, with the date of the count.
• Open and incoming orders. Orders placed but not yet received, by store and SKU, with their status and expected delivery date.
• Case packs. The unit multiple each product ships in, such as 10, 12 or 24.
• Minimums. Any minimum order quantity, minimum order value or delivery minimum that applies to the store or route.

In Oklahoma, licensed businesses track inventory in Metrc, the state’s seed-to-sale system, so on-hand figures should agree with what the business reports there. Product under an OMMA embargo cannot be sold or transferred, so it should not count as sellable stock in the report. Our OMMA and Metrc inventory checklist covers the count controls in more detail.

The Core Reorder Math

The calculation is the same for a dispensary reorder report and for wholesale reorder planning in cannabis. Only the source of the data changes.

1. Weekly velocity = units sold in the lookback window ÷ number of weeks in the window.
2. Weeks of cover = (on hand + on order) ÷ weekly velocity.
3. Target stock = weekly velocity × target weeks of cover. The target usually equals lead time plus the gap until the next order plus a safety buffer, all in weeks.
4. Need = target stock − on hand − on order. If the result is zero or negative, there is no order.
5. Suggested order = need rounded up to the next full case pack, then checked against any minimums.

Rounding up to the case pack matters because a store cannot receive 30 units of a product that ships in 12s. Rounding up means the store gets 36 and carries a few extra units, which is usually better than rounding down into a stockout.

Worked Example: A Weekly Cannabis Reorder Report

The table below uses invented numbers for two fictional stores and three fictional SKUs. It assumes a four-week sales window and a target of three weeks of cover (one week lead time, one week until the next order, one week of buffer).

Store / SKU (fictional)	Sold (4 wks)	Weekly velocity	On hand	On order	Weeks of cover	Target (3 wks)	Need	Case pack	Suggested order	Status
Store A / Vape cart 1g	96	24	30	12	1.8	72	30	12	36	Reorder
Store A / Gummies 10-pack	32	8	40	0	5.0	24	−16	12	0	Hold
Store B / Pre-roll 5-pack	60	15	0	24	1.6	45	21	10	30	Check

The vape cart needs 30 units, which rounds up to three cases of 12. The gummies have five weeks of cover against a three-week target, so they hold. The pre-roll math says to order 30, but an on-hand count of exactly zero on a product that sold 15 a week is worth confirming first. It could be a true stockout, or it could be a missed count or a product name that did not match.

Net Open Orders So You Don’t Order Twice

The most expensive reorder mistake is ordering the same units twice. It happens when last week’s order has not arrived yet and this week’s report ignores it. The store sees low stock, orders again, and two deliveries land within days of each other.

Subtracting on-order units from need prevents this, but only if the open-order list is accurate. Before each run, confirm three things:

• Every order placed since the last run appears in the open-order list.
• Orders that have been delivered are closed and are now counted in on-hand instead.
• Cancelled or rejected orders are removed, so they do not hold back a real need.

Common Errors That Inflate Orders

Most bad suggestions trace back to problems in the source data. These are the errors we look for first in any cannabis inventory report.

• Duplicate rows in exports. A sales export that repeats a line (for example, after a re-sync or a report that spans two date ranges) doubles velocity, and the order doubles with it.
• Stale on-hand counts. A count from last Tuesday makes stock look higher or lower than it is. Always carry the count date into the report and flag counts older than your cutoff.
• Delivered orders still counted as open. If a delivery has been received but the order is still marked open, those units are counted twice, once in on-hand and once on order. This error deflates orders and can cause stockouts.
• Inconsistent product names across systems. The same SKU might be “Vape Cart 1g Citrus” in the point of sale system and “1G CART - CITRUS” in the wholesale system. If they do not join, sales land on one row and inventory on another, and the report shows a phantom need. A maintained mapping table from each system’s name or ID to one master SKU fixes this.

Checks to Run Before Sending

A reorder report should be verified every week before it reaches a buyer. These checks take minutes and catch nearly all of the errors above.

1. Row counts. Compare the number of store and SKU rows to last week. A sudden jump or drop usually means a broken join or a missing export.
2. Duplicate keys. Each store and SKU pair should appear exactly once. Any duplicate is a stop-and-fix.
3. Totals by store reconcile to source. Units sold and units on hand per store should match the totals in the original exports. If they do not, something was dropped or doubled.
4. Unmapped products. List any product name that did not match the master SKU table, and resolve it before sending.
5. A second independent rebuild. Rebuild the suggested orders a second way, such as a separate script or a fresh spreadsheet from the raw exports, and confirm both versions agree line by line.

What the Buyer-Facing Output Should Look Like

The buyer does not need every column from the working file. A clean, buyer-facing reorder sheet shows store, SKU, weekly velocity, on hand, on order, suggested order and one status column with three values:

• Reorder. The math is clean and the order is ready to approve.
• Hold. On hand plus on order already covers the target. No order this week.
• Check. The math produced a number, but something looks off (a zero count, an old count date or an unmapped product). A short note says what to confirm.

Sort reorders to the top, keep notes to one line, and include the data dates so the buyer knows how fresh the numbers are. For brands, sending this sheet with the math visible makes a suggested order easier to accept, because the buyer can see exactly why it says 36 and not 72.

How We Help

Our team builds checked weekly reorder and inventory reports for licensed cannabis brands, distributors and dispensaries in Oklahoma and California, including the data mapping and verification steps described here. Learn more about our cannabis operations service.

Frequently Asked Questions