Refunds

eBay Return to AliExpress Refund: Reconciliation Workflow

August 7, 2026 · 8 min read

Managing eBay return requests and their corresponding AliExpress refunds is a critical, often manual, reconciliation task for dropshippers. Without a robust system, it's easy to lose track of refunds, leading to lost profits. This workflow outlines how to leverage Fetch Order Tracking to automate and streamline this process, ensuring no refund is missed.

The Core Problem: Disconnected Data

An eBay return request initiates a process on your end, but the actual refund action occurs on AliExpress. The challenge is linking these two events and their statuses, especially when dealing with high volumes. You need to know:

Which eBay return requests have an associated AliExpress refund?
What is the status of that AliExpress refund (e.g., pending, completed)?
Has the item been returned to the AliExpress seller, if applicable?

Fetch Order Tracking provides the necessary AliExpress API data points directly into your Google Sheet, allowing you to build a reconciliation dashboard.

Step 1: Identify eBay Return Requests

Your eBay sales channel will notify you of return requests. The first step is to log these into your master tracking sheet. Ideally, this sheet already contains your eBay Order ID and the corresponding AliExpress Order ID. If not, you'll need to manually link them at this stage.

Create a dedicated column in your Google Sheet, for example, eBay_Return_Requested. When an eBay return is initiated, mark 'TRUE' in this column for the respective order. This acts as your trigger for the reconciliation process.

Step 2: Monitor AliExpress Refund Status

Fetch Order Tracking automatically pulls a wealth of data for your AliExpress orders, including crucial refund information. The key fields you'll be monitoring are:

gmt_refund: This timestamp indicates when a refund was initiated or completed on AliExpress. A non-empty value here signifies a refund process is underway or finished.
order_status: Look for statuses like REFUND_PENDING, REFUND_SUCCESS, REFUND_CLOSED, or FINISH (if the refund was part of a dispute resolution that closed the order).
logistics_status: While not directly a refund status, this is vital for returns where the item is sent back. Statuses like BUYER_ACCEPT_GOODS or SELLER_RECEIVE_GOODS can indicate the physical return process.
end_reason: For closed orders, this field can provide context, such as TRADE_CLOSED_BY_DISPUTE.

Set up conditional formatting in your Google Sheet for these columns. For instance, highlight gmt_refund cells in green if the refund is successful, or red if it's pending for an extended period.

The core of efficient reconciliation lies in consistently linking your eBay Order ID to its AliExpress counterpart and then programmatically comparing their respective statuses. Don't rely on manual checks for every order.

Step 3: Establish Reconciliation Logic

Now, let's build the logic to reconcile the eBay return request with the AliExpress refund status. Create a new column, e.g., Refund_Reconciliation_Status, and use a formula to populate its value.

Scenario 1: Refund Initiated on AliExpress

If eBay_Return_Requested is 'TRUE' AND gmt_refund is NOT empty, it means you've initiated a refund process on AliExpress. Your formula might look like this:

=IF(AND(A2="TRUE", NOT(ISBLANK(B2))), "Refund Initiated", "")

Where A2 is eBay_Return_Requested and B2 is gmt_refund.

Scenario 2: Refund Successful on AliExpress

To confirm a successful refund, you'll typically look for a specific order_status in conjunction with gmt_refund. For example:

=IF(AND(A2="TRUE", C2="REFUND_SUCCESS"), "Refund Completed", "")

Where C2 is order_status.

Scenario 3: Item Returned to Seller (if applicable)

If your return policy requires the item to be sent back to the AliExpress seller, you'll integrate logistics_status. This is more complex as it depends on the specific dispute resolution. An example could be:

=IF(AND(A2="TRUE", D2="SELLER_RECEIVE_GOODS", C2="REFUND_SUCCESS"), "Refund Completed (Item Returned)", "")

Where D2 is logistics_status.

Combining Logic for a Comprehensive Status

You'll likely use a nested IF statement or multiple columns to track the progression. A more comprehensive reconciliation status might be:

=IF(A2="FALSE", "No eBay Return",
  IF(C2="REFUND_SUCCESS", "AliExpress Refund Completed",
    IF(NOT(ISBLANK(B2)), "AliExpress Refund Initiated",
      IF(A2="TRUE", "eBay Return Requested, No AliExpress Refund Yet", "Unknown"))))

This formula first checks if an eBay return was requested. If not, it's 'No eBay Return'. If an eBay return was requested, it then checks for a successful AliExpress refund. If not successful but a gmt_refund exists, it's 'AliExpress Refund Initiated'. Finally, if an eBay return was requested but no AliExpress refund activity is present, it flags 'eBay Return Requested, No AliExpress Refund Yet'.

Step 4: Actionable Insights and Alerts

Once your reconciliation logic is in place, you can build dashboards and set up alerts within Google Sheets:

Filter for 'eBay Return Requested, No AliExpress Refund Yet': These are the orders requiring your immediate attention. You need to investigate why the AliExpress refund process hasn't started.
Monitor 'Refund Initiated' for delays: If an order stays in this status for too long (e.g., 7-10 days), it might indicate a stuck dispute or a seller delaying the process.
Verify 'Refund Completed' with your bank statements: While Fetch Order Tracking confirms the AliExpress system status, a final check against your actual bank or payment processor statements ensures the funds have arrived.

By automating the data collection and reconciliation logic, you transform a potentially chaotic manual process into a clear, actionable workflow. This reduces errors, saves time, and ensures you recover funds efficiently.

For more detailed API field explanations and to get started with automated tracking, visit Fetch Order Tracking.

Try the fetcher → More guides