Amazon Selling Partner: Tips and best practices

On this page

Understanding connector capabilities

The Amazon Selling Partner connector provides access to ecommerce data for vendors on Amazon marketplace through the Amazon Selling Partner API (SP-API). This REST-based API enables programmatic access to orders, shipments, payments, and comprehensive marketplace analytics.

Timezone considerations and data alignment

Critical timezone awareness API reports return data in UTC timezone whereas client UIs may be set to a different timezone. This is particularly problematic for US clients who typically work in EST/PST timezones.

Data alignment strategies: - Compare with client UI Orders reports to ensure granularity, timezone, and filters align - Consider implementing timezone enrichment for orders reports to match client expectations - Verify date ranges match between API extracts and client dashboard views

Data collection configuration

Local data retention

Set Receive extracts as they are fetched as the recommended local data retention method to handle potential data inconsistencies between fetches.

Overwrite settings

Use purchase-date as the recommended overwrite field to ensure proper data versioning and historical accuracy.

Recommended datastream configurations

Amazon Selling Partner | Orders

Report category: FBA Sales Report type: Flat file All Orders Report by Order Date Local data retention: Receive extracts as they are fetched Overwrite: purchase-date

Field mapping recommendations: - Map marketplace to country_name for geographic analysis - Map item-price to revenue for financial reporting consistency

API limitations and considerations

UTC timezone reporting may not align with business timezone expectations
Data consistency can vary between different fetch periods
Marketplace naming conventions may require standardization for reporting consistency
Regional data access depends on proper API authorization and account permissions

Best practices for implementation

Test timezone alignment before production deployment
Validate revenue calculations against client UI reports
Standardize marketplace naming for consistent geographic reporting
Monitor fetch consistency and adjust retention strategy as needed
Document field mappings for clarity in downstream reporting systems

Authentication and setup

Ensure proper Amazon Selling Partner API credentials are configured with appropriate permissions for accessing order and marketplace data. The connector requires valid SP-API access tokens and proper authorization for the specific marketplaces being monitored.