# MCF Fulfillment Order Status Notifications

- BigQuery table name: `amazon_notifications_fulfillment_order_status`
- Available in: Seller Central
- Data scheme index: https://api.datadoe.com/api/v1/spec/data-scheme.md

Near real-time Amazon SP-API FULFILLMENT_ORDER_STATUS notifications (payload version 2026-07-04) for Multi-Channel Fulfillment order, shipment, and package status changes. eventType is ORDER_STATUS_CHANGED, SHIPMENT_STATUS_CHANGED, or SHIPMENT_PACKAGE_STATUS_CHANGED. Tracking numbers and estimated delivery times are present only when Amazon sends them. Returns are not included. Seller Central only, for Amazon MCF marketplaces in North America, Europe, and the Far East. This is not the Brazil FBA Onsite notification and not the US-only Tracking API.

- Source type: `SELLER_CENTRAL`
- Source ID: `0c9717978ab8160fe4662b723014a01d8d5449ee8d6fba4aea829898adde64fa`
- Requires a date period: no
- Contains PII: no
- Premium table: no
- User-managed: no
- Default dataset: no
- Rows count towards billing: yes
- Hub: https://www.datadoe.com/hub/data-scheme?source=SELLER_CENTRAL&table=0c9717978ab8160fe4662b723014a01d8d5449ee8d6fba4aea829898adde64fa

## Fetch periods

- `CONTINUOUS`

## Data availability

- `REAL_TIME` — SP-API notifications are available within about 2 hours after Amazon publishes them.

## Columns (11)

- `marketplace_id` (`TEXT`, required) — Amazon provided ID that represents a specific country where the Seller or Vendor operates.
- `marketplace_country_code` (`TEXT`, required) — ISO country code for the Amazon marketplace.
- `marketplace_country_name` (`TEXT`, required) — Human-readable country name for the marketplace (derived from marketplace_id).
- `seller_or_vendor_id` (`TEXT`, required) — DataDoe account identifier used by MCP/API calls (sellers_and_vendors_list, exports). Not unique in amazon_sellers_and_vendors_context when one account has multiple connection contexts — join that table on connection_context_id instead.
- `seller_or_vendor_name` (`TEXT`, required) — DataDoe connection context display name for the seller or vendor.
- `marketplace_seller_id` (`TEXT`, nullable) — Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID.
- `sp_api_notification_id` (`TEXT`, required) — Amazon SP-API notification identifier.
- `sp_api_notification_type` (`TEXT`, required) — Notification type. Expected value: FULFILLMENT_ORDER_STATUS.
- `event_time` (`DATE`, required) — Time when Amazon published the notification (ISO-8601 / UTC).
- `notification_metadata` (`JSON`, required) — Amazon SP-API notification metadata payload.
- `payload` (`JSON`, required) — Raw SP-API notification payload.

---

Query live via DataDoe MCP `exports_source_get` (connected accounts only), or request rows with `exports_create`.