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

Includes:

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

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

1. 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). Daily Region-based (e.g., "North America") ❌ No country-level granularity
❌ Archived listings excluded "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). 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. 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?"
RAW_INVENTORY RAW_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?”
RAW_INVENTORY RAW_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?”

2. How Tables Connect

Raw Reports from Amazon

Views Available in your Database

Untitled diagram-2025-04-02-134217.png

Life Case Scenarios & Example Queries

1. "How much sellable stock do I have for SKU-X today?"

Tables: RAW_INVENTORY_FBA

Key Columns: