rpt_get_fba_inventory_planning_data

Seller reports (SP-API) · GET_FBA_INVENTORY_PLANNING_DATA · Every 6 hours, at minute 5 (marketplace local time)

How fresh is it?

Several times a day

Every 6 hours, at minute 5 (marketplace local time)

Need it right now?

—

No live tool answers this — query the synced rows.

Family	Seller reports (SP-API)
Report type	`GET_FBA_INVENTORY_PLANNING_DATA`
Grain	`per_mkt`
Sync	snapshot
Business date	`snapshot_date`

Columns (138)

Column	Type	Key
`id`	`INTEGER`
`store_id`	`VARCHAR(36)`	🔑 key
`snapshot_date`	`DATE`	🔑 key
`country_code`	`VARCHAR(16)`	🔑 key
`country`	`VARCHAR(20)`
`sku`	`VARCHAR(200)`	🔑 key
`fnsku`	`VARCHAR(200)`	🔑 key
`asin`	`VARCHAR(20)`
`product_name`	`TEXT`
`condition`	`VARCHAR(50)`	🔑 key
`supplier`	`VARCHAR(200)`
`currency_code`	`VARCHAR(10)`
`price`	`NUMERIC(12, 2)`
`sales_last_30_days`	`NUMERIC(12, 2)`
`total_units`	`INTEGER`
`inbound`	`INTEGER`
`available`	`INTEGER`
`fc_transfer`	`INTEGER`
`fc_processing`	`INTEGER`
`customer_order`	`INTEGER`
`unfulfillable`	`INTEGER`
`working`	`INTEGER`
`shipped`	`INTEGER`
`receiving`	`INTEGER`
`fulfilled_by`	`VARCHAR(50)`
`total_days_of_supply_including_units_from_open_shipments`	`NUMERIC(12, 2)`
`days_of_supply_at_amazon_fulfillment_network`	`NUMERIC(12, 2)`
`alert`	`VARCHAR(200)`
`weeks_of_cover`	`NUMERIC(8, 2)`
`units_sold_last_30_days`	`INTEGER`
`recommended_replenishment_qty`	`INTEGER`
`unit_storage_size`	`VARCHAR(50)`
`pending_removal_quantity`	`INTEGER`
`your_price`	`NUMERIC(12, 2)`
`sales_price`	`NUMERIC(12, 2)`
`lowest_price_new_plus_shipping`	`NUMERIC(12, 2)`
`lowest_price_used`	`NUMERIC(12, 2)`
`featuredoffer_price`	`NUMERIC(12, 2)`
`recommended_action`	`VARCHAR(100)`
`healthy_inventory_level`	`INTEGER`
`recommended_sales_price`	`NUMERIC(12, 2)`
`recommended_sale_duration_days`	`INTEGER`
`recommended_removal_quantity`	`INTEGER`
`estimated_cost_savings_of_recommended_actions`	`NUMERIC(12, 2)`
`sell_through`	`NUMERIC(10, 4)`
`item_volume`	`NUMERIC(12, 4)`
`volume_unit_measurement`	`VARCHAR(20)`
`storage_type`	`VARCHAR(50)`
`storage_volume`	`NUMERIC(12, 4)`
`marketplace`	`VARCHAR(50)`
`product_group`	`VARCHAR(100)`
`sales_rank`	`INTEGER`
`days_of_supply`	`NUMERIC(10, 2)`
`estimated_excess_quantity`	`INTEGER`
`weeks_of_cover_t30`	`NUMERIC(10, 2)`
`weeks_of_cover_t90`	`NUMERIC(10, 2)`
`estimated_storage_cost_next_month`	`NUMERIC(12, 2)`
`is_seasonal_in_next_3_months`	`VARCHAR(20)`
`units_shipped_t7`	`INTEGER`
`units_shipped_t30`	`INTEGER`
`units_shipped_t60`	`INTEGER`
`units_shipped_t90`	`INTEGER`
`sales_shipped_last_7_days`	`NUMERIC(12, 2)`
`sales_shipped_last_30_days`	`NUMERIC(12, 2)`
`sales_shipped_last_60_days`	`NUMERIC(12, 2)`
`sales_shipped_last_90_days`	`NUMERIC(12, 2)`
`inbound_quantity`	`INTEGER`
`inbound_working`	`INTEGER`
`inbound_shipped`	`INTEGER`
`inbound_received`	`INTEGER`
`unfulfillable_quantity`	`INTEGER`
`total_reserved_quantity`	`INTEGER`
`reserved_fc_transfer`	`INTEGER`
`reserved_fc_processing`	`INTEGER`
`reserved_customer_order`	`INTEGER`
`inv_age_0_to_90_days`	`INTEGER`
`inv_age_91_to_180_days`	`INTEGER`
`inv_age_181_to_270_days`	`INTEGER`
`inv_age_271_to_365_days`	`INTEGER`
`inv_age_366_to_455_days`	`INTEGER`
`inv_age_456_plus_days`	`INTEGER`
`inv_age_0_to_30_days`	`INTEGER`
`inv_age_31_to_60_days`	`INTEGER`
`inv_age_61_to_90_days`	`INTEGER`
`inv_age_181_to_330_days`	`INTEGER`
`inv_age_331_to_365_days`	`INTEGER`
`inventory_age_snapshot_date`	`DATE`
`historical_days_of_supply`	`NUMERIC(10, 2)`
`last_updated_for_historical_days_of_supply`	`DATE`
`short_term_historical_days_of_supply`	`NUMERIC(10, 2)`
`long_term_historical_days_of_supply`	`NUMERIC(10, 2)`
`recommended_ship_in_quantity`	`INTEGER`
`recommended_ship_in_date`	`DATE`
`inventory_supply_at_fba`	`INTEGER`
`recommended_order_quantity`	`INTEGER`
`recommended_order_date`	`DATE`
`weeks_of_cover_estimated_excess_quantity`	`INTEGER`
`season_name`	`VARCHAR(50)`
`qty_to_be_charged_ltsf_6_mo`	`INTEGER`
`projected_ltsf_6_mo`	`NUMERIC(12, 2)`
`qty_to_be_charged_ltsf_12_mo`	`INTEGER`
`estimated_ltsf_next_charge`	`NUMERIC(12, 2)`
`qty_to_be_charged_ais_241_270_days`	`INTEGER`
`estimated_ais_241_270_days`	`NUMERIC(12, 2)`
`qty_to_be_charged_ais_271_300_days`	`INTEGER`
`estimated_ais_271_300_days`	`NUMERIC(12, 2)`
`qty_to_be_charged_ais_301_330_days`	`INTEGER`
`estimated_ais_301_330_days`	`NUMERIC(12, 2)`
`qty_to_be_charged_ais_331_365_days`	`INTEGER`
`estimated_ais_331_365_days`	`NUMERIC(12, 2)`
`qty_to_be_charged_ais_366_455_days`	`INTEGER`
`estimated_ais_366_455_days`	`NUMERIC(12, 2)`
`qty_to_be_charged_ais_456_plus_days`	`INTEGER`
`estimated_ais_456_plus_days`	`NUMERIC(12, 2)`
`restock_plus_seller_eligible`	`VARCHAR(20)`
`restock_plus_seller_opted`	`VARCHAR(20)`
`restock_plus_suggested_weeks_of_cover`	`NUMERIC(8, 2)`
`restock_plus_storage_incentives`	`NUMERIC(12, 2)`
`restock_plus_total_incentives`	`NUMERIC(12, 2)`
`inv_age_365_plus_days`	`INTEGER`
`inv_age_91_to_150_days`	`INTEGER`
`inv_age_151_to_180_days`	`INTEGER`
`qty_to_be_charged_ais_181_210_days`	`INTEGER`
`estimated_ais_181_210_days`	`NUMERIC(12, 2)`
`qty_to_be_charged_ais_211_240_days`	`INTEGER`
`estimated_ais_211_240_days`	`NUMERIC(12, 2)`
`qty_to_be_charged_ais_365_plus_days`	`INTEGER`
`estimated_ais_365_plus_days`	`NUMERIC(12, 2)`
`projected_ltsf_5_mo`	`NUMERIC(12, 2)`
`qty_to_be_charged_ltsf_5_mo`	`INTEGER`
`low_inventory_level_fee_exempted`	`VARCHAR(20)`
`low_inventory_level_fee_applied`	`VARCHAR(20)`
`reserved_staging`	`INTEGER`
`fba_inventory_level_health_status`	`VARCHAR(50)`
`fba_minimum_inventory_level`	`INTEGER`
`no_sale_last_6_months`	`VARCHAR(20)`
`fulfillment_service_and_programs`	`VARCHAR(50)`
`extra`	`JSON`

Query it

In an AI client (MCP)

tools/call

{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_get_fba_inventory_planning_data"
    ],
    "columns": [
      "rpt_get_fba_inventory_planning_data.snapshot_date",
      "rpt_get_fba_inventory_planning_data.country_code",
      "rpt_get_fba_inventory_planning_data.sku",
      "rpt_get_fba_inventory_planning_data.fnsku"
    ],
    "order_by": [
      {
        "column": "rpt_get_fba_inventory_planning_data.snapshot_date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}

From code (Tool API)

curl -X POST https://api.sellersheetai.com/api/v1/tools/query_report_data \
  -H "Authorization: Bearer $SELLERSHEET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"store":"myStore-US","tables":["rpt_get_fba_inventory_planning_data"],"columns":["rpt_get_fba_inventory_planning_data.snapshot_date","rpt_get_fba_inventory_planning_data.country_code","rpt_get_fba_inventory_planning_data.sku","rpt_get_fba_inventory_planning_data.fnsku"],"order_by":[{"column":"rpt_get_fba_inventory_planning_data.snapshot_date","dir":"desc"}],"limit":100}'

Early access — the Tool API is open on request, contact us.

rpt_get_fba_inventory_planning_data

Columns (138)Copy Anchor Link

Query itCopy Anchor Link

On this page

Columns (138)

Query it