Listing, Inventory and Order Management

Agent SP-API gives you read-only API access to the listing, inventory, and order data synced from your connected Amazon Seller or Vendor account. Data arrives two ways: scheduled report syncs materialized as queryable tables, and live SP-API notification streams captured as event tables. Everything is queryable through GET /api/v1/query/{table_name} with one bearer token — see the API overview for the request format.

Order Management

Track every order from sale through settlement without polling Amazon yourself:

  • Order-level settlement detail. The settlements table carries per-transaction rows with order_id, merchant_order_id, sku, quantity_purchased, shipment and fulfillment IDs, and itemized fee amounts. settlement_summaries rolls up each settlement payout.
  • Fulfillment order status. Live event tables spapi_fulfillment_order_status_events and spapi_external_fulfillment_shipment_status_changes record order and shipment state changes as Amazon publishes them.
  • Order metrics. GET /api/spapi/sales/v1/orderMetrics proxies SP-API sales order metrics with caching — order counts, units, and revenue by interval.

Inventory Management

Monitor stock positions and inventory movement across FBA and vendor programs:

  • FBA availability changes. The spapi_fba_inventory_availability_changes event table captures fulfillable quantity changes as they happen.
  • Item inventory events. spapi_item_inventory_event_changes records item-level inventory event changes from the live notification stream.
  • Vendor inventory reports. Weekly retail/sourcing vendor inventory data is synced into vendor_inventory_week_retail_sourcing_rows and its summary table.
  • Current stock snapshots. GET /api/spapi/fba/inventory/v1/summaries proxies FBA inventory summaries (by SKU, with granularity filters) with caching.

Listing Management

Watch how every listing is positioned, priced, and performing:

  • Offer changes. spapi_any_offer_changed_events and spapi_b2b_any_offer_changed_events record buy-box and offer changes for your listings, including B2B pricing tiers.
  • Pricing health. spapi_pricing_health_events surfaces Amazon's pricing health alerts per listing so uncompetitive prices are visible immediately.
  • Listing traffic. spapi_detail_page_traffic_events streams detail-page traffic signals per listing.

Sales & Traffic Analytics

  • Seller sales & traffic. SKU-level weekly and monthly sales and traffic report data lands in sales_traffic_sku_week_rows, sales_traffic_sku_month_rows, and their summary tables.
  • Vendor sales & traffic. Vendor accounts sync weekly/monthly sales (vendor_sales_week_retail_sourcing_rows, vendor_sales_month_retail_sourcing_rows) and traffic (vendor_traffic_week_rows, vendor_traffic_month_rows) reports.
  • Item sales events. spapi_item_sales_event_changes captures item-level sales events from the live stream.

How access works

All of the above is exposed through the read-only public API: GET /api/v1/tables lists the tables available for your account, and GET /api/v1/query/{table_name} queries them with PostgREST-style filters. Agent SP-API does not create, edit, or delete listings, inventory, or orders on Amazon — it is a data and analytics layer over your own account's information. Exact table availability depends on your account type (Seller vs Vendor) and the data sources you enable; see Data Sources.