When to use this: deciding what to stock — with data instead of gut feel. Needs an internet connection (it reads live sales history).
Steps — Demand Analytics
-
Open Reports → Demand Analytics. Click Reports in the left menu, then click Demand Analytics from the list.
On this image: 1 selects the demand window; 2 sorts or searches for products; 3 filters by stock status; 4 shows stock, daily demand, coverage, and status for each product; and 5 exports the report.
-
Pick a window. Choose 7d, 30d, or 90d to set how many days of sales history the numbers are based on.
-
Sort or search. Use the Sort dropdown (Lowest coverage first, Highest demand first, or Name A–Z), or type in the search box to find one product.
-
Read the summary chips. Four chips show how many products are critical, low, healthy, or no sales (in stock but nothing sold in the window — dead stock). Click a chip to filter the list to just that group; click it again to clear the filter.
-
Read a row. Each product shows its current stock, daily demand, and coverage — roughly how many days the current stock will last at the current sales pace. The Status column colour-codes the same thing the chips count.
Steps — Shortage Book
-
Open Reports → Shortage Book. Click Reports in the left menu, then click Shortage Book. This lists what customers asked for that you didn't have in stock (logged at the billing counter — see INV-08 for how an entry gets created).
On this image: 1 sets the date range and refreshes the list; 2 selects the shortage status; 3 starts purchase orders; 4 shows the supplier's requested items and quantities; 5 starts an order for that supplier; and 6 exports the list.
-
Pick a date range and a status. Use the From/To buttons, and the status dropdown: Pending, Ordered, Fulfilled, or All. Rows are grouped by the product's supplier.
-
Order from here. If your account can create purchase orders, you'll see a Create Purchase Orders button (top) and an Order from [Supplier] link on each supplier's group. Either opens the Order Assistant, pre-filled with that supplier's shortages — repeated requests for the same product are a strong sign to start stocking it.
In the Order Assistant: 1 shows the draft PO count and total; 2 identifies the supplier and product; 3 lets you review the quantity and rate; and 4 creates the draft after you confirm.
-
Export. In the Shortage Book, use Export CSV, Export Excel, or Export PDF at the top right. Demand Analytics shows Export CSV and Export Excel; its Export PDF button is disabled in the image.
Good to know
- If you don't see the Create Purchase Orders button, your account doesn't have purchase-order permission — ask your owner/admin, or place the order yourself another way.
- Feed both Demand Analytics and the Shortage Book into your next purchase order (→ PUR-02).