Why Are Some Archived Orders Older Than Two Years Missing From the ORDERS Table?

Question

Why are some archived orders older than two years missing from the ORDERS table?

Environment

Connector: Amazon Selling Partner

Answer

For all marketplaces except JP, AU, and SG, the Amazon Selling Partner Orders API only returns up to two years of order history.

As a result, we can't sync archived orders older than two years for those marketplaces.