Skip to content
P2Lab Stats

Stock reports

The Stock reports live under P2Lab Stats → Products alongside the cross-sell / drill-down views, and answer the “what should I reorder, what’s stuck, what’s running out?” questions.

Every report follows the common chrome — chart, sortable table, filter sidebar, profile sidebar. Date range applies where it makes sense (e.g. dead stock = no sales in this range); stock-level views always show the current stock at query time.

Stock thresholds for the urgency tiers are configured under Settings → Plugins → P2Lab Stats → Reports → Stock (Configuration).

Stock overview

Section titled “Stock overview”

The landing report. A snapshot of the catalogue’s current inventory state.

KPI cards:

  • Total units in stock across the catalogue
  • In-stock products vs out-of-stock products
  • Stock value at current price (or purchase price, configurable)
  • Low-stock count — products under the configured low-stock threshold
  • Top-stock count — products above the configured overstock threshold

Table below the KPIs lists every product with current stock, price, units sold in the range and a “days of supply” derived from sales velocity.

Low stock

Section titled “Low stock”

Lists products at or below the configured low-stock threshold, grouped into urgency tiers:

TierThresholdWhat it means
Critical≤ low-stock thresholdRestock now
Warning≤ warning thresholdRestock soon
Approaching≤ approaching thresholdWatch this row

Each row shows current stock, threshold, units sold in the range, days of supply and the supplier (if filled in on the product).

Use cases:

  • Daily reorder checklist.
  • Identify chronically under-stocked products to raise the safety stock level.

Dead stock

Section titled “Dead stock”

Products that had no sales in the selected range but still have stock. The killer report for catalogue spring-cleaning.

Each row shows current stock, stock value, last-sold date and time-since-last-sale. Sort by stock value to find the worst capital sinks first.

Filters specific to this report:

  • Exclude products created in the range — newly added products legitimately have no sales yet.
  • Minimum stock to flag — ignore products with single units left.

Use cases:

  • Find candidates for clearance or discontinuation.
  • Compute the cash tied up in non-moving inventory.

Overstock

Section titled “Overstock”

Products with a days-of-supply greater than the configured overstock days-of-supply threshold. The opposite of low stock — too much inventory relative to demand.

Days of supply is computed from sales velocity in the range and current stock:

days_of_supply = current_stock / (units_sold_in_range / days_in_range)

Each row shows current stock, daily velocity, days of supply, stock value tied up.

Use cases:

  • Identify products to put on promotion to clear the warehouse.
  • Spot procurement / forecasting mistakes.

Depletion risk

Section titled “Depletion risk”

Forecasts which products are most likely to run out before they can be restocked. The complement to low stock — instead of “below threshold today” it’s “will be below threshold within N days at current velocity”.

Each row shows current stock, daily velocity, projected days until stock-out, lead time (if configured), and a risk badge (critical / warning / approaching).

Use cases:

  • Place reorders before products go out of stock.
  • Spot a slow trend turning into a fast one.

Tips & gotchas

Section titled “Tips & gotchas”
Section titled “Related”