Sample data. This is the unedited report Inventory Planner produced on its bundled sample files, which describe a fictional business, run the same way a subscriber's upload is run (as of 2026-10-14). No AI model and no person touched it. Your own results depend on the exports you upload.
The full download also contains: overstock.csv, purchase_orders/northwind-apparel.csv, purchase_orders/pacific-bottle-co.csv, purchase_orders/unassigned.csv, reorder.csv, report.html.
Inventory reorder plan
As of Oct 14, 2026. Based on 90 days of sales (Jul 16, 2026 to Oct 13, 2026) and stock for 9 SKUs.
Summary
- Order now: 3 SKUs, 231 units, about $1,000.80 plus 1 SKU with no cost on file.
- Order this week: 1 more SKU, 36 units, about $225.00.
- 2 SKUs will sell out before a new order could arrive (within the supplier lead time).
- 2 SKUs are out of stock now, 1 of them still selling.
- $1,132.50 of cash is tied up in overstock (2 SKUs with more than 180 days of stock or no recent sales).
Also: 1 SKU sold recently but is not in your stock file (see below).
Order now
These run out before a new order would arrive, or are already out. Order them today. Order quantities cover the lead time, your safety buffer and 30 days of sales, rounded up to full cases where known.
| SKU | Product | On hand | Incoming | Sold per day | Days left | Runs out | Order qty | Supplier | Est. cost |
|---|---|---|---|---|---|---|---|---|---|
| TEE-BLK-M | Classic Tee - Black / M | 10 | 0 | 2.60 | 3.8 | 2026-10-17 | 144 | Northwind Apparel | $900.00 |
| AMZ-LID-SET | Bottle Lid Set | 10 | 0 | 0.73 | 14 | 2026-10-27 | 48 | Pacific Bottle Co. | $100.80 |
| HAT-NAVY | Navy Cap | 0 | 0 | 0.76 | 0 | 2026-10-14 | 39 | Unassigned | - |
Order this week
These reach their order-by date within the next 7 days.
| SKU | Product | On hand | Incoming | Sold per day | Days left | Runs out | Order by | Order qty | Supplier | Est. cost |
|---|---|---|---|---|---|---|---|---|---|---|
| TEE-WHT-M | Classic Tee - White / M | 32 | 0 | 1.00 | 32 | 2026-11-15 | 2026-10-18 | 36 | Northwind Apparel | $225.00 |
Purchase orders
One file per supplier with everything to order now or this week. These are drafts for you to check and send; nothing has been sent to anyone.
| Supplier | SKUs | Units | Est. cost | Order by | File |
|---|---|---|---|---|---|
| Northwind Apparel | 2 | 180 | $1,125.00 | today | purchase_orders/northwind-apparel.csv |
| Pacific Bottle Co. | 1 | 48 | $100.80 | today | purchase_orders/pacific-bottle-co.csv |
| Unassigned | 1 | 39 | unknown | today | purchase_orders/unassigned.csv |
Unassigned means we could not find a supplier for that SKU. Add it to your supplier file to have it grouped correctly next time.
Out of stock now
| SKU | Product | On hand | Incoming | Sold per day | Status |
|---|---|---|---|---|---|
| HAT-NAVY | Navy Cap | 0 | 0 | 0.76 | Order now |
| STICKER-PK | Sticker Pack | 0 | 0 | 0.00 | Out of stock |
Overstock and items not selling
Stock that will take more than 180 days to sell at the current pace, or that has not sold in the last 90 days. Excess is everything beyond 180 days of sales. Consider pausing reorders, bundling or discounting these.
| SKU | Product | On hand | Sold per day | Days of stock | Excess units | Cash tied up |
|---|---|---|---|---|---|---|
| MUG-11OZ | Logo Mug 11oz | 300 | 0.50 | 600 | 210 | $840.00 |
| CANDLE-LAV | Lavender Candle | 45 | 0.00 | no sales | 45 | $292.50 |
Sold but not in your stock file
These sold in the sales window but we found no matching SKU or product name in your inventory export, so we cannot say whether to reorder. Check the SKU spelling or include them in the inventory export.
| SKU | Product | Sold (30 days) | Sold (90 days) | Sold per day |
|---|---|---|---|---|
| POSTER-A2 | Poster A2 - Skyline | 3 | 9 | 0.10 |
All SKUs by status
| Status | SKUs |
|---|---|
| Order now | 3 |
| Order this week | 1 |
| Out of stock | 1 |
| Not in stock file | 1 |
| OK | 2 |
| Overstock | 1 |
| No recent sales | 1 |
Every SKU with all of its numbers is in reorder.csv. Overstock is in overstock.csv.
How the numbers are worked out
Sales window: Jul 16, 2026 to Oct 13, 2026 (90 days), ending on the latest sale in your files. Cancelled, refunded and voided orders are left out.
Sold per day = 60% of the daily rate over the last 30 days plus 40% of the daily rate over all 90 days, so recent changes count more without overreacting to one week.
Days left = (on hand + incoming) / sold per day. Runs out = as-of date + days left. Order by = runs-out date minus lead time minus safety days.
Order qty = sold per day x (lead time + 30 days of cover + 7 safety days), minus what is on hand and incoming, rounded up to full cases and the minimum order where your supplier file gives them. Reorder point = sold per day x (lead time + safety days).
Lead time comes from your supplier file where it lists the SKU, otherwise 14 days. Stock is summed across all locations and files; incoming or inbound stock counts as available.
What we read
| File | Read as | Rows | Used | Skipped | Notes |
|---|---|---|---|---|---|
| amazon_all_orders.csv | Amazon orders | 121 | 120 | 1 | cancelled, refunded or failed order: 1 |
| shopify_orders_export.csv | Shopify orders | 408 | 404 | 4 | cancelled, refunded or failed order: 3; date missing or unreadable: 1 |
| shopify_orders_october.csv | Shopify orders | 11 | 0 | 11 | exact duplicate of a row already read: 11 |
| amazon_fba_inventory.csv | Amazon FBA inventory | 2 | 2 | 0 | - |
| shopify_inventory_export.csv | Shopify inventory | 14 | 14 | 0 | - |
| supplier_list.csv | Supplier list | 7 | 7 | 0 | - |
Limits: this assumes recent sales continue at the same pace. It does not know about seasonality, promotions, or incoming stock arriving late, and items that were out of stock during the window may look slower than their real demand.