Amazon Seller Central Shipping Event Details#1936

If we open an order we need the shipping event details

Thanks for the details! A lot of this is already available in the Amazon Seller Central connector, split across two reports. For Amazon-fulfilled (FBA) orders, per-order shipping details are in the Amazon Fulfilled Shipments report: carrier (amazon_fulfilled_shipments_data_general__carrier), tracking number (tracking_number), ship date (shipment_date), estimated arrival (estimated_arrival_date), and ship service level. For per-item and per-order status, the All Orders report has item status (flat_file_all_orders_data_by_order_date_generalitem_status) and order status (__order_status), covering both FBA and merchant-fulfilled orders.
One important note: the connector pulls from one Amazon report per query, so combining order status with shipping/tracking fields in a single request returns “Could not determine a report to pull data from” (we can see this on your account). The workaround is to pull each report as its own query and join them on amazon_order_id in your destination.
Could you confirm whether you need this for FBA or merchant-fulfilled (self-ship) orders, and exactly which fields are still missing (for example carrier, tracking, ship date, delivery date, or event history)? For self-ship orders, Amazon’s API does not return carrier or tracking in a bulk report, so we want to scope what is actually retrievable before building anything.

Hi, thanks for sharing the details. We checked the above fields but was not able to find detailed statuse. What we are looking is ‘historical shipment event details.’