Why Timeszones Cause Amazon Seller Central Confusion
Wed, 23 Jun 2021 12:28:18 GMT
Timezones are a confusing topic when it comes to 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) in Seattle. What 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 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 just 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 it is 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 may be.
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 fact the system timestamp in the data is always UTC.
Let’s say you have a transaction with an order date of2021–03–16T06:32:16.50 or March 16th, 2020, 6:32 AM. Amazon then displays this time in the Seller Central interface as2021–03–15T23:32:16.50or March 15, 2020, 11:32 PM.
These values are both correct, except one is the base timezone (UTC), and the other is derived (PST) for display. What do we mean by derived? It means that someone converts the UTC timestamp to any other timezone of their choosing, just as Amazon chooses to use PST in North America or CET in Europe.
References https://docs.openbridge.com/en/articles/5053618-understanding-timezones-within-amazon-seller-central
Why Timeszones Cause Amazon Seller Central Confusion was originally published in Openbridge on Medium, where people are continuing the conversation by highlighting and responding to this story.
