Inventory Stock Panel

Executive Summary

The Stock Panel is the core working area of the Inventory page. It provides two complementary views of the same catalog so you can both (1) prevent stockouts by monitoring what you have and how fast it is selling, and (2) reduce avoidable fees and operational risk by understanding Amazon inventory health signals (age, storage, inbound/reserved status, and surcharge exposure). The panel is organized as two tabs—Inventory Level and Inventory Health—and the page URL preserves the selected tab so a refresh or shared link reopens the same view.

Note: The Inventory page (including the Stock Panel) is available only when Inventory Dashboard is enabled for your workspace.

Key Concepts & Metrics

Stock Panel tabs

The Stock Panel offers two tabs that show different tables and different decision workflows.

• Inventory Level focuses on “do we have enough stock, and when do we need to replenish?”
• Inventory Health focuses on “is our stock in a good state, and are we heading toward storage/age-related fees or constraints?”

Marketplace

Marketplace determines which Amazon marketplace listing context is used for product display and inventory values. It also controls which marketplace-specific health snapshot you are reviewing in Inventory Health.

Condition

Condition determines which condition bucket the system uses when calculating and filtering inventory.

• In Inventory Level, condition is chosen from a detailed list (for example New, Like New, Very Good).
• In Inventory Health, condition is chosen from a simplified set (New, Used, All).

Because condition can change which SKUs are included in calculations, switching condition can meaningfully change both totals and per-product results.

AMZ quantity and AWD quantity

• AMZ represents Amazon-fulfilled inventory availability for the product.
• AWD represents Amazon Warehousing & Distribution on-hand quantity for the product.

These two sources are shown side-by-side in Inventory Level so you can distinguish sellable fulfillment availability from upstream storage.

Velocity

Velocity represents how quickly a product sells, expressed as an average rate over a selected time window (for example 7, 14, 30, 90 days, or 1 year). Velocity is used to:

• display Sales Performance, and
• drive projections such as Days Left.

Days Left

Days Left estimates how long current AMZ availability will last given the selected velocity window. It is presented as both a number and a qualitative status so you can quickly triage stockout risk.

Next Order

Next Order indicates whether a future replenishment is already scheduled and, when available, shows the expected date. This is used to spot gaps where a product is trending toward low stock without an inbound plan.

Price

Price is the marketplace-context price shown for the product, formatted in the marketplace currency.

Daily Revenue

Daily Revenue estimates the revenue generated per day using the 30-day sales velocity and the current price. It is primarily used to prioritize attention toward products where stock decisions have outsized impact.

Stock Value

Stock Value estimates the inventory value on hand across AMZ and AWD using your cost basis. It helps you identify where capital is currently tied up.

Health status and recommendation

In Inventory Health, Health is a product-level summary indicator derived from Amazon inventory health fields (for example sellable on-hand relative to recommended minimum levels, and signals related to excess or low supply). Health is shown as a compact badge with an explanatory tooltip.

On Hand, Recommended Minimum Level, Days of Supply, Total Days of Supply

These four values are displayed together under Health in Inventory Health:

• On Hand is the sellable on-hand quantity used for health assessment.
• Recommended Minimum Level is the recommended minimum inventory level.
• Days of Supply estimates how many days your on-hand inventory will last based on recent demand signals.
• Total Days of Supply extends the days-of-supply idea to include broader supply context, depending on the available health snapshot fields.

Stock status buckets

Inventory Health organizes inventory state into drillable buckets:

• Available: sellable available inventory.
• Inbound: incoming inventory, broken into sub-states (such as working, shipped, receiving).
• Reserved: inventory not currently sellable because it is reserved (with sub-reasons such as customer order or fulfillment center processing).
• Unfulfillable: inventory that is not sellable.

Sales Summary windows and Sell Through

Inventory Health includes sales summaries over multiple time windows (last 7/30/60/90 days) and Sell Through, allowing you to compare demand strength against supply posture.

Inventory Age buckets and low-inventory-level fee thresholds

Inventory Health includes Inventory Age buckets (0–30, 31–60, …, 365+ days) and additional fields that reflect low-inventory-level fee “minimum days of supply” thresholds (short-term and long-term).

Important behavior: Inventory Age is captured daily, while Available is captured in near real time. Temporary mismatches between age units and current availability can occur.

Storage volume and estimated storage cost

Inventory Health includes:

• Volume (with a measurement unit) and storage type, and
• Estimated Storage Cost Next Month when available.

AIS segments

Inventory Health includes estimated surcharge exposure segments for aged inventory (for example 181–210 days through 365+), showing both units and the estimated surcharge value for each segment.

Analysis action

Inventory Health includes an Action column that opens an analysis dialog intended to help interpret health signals and recommend next steps based on the product’s health context.

Operational Logic

Tab persistence in the URL

The selected tab is stored in the page URL so the same view reopens when you refresh, bookmark, or share the link.

• Inventory Level uses tab=list
• Inventory Health uses tab=health

Tip: If you routinely work from saved links, keep the tab value in the URL so you land directly on the table you need.

Inventory Level calculations

Days Left

Days Left is calculated using AMZ available quantity and the velocity window you selected in the Sales Performance header.

Where:

• $Q_{\text{AMZ}}$ is the AMZ available quantity
• $V_{\text{selected}}$ is the selected velocity (for example 7-day, 30-day, 1-year)

Days Left is also mapped to a qualitative risk status:

• Critical when $\text{Days Left} \le 30$
• Warning when $\text{Days Left} \le 60$
• Healthy otherwise

Daily Revenue

Daily Revenue uses the 30-day velocity and the current price.

Where:

• $V_{30}$ is 30-day sales velocity
• $P$ is the current price amount

Stock Value

Stock Value uses total stock across AMZ and AWD, multiplied by your cost basis.

The table header tooltip expresses this as: “Stock Value = Stock Quantity × COG Price.”

Inventory Health sorting behavior with selectable column fields

Several Inventory Health columns display multiple related values at once (for example, the Health column always shows On Hand, Recommended Minimum Level, Days of Supply, and Total Days of Supply). However, sorting is applied to the specific metric chosen in that column’s header dropdown. This enables you to keep the same visual layout while switching the “primary” value used for ranking.

User Guide

Accessing the Stock Panel

1. Open the Inventory page.
2. Confirm Inventory Dashboard is enabled for your workspace. If you do not see the Inventory page or Stock Panel, access is not currently enabled.
3. Use the Stock Panel tabs to switch between Inventory Level and Inventory Health.
4. To share a link that opens to the same tab, copy the page URL after selecting the tab. The URL preserves the selected tab value.

Inventory Level tab

When to use Inventory Level

Use Inventory Level when you are making replenishment and prioritization decisions, such as:

• identifying products likely to stock out soon,
• checking whether replenishment is already scheduled,
• evaluating velocity shifts and validating sales pace,
• prioritizing products by revenue impact or stock value exposure,
• reviewing inventory history for a specific product.

Reading the table

Product Name and identifiers

Each row represents a product and includes key identifiers used for validation and cross-checking:

• product image and product name (or shortened name),
• ASIN badge,
• SKU and display name indicators when available.

Search matches across product name, ASIN, SKU, and display name.

Days Left and risk status

Days Left is shown as a numeric badge and a qualitative status:

• use Critical to prioritize immediate replenishment action,
• use Warning to validate inbound plans and lead times,
• use Healthy to focus elsewhere unless there are other constraints (fees, storage, aging).

Available Quantity split (AMZ and AWD)

Inventory Level shows AMZ and AWD quantities side-by-side so you can distinguish:

• what is immediately available to fulfill orders (AMZ), versus
• what is stored upstream (AWD).

Next Order

Next Order shows the next scheduled replenishment date when available. If no replenishment is scheduled, the table displays Not scheduled so gaps stand out.

Sales Performance (Velocity)

Sales Performance shows:

• the selected velocity number, and
• the period label that defines that velocity.

Clicking the velocity cell opens a drill-in view to validate the sales pace over the chosen time range and granularity.

Price, Daily Revenue, and Stock Value

• Price provides the price context used for revenue estimates.
• Daily Revenue helps prioritize products where stock decisions affect near-term revenue the most.
• Stock Value highlights where capital is tied up across AMZ + AWD.

Inventory row action

The right-side action opens a product-specific inventory history dialog. The system retrieves the history only when you open the dialog, so you can scan the table first and drill in only when needed.

Common workflows

Filter by product condition

1. Open the Condition selector.

2. Choose one of the available options:

   • All Conditions
   • New
   • Like New
   • Very Good
   • Good
   • Acceptable
   • Poor
   • All Used

3. Review how Days Left, quantities, and economics change after applying the condition filter.

Search for a product

1. In Search product, enter a product name, ASIN, SKU, or display name.
2. Use the results to jump directly to a product for investigation or drill-in.

Sort and reset sorting

1. Click a sortable column header (such as Days Left, Next Order, Sales Performance, Price, Daily Revenue, or Stock Value).
2. Use the sort direction to rank products for action.
3. If you have applied sorting and want to return to the default order, select Reset Sorting.

Pin the Product column

1. In the Product column header, toggle the pin control.
2. Scroll horizontally to compare wide columns while keeping product identity visible.

Change the velocity window used for the table

1. In the Sales Performance header, select the desired time window (for example 7/14/30/90 days or 1 year).

2. Confirm the table updates:

   • Sales Performance reflects the new velocity, and
   • Days Left recalculates using the same selected velocity window.

Use the Velocity drill-in

1. Click a product’s Velocity cell.
2. Use the drill-in view to validate whether recent performance is consistent, trending, or seasonal.
3. Adjust granularity and the selected time range as needed to align the chart with your planning horizon.

Open the Inventory history dialog

1. Click the eye icon in the Inventory column.
2. Review inventory stock history for the product over the selected time range and granularity.
3. Use this history to validate stock movement patterns and reconcile perceived anomalies in availability.

Inventory Health tab

When to use Inventory Health

Use Inventory Health when you are managing operational risk and fee exposure, such as:

• identifying products with low supply relative to recommended minimum levels,
• diagnosing whether inventory is tied up as inbound, reserved, or unfulfillable,
• monitoring inventory aging and surcharge thresholds,
• evaluating storage volume and estimated storage cost,
• prioritizing remediation actions using health context.

Using the top controls

Snapshot date picker

1. Select the Snapshot date to choose the health snapshot you want to analyze.
2. Dates after yesterday are unavailable, which ensures you are reviewing a completed snapshot rather than a partial current day state.

Important behavior: You cannot select today or future dates in the snapshot picker.

Condition selector (New / Used / All)

1. Choose New, Used, or All.
2. Use this to isolate condition-specific health issues or confirm whether problems are isolated to used inventory.

Marketplace selector

1. Choose a single marketplace.
2. The table updates to reflect that marketplace’s health snapshot and listing context.

Search and Reset Sorting

• Use Search product to filter across product identifiers.
• Use Reset Sorting when you want to clear active sorting and return header field selections to their defaults.

Reading the table

Product Details (pinnable)

Each row includes:

• product identifiers (name, ASIN, SKU, display name),
• a Health badge (such as Healthy or N/A) with an explanatory tooltip.

Pin the column when comparing far-right fields such as Storage, AIS, or Action so you never lose track of which product you are reviewing.

Health (selectable field + sortable)

The Health column always displays:

• On Hand
• Recommended Minimum Level
• Days of Supply
• Total Days of Supply

Use the header dropdown to choose which of these values controls sorting. This is especially useful when you want to:

• rank by lowest Days of Supply to find urgent risks, or
• rank by highest Recommended Minimum Level to understand where Amazon expects deeper buffers.

Stock (selectable bucket + sortable + drillable details)

Choose one stock bucket in the header:

• Available
• Unfulfillable
• Inbound
• Reserved

Hovering the cell reveals a breakdown appropriate to the chosen bucket (for example inbound sub-states or reserved reasons). Use this to distinguish “we are low” from “we have stock but it is not currently sellable.”

Summary (selectable window + sortable + drillable details)

Choose one summary field in the header:

• Last 7 / 30 / 60 / 90 days
• Sell Through

Hover details include a multi-window grid so you can compare periods without switching the primary display repeatedly.

Age (selectable bucket + sortable)

Choose an age bucket or a fee threshold field:

• 0–30 through 365+ days
• Short Term Min.
• Long Term Min.

Use Age to identify products that may be drifting into older buckets and to prioritize sell-through actions before surcharges apply.

AIS (selectable segment + sortable + drillable details)

Choose an AIS segment (181–210 through 365+). The cell shows the selected segment’s AIS value and units, and hover details summarize all segments.

Storage (selectable field + sortable)

Choose:

• Volume, or
• Estimated Storage Cost Next Month

The cell also includes storage type context so you can distinguish different storage classifications.

Action (sticky right column)

Use Action to open the analysis dialog for a product and review recommendations derived from the product’s health context.

System Behaviors & FAQs

How do I share a link that opens to the right table?

Copy the URL after selecting your tab. The URL includes a tab value:

• tab=list opens Inventory Level
• tab=health opens Inventory Health

Why can’t I select today’s date in Inventory Health?

Inventory Health is designed around completed daily snapshots. Preventing selection of today avoids analyzing an incomplete day that may change as Amazon updates the snapshot.

Why do Inventory Age units sometimes not match Available?

Inventory Age is captured daily, while Available is captured in near real time. Temporary mismatches can occur until the next daily capture aligns the age snapshot with current availability.

What does “Not scheduled” mean in Next Order?

“Not scheduled” indicates there is no upcoming replenishment date available for the product in the current view. Use this in combination with Days Left to identify products approaching low stock without an inbound plan.

Does Days Left include AWD quantity?

Days Left uses AMZ available quantity and the selected velocity window. AWD is shown alongside AMZ for visibility, but it is not part of the Days Left calculation shown in the table.

When does the Inventory history dialog load data?

The system retrieves inventory history only when you open the dialog from the row action. This keeps the main table focused on scanning and prioritization, while still enabling deep investigation on demand.

Why does Reset Sorting appear in Inventory Health even if I didn’t sort?

Reset Sorting appears when either:

• sorting is active, or
• one of the selectable header fields (Health, Stock, Summary, Age, Storage, AIS) has been changed from its default selection.