Out of Stock Dashboard

Executive Summary

Inventory → Out of Stock is a dashboard that quantifies, per product, how many days it was treated as out of stock within a selected date range. Its purpose is to surface products with repeated or prolonged stockouts so you can take corrective action, such as adjusting replenishment plans, validating sales velocity assumptions, or tuning product-specific out-of-stock thresholds. The page is designed as an analytical view of historical daily balances rather than a real-time “current inventory” screen.

Access note: This page is feature-gated behind Inventory Dashboard. If your account does not include access, the page is displayed behind an upgrade/blur wrapper instead of the interactive dashboard.

Key Concepts & Metrics

Days Out of Stock

Days Out of Stock is the number of distinct days in your selected period where a product’s daily starting inventory balance met the system’s out-of-stock condition. It is not a continuous duration timer; it is a day-by-day count.

Out-of-Stock Threshold

The out-of-stock threshold is the balance level at or below which a product is treated as out of stock for a given day. The system determines this threshold per product using the following precedence:

1. If the product has a configured Out of Stock Threshold, that value is used.
2. Otherwise, the system uses the product’s sales velocity baseline.
3. If neither is available, the threshold falls back to 0.0.

This means a product can be counted as “out of stock” even when inventory is not zero, depending on the threshold.

Starting Balance

Starting Balance is the product’s beginning-of-day inventory balance used for daily evaluation. The system sums daily starting balances and compares the total to the product’s threshold.

Sales Velocity Baseline

The system computes a sales velocity baseline per product using a moving average approach. Multiple windows may exist (for example 7, 14, 30, 90 days), and the product payload may include several velocity values. Even though these values are available in the returned data, they are not currently displayed as a column in the Out of Stock table.

Marketplace Selection

Marketplace is selected as a single-choice filter on this page. The marketplace affects which inventory history is evaluated and which listing details (such as price currency and product presentation) are used for display.

Operational Logic

Date Window and Presets

The date range selector supports preset ranges and a custom range mode. Presets are defined as:

• 1 Month ($30$ days)
• 3 Months ($90$ days)
• 6 Months ($180$ days)
• 1 Year ($365$ days)
• Custom Range

For presets, the system computes the date range by subtracting the preset day count from “today.” For demo users, “today” is fixed to 2049-10-21.

The request uses date-only strings:

• dateFrom = YYYY-MM-DD
• dateTo = YYYY-MM-DD

Out-of-Stock Day Counting

For each product (grouped by ASIN), the system evaluates each day in the selected range using daily starting balances.

1. Load the product’s sales velocity baseline.
2. Load daily inventory balances between dateFrom and dateTo.
3. Group inventory by date and sum daily starting balances.
4. Determine the product’s out-of-stock threshold.
5. Count the number of days where the product is out of stock according to the rule below.

The out-of-stock condition is:

Where the threshold is:

Important implication: If a product does not have an explicit threshold configured, the system uses sales velocity as the default threshold. This means a day can be counted as out of stock when the starting balance is less than or equal to the sales velocity baseline, even when inventory is greater than zero.

Granularity

There is no granularity selector on the page. Internally, the calculation operates at daily granularity by grouping inventory data by date.

User Guide

Navigate and Confirm Access

1. Go to Inventory → Out of Stock.
2. If the page is interactive, you will see selectors at the top and the Out of Stock table beneath.
3. If the page is blurred behind an upgrade wrapper, your account does not have access to the Inventory Dashboard feature.

Use the Selectors

Set the Date Range

1. Open the date range selector.
2. Choose a preset range (1 Month, 3 Months, 6 Months, 1 Year) or select Custom Range.
3. If using Custom Range, pick the start and end dates.
4. Apply the selection to refresh the results.

What to expect:

• Presets compute a window ending at “today.”
• The request sent for this page uses date-only boundaries (YYYY-MM-DD), so results represent the set of days included by that date window.

Filter by Products

1. Open the Product selector.
2. Search for products and select one or more to narrow results.
3. Use Clear filters to remove the selection.

What to expect:

• If you select products, only those products are evaluated and returned.
• If you select none, the system evaluates all products in your organization.

Select a Marketplace

1. Open the marketplace selector.
2. Choose a single marketplace.

What to expect:

• Only one marketplace is used for the request on this page.
• The marketplace influences both inventory evaluation and which listing details are used to populate product display information.

Read the Out of Stock Table

Product Column

Each row represents one returned product. The Product cell typically includes:

• product image
• product name or display name
• ASIN and SKU badges (when available)

The Product cell also contains the primary drill action:

Adjust product KPI

Selecting Adjust product KPI navigates to the Products dictionary and opens the KPI view for that product using the following navigation parameters:

• productId
• openModal=true
• activeTab=kpi

This workflow is intended for reviewing and updating KPI-related configuration such as out-of-stock thresholds.

Price

Price is displayed using the product’s price amount and the product’s own price currency. This value is displayed as currency (amount plus symbol).

Days Out of Stock

Days Out of Stock shows the out-of-stock day count for the selected period.

Display behavior:

• If daysOutOfStock > 0, the value is shown as an alert-style badge (red) and displayed as X days.
• If daysOutOfStock = 0, the value is displayed in a success-style indicator (green) as 0 days.

Hover behavior for non-zero values:

• On hover, the UI switches to a percentage display computed as: $$\left(\frac{\text{daysOutOfStock}}{365}\right)\times 100$$ formatted to one decimal place.

Interpretation note: The hover percentage always uses a 365-day denominator, even when you select a shorter range such as 30 days. It should be treated as a standardized annualized-style reference rather than a percentage of the currently selected date range.

System Behaviors & FAQs

What happens when I change filters?

Changing any of the following triggers a refresh of the dataset and recomputation of daysOutOfStock:

• date range
• marketplace
• selected products

Results can change not only due to different inventory history, but also due to different product subsets and marketplace-specific inventory balances.

Why can a product be “out of stock” when inventory is not zero?

Because the default threshold can be the product’s sales velocity baseline. If the day’s starting balance is less than or equal to that threshold, the day is counted as out of stock.

Is Sales Velocity shown on the page?

Sales velocity values are included in the product data returned to the page, but the table column for Sales Velocity is currently not displayed because its rendering is commented out in the table configuration.

Why do I see currency in the marketplace selector, but currency does not affect the result?

The frontend includes a currency parameter in the request query string, but the backend endpoint does not consume a currency parameter for computing out-of-stock days. The computation is driven by inventory balances and thresholds rather than monetary fields.

Common Limits and Clarifications

Single Marketplace Only

This page is designed for a single marketplace selection. Even if the underlying selector state is an array, only the first selected marketplace is used for the out-of-stock request.

Not a Real-Time Stock Screen

This dashboard reports historical out-of-stock day counts based on daily starting balances within a selected window. It is intended for trend and operational analysis rather than real-time inventory monitoring.