Comparing order data between Amazon Seller Central and Funnel

There are a few places in Amazon Seller Central UI where order data is available but the most commonly used resources are:

  • Manage Orders

    Can be found under Orders -> Manage Orders.

    Here the user can toggle between MFN and FBA orders, broken down by order status. This UI is good for looking up one or a few orders, but does not give a complete list of orders in a single view.

  • All Orders report

    Reports -> Fulfilment by Amazon -> All Orders

    This is a report that can be requested and downloaded that shows all orders (both MFN and FBA) and their order items for the date range you have requested. This report very closely resembles the "Order Item Details" report available in Funnel.

Regardless of how you compare order data between Amazon Seller Central and Funnel it is important to understand how timezones affect the comparison, which is described below.

Timezones

All dates and times for the Amazon Selling Partner connector in Funnel are specified in Coordinated Universal Time (UTC) and not in the local timezone where the order was placed. This applies to the following dimensions:

  • Date - The date in UTC for when the order was placed

  • Purchase date - The date and time in UTC for when the order was placed

  • Last updated - The date and time in UTC of the most recent order update

In the Amazon Seller Central UI these order dates and timestamps are displayed in the seller's local timezone and comparing data on an aggregated level between Seller Central and Funnel can therefor be challenging since some orders might be attributed to different dates due to timezones.

Example

If you in the Amazon Seller Central UI are looking at orders in January and want to compare it to orders in Funnel in the same time period, you might notice a difference in the number of orders between the platforms. This is due to that some orders took place in UTC, either on December 31st or February 1st. Therefore changing the date interval to include a longer period in Funnel will display the missing orders, but having the same exact values between Seller Central and Funnel might not be possible.

How far back in time can I get data from Amazon Selling Partner?

By default the Amazon Selling Partner connector will download data as far back as two years. If your shop was created before then and you would like to extend download of historical data further back, you can contact support@funnel.io and request a specific date.

Did this answer your question?