Amazon Selling Partner: Troubleshooting#

Revenue number alignment#

Compare fetched data with client UI Orders reports when revenue numbers don’t align:

  • Granularity differences: Ensure same level of detail in both reports

  • Timezone mismatches: Account for UTC vs local timezone differences

  • Filter variations: Verify same date ranges and status filters applied

Marketplace naming standardization#

USA marketplace standardization: Marketplace for USA comes through as “United States of America”. To align with standard country mapping, change this to “United States” for consistency across reporting platforms.

Fetch consistency considerations#

1-day vs 2-day fetch comparison: You may need to use ‘unique by fetch’ as numbers won’t always align between different fetch periods. The underlying cause for this discrepancy is not definitively known, making consistent fetch strategy important.

Recommendations:

  • Establish consistent fetch frequency based on business requirements.

  • Monitor for data discrepancies between different fetch intervals.

  • Use unique by fetch to maintain data integrity when inconsistencies occur.