Amazon Selling Partner icon

Amazon Selling Partner

Interact with Amazon Selling Partner API

Actions26

Report → Consolidated Sales & Returns

AI-generated

Overview

This node operation fetches consolidated sales and returns data from Amazon Selling Partner API reports. It is useful for sellers or analysts who want to analyze sales performance and return metrics over a specified time period across multiple Amazon marketplaces. The node supports filtering by date range, granularity (daily, weekly, monthly), and marketplaces. It can optionally include refund data and emit raw subdatasets for detailed analysis.

Use Case Examples

  1. A seller wants to generate a consolidated report of sales and returns for their products on Amazon US and UK marketplaces for the last month, aggregated weekly.
  2. An analyst needs to include refund data in the consolidated sales and returns report to understand the impact of refunds on overall sales performance.

Properties

Name Meaning
Start Date Start of the reporting window (inclusive) in ISO-8601 format with timezone.
End Date End of the reporting window (inclusive) in ISO-8601 format with timezone.
Granularity Aggregation level for returned metrics, must align with Amazon report configuration.
Marketplace IDs Select marketplaces included in the report request.
Include Refunds If true, also fetch refunds via Finances API, which adds latency due to additional calls.
Emit Raw Subdatasets If true, output individual Sales/Returns datasets as separate items in addition to consolidated rows.
Advanced Options Additional settings for report generation such as max poll time, poll interval, return raw document, and binary property name.

Output

JSON

  • reportDate - Date of the report data.
  • asin - Amazon Standard Identification Number of the product.
  • marketplaceId - Identifier of the Amazon marketplace.
  • salesUnits - Number of units sold.
  • returnsUnits - Number of units returned.
  • refundsAmount - Amount refunded (if refunds are included).
  • rawSalesData - Raw sales dataset (if Emit Raw Subdatasets is enabled).
  • rawReturnsData - Raw returns dataset (if Emit Raw Subdatasets is enabled).

Dependencies

  • Amazon Selling Partner API credentials

Troubleshooting

  • Ensure the date range is valid and in ISO-8601 format with timezone to avoid API errors.
  • If including refunds, expect longer execution time due to additional API calls to the Finances API.
  • Check that the selected marketplaces are valid and supported by the Amazon Selling Partner API.
  • If the report generation exceeds the max poll time, increase the max poll time or check API status for delays.
  • If raw documents are returned, ensure the binary property name is correctly set to access the data.

Links

Discussion