This guide explains Amazon inventory datasets for tracking stock, resolving discrepancies, and optimizing replenishment.

Includes:

  1. Decision flowchart to map business questions (e.g., "What’s my FBA stock?") to the relevant tables and workflows.
  2. Inventory Datasets: Key tables, limitations, and use cases.
  3. Table Relationships: How raw data connects to aggregated views.
  4. Practical Scenarios: SQL queries for common tasks (e.g., stock drops, restocks, aged inventory).

Use this to validate Amazon’s recommendations, audit ledger details, and avoid storage fees.

<aside> 💡

View Your Inventory at the Country Level

If your goal is simply to see your ASIN/SKU inventory the same way Seller Central shows it, use:

These tables show your day-to-day inventory quantities at the country level, with the key fields you need:

stock, aging, health, and availability.

</aside>

1. Decision Flowchart

This diagram acts as a decision tree to identify which inventory tables address your specific needs. Start with your question (e.g., “What’s my current stock?” or “Why did inventory change?”) and follow the branches to locate datasets for real-time snapshots, historical trends, restock alerts, or logistics planning.

Untitled diagram-2025-11-20-135122.png

2. Inventory Datasets

Schema View Key Columns Purpose Data Freshness Geographic Scope Limitations Example Use Case
RAW_INVENTORY RAW_INVENTORY_FBA asin, sku, afn_fulfillable_quantity, afn_inbound_shipped_quantity,afn_total_quantity Latest snapshot of FBA inventory (sellable/unsellable stock, inbound shipments).
⚠️No deduplication — same ASIN may appear via multiple SKUs (risk of overcounts) Daily Region-based (e.g., "North America") ❌ No country-level granularity
❌ Archived listings excluded
❌ Only includes data for ASINs seen in the past 7 days "How much sellable stock do I have across Amazon’s warehouses today?"
RAW_INVENTORY RAW_INVENTORY_FBA_HISTORY (deprecated) asin, sku, afn_fulfillable_quantity, afn_inbound_shipped_quantity,afn_total_quantity Daily historical snapshots of FBA inventory (track stock trends).
⚠️No deduplication — same ASIN may appear via multiple SKUs (risk of overcounts) Daily Region-based ❌ Does not explain why changes occurred
❌ Archived listings excluded "How did my sellable stock change over the past 30 days?"
SELLING_PARTNER SELLER_INVENTORY_FBA_HISTORY_DAILY observation_date, asin, sku, afn_fulfillable_quantity, afn_inbound_shipped_quantity,afn_reserved_quantity Daily seller-level inventory snapshots (FBA stock levels, inbound shipments, reserved units). Tracks SKU/ASIN trends over time.
⚠️No deduplication — same ASIN may appear via multiple SKUs (risk of overcounts) Daily Region-based ❌ Aggregated data (no transaction-level details)
❌ No country/warehouse granularity
❌ Archived listings excluded "How did my reserved inventory for SKU-X change across North America last month?”
RAW_INVENTORY RAW__INVENTORY_RESTOCK_RECOMMENDATIONS total_days_of_supply, recommended_replenishment_quantity, alert Amazon’s restock advice for SKUs with ≤14 days of supply. Daily ✅ MX, FR, DE, CA, JP, US, IT, ES, GB ❌ Excludes SKUs with ample stock (>14 days supply)
❌ No recommendations for inactive SKUs "Which SKUs need urgent restocking?"
RAW_INVENTORY RAW_INVENTORY_RESTOCK_RECOMMENDATIONS_HISTORY observation_time, recommended_replenishment_quantity, days_of_supply_at_amazon_fulfillment_network, total_days_of_supply Track historical changes to Amazon’s restock advice. Daily ✅ MX, FR, DE, CA, JP, US, IT, ES, GB ❌ Excludes SKUs with ample stock (>14 days supply)
❌ No recommendations for inactive SKUs "How has Amazon’s restock advice for my SKU changed over time?"
SELLING_PARTNER SELLER_INVENTORY_LEDGER_DETAIL event_type, quantity, fulfillment_center,disposition, country, adjustment_reason_code Granular log of all inventory movements (shipments, returns, adjustments, removals) over the past 18 months. Acts as a "bank statement" for inventory reconciliation. Daily (delayed by ≤3 days) ✅Region + Country + warehouse "Why is there a discrepancy of 200 units in my EU warehouse this month?”
SELLING_PARTNER SELLER_INVENTORY_LEDGER_SUMMARY starting_warehouse_balance, ending_warehouse_balance, customer_shipments, customer_returns Daily aggregated view of inventory health (starting/ending balances, net changes). Daily (delayed by ≤3 days) ✅ Region + Country + warehouse "What’s my net inventory change across all EU warehouses this week?”
SELLING_PARTNER SELLER_INVENTORY_FBA_PLANNING inv_age_365_plus_days, recommended_action, estimated_storage_cost AI-driven recommendations to optimize aged stock, pricing, and removals. Includes sales velocity, inbound status, and fee forecasts. Weekly ✅ All except MX ❌ MX marketplace not supported "Which aged SKUs should I remove to avoid $5k in storage fees next month?”
SELLING_PARTNER SELLER_INVENTORY_ALL_LISTINGS price, qualtity, status A snapshot of your catalog -showing how each SKU is set up and how Amazon currently sees your product data with quantity (Inventory level) for MFN Daily Marketplace Key ❌ No FBA Inventory information (quantity = null) “What products are currently active/inactive on Amazon?”
”What’s my current price per SKU?”
SELLING_PARTNER SELLER_INVENTORY_ALL_LISTINGS_HISTORY price, qualtity, status A history of snapshots of your catalog -showing how each SKU is set up and how Amazon currently sees your product data with quantity (Inventory level) for MFN Daily Marketplace Key ❌ No FBA Inventory information (quantity = null) “What products were active/inactive on Amazon last month?”

3. How Tables Connect

Raw Reports from Amazon

Views Available in your Database

Untitled diagram-2025-11-20-135100.png