StoreCashierDocumentation Free 1.6.6 Pro 1.5.6 Apps 1.5.0

Low stock & reorder FREE PRO

StoreCashier warns you before you run out: the product list colours low stock, the POS shows a low-stock badge, and the Low Stock / Reorder Report lists every item at or below its alert level per location — with average daily sales, days of cover, a suggested reorder quantity and the last supplier.

Where: Reports → Low Stock / Reorder Report (admin.php?page=storecashier-reports&view=low_stock)

Which threshold is used where#

PlaceThresholdSet it in
Low Stock / Reorder Report, dashboard Low Stock Alerts tile and tableOne shared rule, compared with the stock per location: the product's StoreCashier alert quantity when it has one (above 0); else the WooCommerce "Low stock threshold" of the variation, then of the parent product; else the store-wide WooCommerce low-stock amount (default 2).Product editor → Inventory → Low stock threshold (per product or variation); WooCommerce → Settings → Products → Inventory → "Low stock threshold" for the store-wide value (the setup wizard also sets it)
All Products list (Stock pill)The product's own WooCommerce "Low stock threshold", else the store-wide one; compared with the total of all locations.Product editor → Inventory → Low stock threshold
POS product tiles"Low-stock badge at or below" (default 5).Settings → Orders & POS
WooCommerce e-mailsWooCommerce's own low-stock / out-of-stock notifications on the synced total.WooCommerce → Settings → Products → Inventory

Only products that track stock ("Manage stock" on) are checked.

Orders and POS settings with the low-stock badge threshold
Settings → Orders & POS: "Low-stock badge at or below" for the POS tiles.

Low Stock / Reorder Report#

Low Stock and Reorder Report with counters and suggested reorder quantities
Low Stock / Reorder Report.

Counters: Low stock items, Out of stock (zero or below), Estimated reorder cost. The New Purchase button opens a new purchase. The location filter on top limits the report to one location.

ColumnHow it is calculated
Product, SKU, LocationOne row per product/variation and location that is at or below the threshold. Lowest stock first.
In stockCurrent ledger quantity at that location.
Alert qtyThe threshold that applied to this row (alert quantity, product / variation low-stock threshold or the store-wide amount — see the table above).
Avg. daily sales (30d)Quantity sold at that location in the last 30 days ÷ 30.
Days of coverHow many days the current stock lasts at that sales speed.
Suggested reorderEnough to cover 30 days of sales or twice the alert quantity, whichever is larger, minus what you have.
Last costUnit cost on the latest purchase (else the purchase price).
Reorder valueSuggested reorder × last cost.
Last supplierSupplier of the latest purchase (links to the supplier).

When nothing is low: "Nothing to reorder — every tracked product is above its alert quantity."

How to reorder in five minutes#

  1. Open the report and filter by your location.
  2. Group the rows by Last supplier.
  3. Click New Purchase, choose the supplier, set status Ordered, add the products with the suggested quantities and save. Ordered purchases do not add stock yet.
  4. Print or send the purchase order. When the goods arrive, edit the purchase (or use "Mark as Received").

Another branch has plenty? Use a stock transfer or a branch stock request instead of buying.

Dashboard#

The dashboard "Low Stock Alerts" tile and table use exactly the same rule as this report, so the tile count equals the number of report rows (for the locations you may see). The table lists the 12 lowest rows and its "Alert Qty" column shows the threshold that applied. Open this report for the full list with reorder suggestions.

Permissions#

Reports permission. Staff restricted to locations only see those locations.

Why is a product missing from the report although it has only 3 left?

The report checks each location separately against the product's threshold: its alert quantity, else its own (or its parent's) WooCommerce "Low stock threshold", else the store-wide amount (default 2). Set a "Low stock threshold" on the product (or raise the store-wide one), and check that the product has "Manage stock" on.