The Inventory Screen

23 views 2

How to Navigate to the Inventory Screen?

  • Select the Products and Inventory Menu:
    • In the Inventory Menu Column, Click on Inventory

What is the Inventory Screen?

  • To review all Amazon inventory-related product attributes in one consolidated view
  • To assess current stock, inbound quantities, and reserved inventory in real time
  • To understand the age distribution of inventory, enabling aging stock management
  • To forecast stock-out dates using configurable sales velocities
  • To calculate optimal reorder dates and quantities based on demand and lead time
  • To estimate reorder capital requirements and profitability tied to existing inventory

Hints And Tips!

  • The primary data source for this screen is Amazon’s ‘Inventory Health’ report (SellerCentral: Reports → Inventory → Inventory Health)
  • Reorder calculations are done per SKU per marketplace; SellerLegend does not yet aggregate at parent ASIN or cross-marketplace level (feature in roadmap)
  • Inventory data is retrieved from Amazon every 8 hours, and the last retrieval is time-stamped next to the page title
  • Inventory rows are grouped by marketplace; one product may appear multiple times if sold in more than one region
  • The “Amazon Marketplace Selector” (top right, Amazon icon) controls which marketplaces are shown
  • Hidden products are excluded from this screen until re-enabled on the Products screen via the Actions menu

Screen Print

What Data Can I See in the Inventory Screen?(*) indicates feature not yet implemented

Product Image

  • Thumbnail image of the product
  • Click on the image to access the Product Modal for the product, which in turn links to the Product Dashboard, Inventory, and Product Statistics

Product Title (hidden by default)

  • Amazon listing title of the product

Account Title

  • SellerLegend account name associated with the product

Marketplace

  • Identifies the regional Amazon marketplace (e.g., US, UK, DE)
  • If the same product exists in more than one marketplace, then it will be repeated on a distinct row for each distinct marketplace
  • The marketplaces shown in the Inventory screen  is governed by the Marketplace Selector (the Amazon icon on the top right side of the taskbar)

SKU (hidden by default)

  • Stock Keeping Unit (seller-defined unique identifier)

FNSKU (hidden by default)

  • Fulfillment Network SKU (Amazon’s identifier for FBA units)

ASIN

  • Amazon Standard Identification Number
  • Clicking on the ASIN will take you to your product’s listing on the Amazon catalog
  • SellerLegend uses the short URL version of your ASIN to take you to the product listing.
  • Clicking on the ASIN, therefore, does not adversely impact your conversion rates.

Parent ASIN (hidden by default)

  • Identifier for the parent ASIN to which the product (if variation) belongs
  • Filtering by Parent ASIN reveals all child/variation listings

Is Parent

  • Indicates whether this product is a parent ASIN

Internal Name

Brand (hidden by default)

  • Manufacturer or brand name

Product Group

Tags

Condition

  • Product listing condition (New, Used, Refurbished, etc.)

In Stock

  • Source: Fulfillment Inventory API ((ListInventorySupply – real-time)
  • Total fulfillable units on hand for this product
  • Some units may be deemed Unfulfillable by Amazon

Inbound

  • Quantity in transit within Amazon’s logistics network (shipping plan created, not yet received)
  • Please note that inbound units are not fulfillable until they are received and therefore are not considered in the calculation of Days Inventory Left.

Reserved

  • Source: Reserved Inventory Report (near real-time)
  • Shows the number of units that are reserved
  • Hovering over the reserved quantity will show a pop-up with the
    • Number of units reserved to satisfy pending customer orders
    • Number of units reserved for Fulfillment Center Transfers (i.e., number of units Amazon is moving between their warehouses)
    • Number of units reserved for Fulfillment Center Processing
  •  Inventory in reserved status may be tied to a customer order, in the process of being shipped between fulfillment centers, or sidelined at a fulfillment center for additional processing.
  • Units can be in reserved status for the following reasons:
    • Customer Order
      • These units are being used to fulfil customer orders.
    • FC Transfer
      • These units are being transferred from one fulfillment center to another to place the inventory closer to customers.
      • Units in FC Transfer status are available for customers to buy.
      • Customers may be shown a future ship date if no other units are available for immediate fulfillment.
      • Transfers typically take 1-5 days to complete, but in some case may take up to 30 days.
    • FC Processing
      • These units have been sidelined at the Fulfillment Center for additional processing, such as verification of item dimensions and weight, or pending investigations.
      • Note: When inventory is being processed for transfer to another fulfillment center, units may temporarily appear under both FC Transfer and FC Processing.

Total Quantity

  • Sum of In Stock + Inbound + Reserved

Per Unit COGS

Inventory Tied Cost

  • The monetary value of the **Local Inventory (i.e. the number of fulfillable units in stock) **multiplied by the currently applicable COGS for this product
  • Clicking on the COGS amount will take you to the COGS entry screen for this product

Per Unit Price

  • Current product retail price (Amazon Listing Price)

Total Retail Value

  • Total Quantity × Per Unit Price (i.e. how much revenue the stock will yield if sold at the current price)

Estimated Profit Per Unit

  • Net profit per sale after deducting FBA fees, referral fees, and average PPC costs (configurable)

Total Cash Value

  • Total Quantity × Estimated Profit Per Unit

Local Inventory

  • Source: Multi-Country Inventory Report (near real-time)
  • Displays the actual fulfillable quantity per marketplace
  • Corrects Amazon’s default behavior of duplicating aggregate stock across regions
  • When a product is sold in multiple marketplaces, Amazon shows the stock levels in each marketplace as the sum of ALL units in ALL marketplaces.
  • For example, product A is sold in DE, UK, and IT. Say that DE holds 10 units, UK 22 units and IT 6 units. Amazon will show 38 units (10+22+6) available in EACH of DE, UK, and IT.
  • In contrast, the Local Inventory column shows you the correct ‘local’ marketplace number of units in each marketplace.
  • Please note that SellerLegend will use the Local Inventory as the basis for the Recommended Reorder Quantity and Recommended Reorder Date calculations.

In Transit

  • A number of units you know are in transit from the manufacturer to Amazon
  • You manually enter the arbitrary number of units in transit on the product’s Inventory Settings screen
  • The Recommended Reorder Quantity and Recommended Reorder Date calculations will then take the In Transit value into consideration

In Warehouse

  • The number of units you know are in a non-Amazon warehouse
  • You manually enter the arbitrary number of units in transit on the product’s Inventory Settings screen
  • The Recommended Reorder Quantity and Recommended Reorder Date calculations will then take the In Warehouse value into consideration

Age Level

  • The age spectrum of the inventory for this product
  • Hovering on the exclamation mark icon will show the age band of your inventory units
    • Up to 90 days
    • 91 days to 180 days
    • 181 days to 270 days
    • 271 days to 365 days
    • More than 365 days
  • The exclamation mark icon is colored from green to red depending on the maximum age band
  • To filter Age levels , use values from 1-5 :
    • Up to 90 days – 1
    • 91 days to 180 days – 2
    • 181 days to 270 days – 3
    • 271 days to 365 days – 4
    • More than 365 days – 5
  • The colored icon indicates the highest band with existing stock (green to red)

Velocity

  • The average number of units sold per day over the number of days specified by the date picker at the top right of the screen
  • Whether Out of Stock periods are accounted for or not in the calculations depends on the Inventory settings panel.
  • Learn how to manage inventory settings to calculate velocity

Out of Stock Days

  • Shows the number of days (out of the selected time period) that a product was out of stock.
  • Used in the calculation of velocity when the CONSIDER OUT OF STOCK IN VELOCITY checkbox in the Inventory Settings panel

Days of Inventory Left

  • Shows the number of days left before running out of stock
  • This is based on the chosen sales velocity as specified by the date picker at the top right of the screen
  • If there are units In Transit/In Warehouse, the Days Inventory Left value is preceded by an ‘Information’ icon, to remind you the calculation has taken the number of units in transit/warehouse into account. Make sure that the In Transit / In Warehouse values are still applicable.
  • Learn how to specify Product Inventory Settings

Recommended Reorder Date

  • Indicates the latest date at which you should reorder to avoid running out of stock
  • Calculated based on the Days Inventory Left minus the Restock Lead Time value specified in the product’s Inventory Settings
  • Learn how to specify Product Inventory Settings

Recommended Reorder Quantity

  • The calculated number of units to order on or before the Recommended Reorder Date to satisfy  the rules specified in the product’s Inventory Settings
  • Calculated based on the following values in the Products Inventory Settings
    • Number of Days of Cover
    • Chosen Sales Velocity
      • Today, Yesterday, 7d, 14d, 30d,  90d, 180d, This Month, Last Month, 3 Months, Last Year, YTD, One Year, custom date range
    • Minimum Order Quantity
    • Crate Quantity
    • Learn how to specify Product Inventory Settings

Capital Required

Unsellable

  • Number of units of a product in inventory that cannot be sold due to various reasons such as damage, expiration, or any other condition that makes them unfit for sale. These units are typically segregated from the sellable inventory and may require disposal, return to the supplier, or other forms of remediation.

Open Date

  • The date the product listing was first activated on Amazon
  • May reset if the product is reactivated after dormancy

Creation Date

  • The date on which the product was listed on Amazon (Open Date) OR when the first order for it was placed.
  • Basically, it’s the earlier one of the Open Date and the First Order Date for the product.
    • If the open date is 1st Nov 2019, and the first Order Date is actually 1st Oct 2019, then the Creation Date is set to 1st Oct, because the product has been selling since then.
  • Set to NULL if neither of the two dates is available.
  • The field is user-modifiable, so users can choose their own creation dates.
  • This will be used as the day from which the user wants velocity calculations to start.

Refunded

  • Number of units refunded

Refund %

  • (Refunded units / total sold units) × 100

Hidden Columns
Customizable view — columns that can be added back:

🔍 Key Insights & How To Derive Them

1. Stockout Risk

  • Insight: Which products are at imminent risk of going out of stock?

  • Rule:

    • Days of Inventory Left < Restock Lead Time

    • AND In Transit + In Warehouse not enough to bridge the gap

  • Follow-up: Check if a reorder has already been scheduled. Use Recommended Reorder Date and Quantity to take action.

2. Overstock / Capital Drain

  • Insight: Which products tie up the most capital but have slow turnover?

  • Rule:

    • Inventory Tied Cost is high

    • Velocity is low (e.g. < 0.2/day)

    • Age Level ≥ 3 (i.e. oldest stock band is 181+ days)

  • Follow-up: Run promotions, reprice, or consider liquidation.

3. Profitability vs. Exposure

  • Insight: Which products yield poor returns relative to the cost tied up?

  • Rule:

    • Estimated Profit Per Unit is low or negative

    • AND Total Cash Value is low relative to Inventory Tied Cost

  • Follow-up: Audit COGS, check for FBA overcharges, reduce PPC spending.

4. Phantom Inventory / Misleading Stock Visibility

  • Insight: Is Amazon showing inflated inventory across regions?

  • Rule:

    • Compare Local Inventory (actual) vs what Amazon shows in seller central

    • If Local Inventory differs from In Stock in other marketplaces → review cross-marketplace duplication logic

5. Inventory Aging & Long-Term Storage Fees Risk

  • Insight: What inventory is likely to incur Amazon’s long-term storage fees (LTSF)?

  • Rule:

    • Age Level = 4 or 5

    • AND Velocity is very low or Out of Stock Days = 0 (i.e., always in stock but not selling)

  • Follow-up: Consider removal orders or liquidation.

6. Refund Risk & Product Quality Flags

  • Insight: Are there products with high refund rates indicating quality issues?

  • Rule:

    • Refund % > 5–10%

    • AND Unsellable inventory is non-zero

  • Follow-up: Audit customer feedback, review prep/packaging, investigate supplier defects.

7. Inbound Stock Planning Gap

  • Insight: Are any fast-moving products lacking incoming replenishment?

  • Rule:

    • Velocity is high (e.g. > 5/day)

    • Inbound = 0

    • AND Days of Inventory Left < 10

  • Follow-up: Prioritize PO or expedite shipments.

8. Manual Data vs System Estimates Conflict

  • Insight: Are your manually entered In Transit or In Warehouse values still accurate?

  • Rule:

    • Days of Inventory Left includes external stock

    • BUT actual shipments have already arrived or were cancelled

  • Follow-up: Regularly audit manual stock inputs. Overreliance can give false reorder comfort.

🧠 Advanced Multi-Criteria Strategies

📦 SKU Rationalization

  • Filter for:

    • Velocity < 0.1/day

    • Age Level ≥ 3

    • Refund % > 5%

  • → Flag for possible product discontinuation

💰 Cash Flow Optimisation

  • Filter for:

    • Inventory Tied Cost in top 20%

    • AND Total Cash Value in bottom 40%

  • → Opportunity to unlock tied-up working capital

📈 Top Sellers At Risk

  • Filter for:

    • Velocity in top 20%

    • Days of Inventory Left < 7

  • → Reorder immediately or risk stockout on high-performing SKUs

Was this helpful?

 

No luck finding what you need? Contact Us