The primary purpose of the Order API is to support order synchronization, order research, and demand-based decision support tools. Data is processed in near real-time, which is every hour.

There are two primary data feeds associated with the Orders API;

  • Orders (sp_orders)

  • Order Items (sp_order_items)

The connector leverages the Amazon Order API, which is different than Reports. This API provides a "live" transaction feed of activity each hour, as it occurs on Amazon. There is no historical data for live Order API feeds. For more details on the types of data returned by the API, see Amazon's Order API docs.

Order API vs. Sales (Order Tracking) Reports

While sales data from the Orders API is similar to Sales reports, reports are aggregated based on settled data while Orders API is "live" transactional data.

Transactional Data

Order API transactional data reflects activity as it happens on Amazon. As a result, there is no historical data, and it may have more variability. For example, an Order transaction comes across at 11:15 AM on June 1st. Two hours later, at 1:30 PM on June 1st, the same Order changed the status to "Cancelled." This means you will have two order transactions, one at 11:15 AM and another at 1:30 PM. An Sales Report will be generated on June 2nd, with the Order simply having one row listed as "Cancelled."

For more information on Sales Reports for orders, see Amazon Sales Connector.

Order Status

When an order is Pending (the Order has been placed but payment has not been authorized), per Amazon, the order items will not contain information about pricing, taxes, shipping charges, gift status, or promotions for an order.

After an order leaves the Pending state (when payment has been authorized) and enters the Unshipped, Partially Shipped, or Shipped state, the Order Items will return information about pricing, taxes, shipping charges, gift status, and promotions for the order items in Orderrder.

Did this answer your question?