AliExpress Affiliate icon

AliExpress Affiliate

Use the AliExpress Affiliate API
Join our community

Actions11

Overview

The "Get Order List By Index" operation of the AliExpress Affiliate node retrieves a paginated list of orders filtered by specific criteria such as order status and time range. This operation is useful for affiliate marketers or sellers who want to track their order performance, analyze sales data, or reconcile commissions based on order statuses within a given period.

Typical use cases include:

  • Fetching all orders with a particular status (e.g., "Payment Completed") between two dates.
  • Paginating through large sets of order data using page number, page size, and optionally a start query index ID.
  • Monitoring order fulfillment stages by querying orders confirmed by buyers or completed settlements.

For example, an affiliate marketer could use this node to get all orders marked as "Buyer Confirmed Receipt" from the last week to verify commission payouts.

Properties

Name Meaning
Tracking ID Your tracking ID used to identify affiliate links and track orders.
Page No Page number of the results to retrieve (pagination).
Page Size Number of records per page, ranging from 1 to 50.
Order Status The status of orders to filter by. Options include: Payment Completed, Buyer Confirmed Receipt, Completed Settlement, Invalid.
Time Type The type of time to query against. Options include: Payment Completed Time, Buyer Confirmed Receipt Time, Completed Settlement Time.
Start Time Start of the time range for filtering orders (in PST time).
End Time End of the time range for filtering orders (in PST time).
Start Query Index ID Optional query index start value for pagination; if not provided, only the first page can be checked.

Output

The node outputs an array of JSON objects where each object corresponds to the API response body containing order list data matching the query parameters. The structure of the json output field directly reflects the AliExpress Affiliate API's order list response, which typically includes details such as order IDs, statuses, timestamps, product information, and commission data.

No binary data output is produced by this operation.

Dependencies

  • Requires an API key credential with access to the AliExpress Affiliate API.
  • The node uses the AliExpress SDK client configured with the API key and secret.
  • Network connectivity to the AliExpress Affiliate API endpoint (https://api-sg.aliexpress.com/sync) is necessary.

Troubleshooting

  • Missing Credentials: If the API key or secret is missing or invalid, the node will throw an error indicating missing required credential fields. Ensure that valid credentials are configured in n8n.
  • Invalid Parameters: Providing incorrect or unsupported values for properties like status, time_type, or date formats may cause API errors or empty responses. Verify parameter correctness according to AliExpress API documentation.
  • Pagination Issues: Not providing start_query_index_id when trying to paginate beyond the first page may limit results. Use this parameter to navigate through pages properly.
  • API Response Errors: Unexpected API response structures or network issues will result in errors. Enable "Continue On Fail" in the node settings to handle such cases gracefully.
  • Time Zone Confusion: The start_time and end_time must be in PST time zone. Using other time zones without conversion may lead to unexpected results.

Links and References

Discussion