Why Are Some ASIN Records Missing From the CATALOG Table?

Issue

Why are some Amazon Standard Identification Number (ASIN) records missing from the CATALOG table and its associated child tables?

Environment

Connector: Amazon Selling Partner

Answer

Amazon's Selling Partner API doesn't provide a dedicated endpoint to retrieve all ASIN data associated with your account. Instead, we get ASIN data by querying the Orders API. This approach only captures the ASIN data for products associated with orders.

Consequently, we're unable to sync ASIN data for products that aren't associated with orders to the CATALOG table and associated child tables.