Timezones are a confusing topic for a global marketplace like Amazon. For example, a customer in New York places an order on March 11, 2021, at 1 AM (EST), but it is March 10, 2021, at 10 PM (PST) @ Amazon HQ in Seattle. When did the order occur? March 11th or March 10th?

Another wrinkle is that Amazon defaults to using a Coordinated Universal Time (UTC) standard in its systems. In our example above, the timestamp of the order would be March 11th, 2021, at 8 AM!

Seller Central User and Amazon Advertising Interface

So, where does a chunk of the confusion arise? Amazon Seller Central. The Seller Central interface displays information in the Pacific timezone (PST). However, Amazon stores information in its systems using UTC.

Per Amazon:

“Amazon Marketplace Web Service (Amazon MWS) formats date- and time-related data similar to the RFC 3339 standard, which defines a subset profile of ISO 8601 for use in Internet protocols and standards. This section will clarify how you should format and use date and time data in Amazon MWS.”

See this doc for Amazon's use of RFC 3339


Why does Amazon use UTC?

UTC’s use avoids local, regional, or national variations for timezones, including daylight savings time (DST). This is why conversion of a timestamp should always occur when displayed. For Seller Central, they convert UTC to display it as PST.

Most data analytics tools like Tableau, Looker, DataStudio, Quicksight…allow you to convert a timestamp from UTC to EST, PST, or whatever your preference.

How timezones impact your understanding of the data

As discussed, you will observe time shifts in Amazon user interfaces for North America, Europe, and the Far East Regions because they choose to display a timestamp in a specific timezone. However, regardless of how Amazon (or you) decide to display the data, it does not change the system timestamp is always UTC.

Let’s say you have a transaction with an order date of 2021-03-16T06:32:16.50 or March 16th, 2020, 6:32 AM. Amazon then displays this time in the Seller Central interface as 2021-03-15T23:32:16.50 or March 15, 2020, 11:32 PM.

These values are both correct, except one is a base (UTC), and the other is derived (PST). What do we mean by derived? It means that you convert the UTC timestamp to any other timezone. Amazon chooses to use PST for display in North America or CET in Europe.

Coordinated Universal Time is 7 hours ahead of Pacific Standard Time or 8 hours ahead of Pacific Daylight Time. As a result, looking at an interface based on PST and data provided in UTC can result in significant perceived shift order, returns, fulfillment...dates.

Remember that the UTC default from Amazon systems is stored exactly as they provide it in your data lake or warehouse. Understanding timezones may help you explain why an order may have one date in one place and different data in another.


Did this answer your question?