Workflow

Automating Tracking Number Updates from Fetch to eBay

August 25, 2026 · 7 min read

Manually updating tracking numbers on eBay for every dropshipped order from AliExpress is a significant time sink. For high-volume sellers, this process becomes a bottleneck, delaying order fulfillment status and potentially impacting seller performance metrics. This guide details how to automate tracking number propagation from Fetch Order Tracking into your eBay orders, ensuring timely updates and freeing up your operational bandwidth.

The Manual Tracking Update Problem

Consider a scenario where you process 100 orders daily. Each order requires you to:

Locate the corresponding AliExpress order.
Copy the tracking number.
Navigate to the eBay order.
Paste the tracking number.
Select the carrier.
Mark the item as shipped.

Even at 30 seconds per order, this amounts to 50 minutes of repetitive work daily. Multiply this by your weekly or monthly volume, and the inefficiency is clear. Furthermore, delays in updating tracking information can lead to increased buyer inquiries and potential 'Item not received' disputes if buyers can't track their packages.

Fetch Order Tracking's Role

Fetch Order Tracking automatically pulls order data from your AliExpress accounts and populates it into your Google Sheet. Crucially, it tracks changes in the logistics_status and extracts the latest tracking_number and logistics_company as soon as they are available from AliExpress. This centralized, real-time data is the foundation for automating your eBay updates.

Prerequisites for Automation

Before setting up the automation, ensure you have:

An active Fetch Order Tracking subscription and your AliExpress accounts linked.
A Google Sheet integrated with Fetch, actively receiving order data.
An eBay Seller Account with API access enabled (or a third-party tool that connects to eBay's API).
A method to connect Google Sheets to eBay's API or a suitable integration platform (e.g., Zapier, Make.com, custom script).

Mapping Data Fields

The core of this automation lies in correctly mapping the data fields between Fetch (Google Sheets) and eBay. Here's a breakdown of essential fields:

eBay Order ID: This is the unique identifier for the eBay order. You need to store this in your Fetch-integrated Google Sheet alongside your AliExpress order ID. Many dropshipping tools or manual order placement processes will include this. Ensure a column exists in your sheet, e.g., eBay_Order_ID.
AliExpress Order ID: Fetch automatically populates the order_id column.
Tracking Number: Fetch populates the tracking_number column. This is the value you need to send to eBay.
Logistics Company: Fetch populates the logistics_company column. You'll need to map this to an eBay-recognized carrier name.
Order Status (Fetch): The order_status and logistics_status columns in Fetch indicate the current state. You'll typically trigger an update when logistics_status changes from 'WAIT_SELLER_SEND_GOODS' or 'WAIT_BUYER_ACCEPT_GOODS' to a status indicating the item has shipped (e.g., 'SELLER_SEND_GOODS', 'FINISH').

The critical trigger for automating tracking updates is a change in the logistics_status column within your Fetch-powered Google Sheet, specifically when a valid tracking_number becomes available.

Automation Workflow with Google Sheets and an Integration Platform

This example uses a common integration platform like Zapier or Make.com, which offers robust Google Sheets and eBay integrations. A custom Google Apps Script could also achieve this.

Step 1: Trigger Setup

Configure your integration platform to watch for new or updated rows in your Fetch-integrated Google Sheet. Specifically, set the trigger conditions:

New or Updated Row: Trigger when a row is updated in your sheet.
Filter Condition 1: logistics_status column is not empty AND logistics_status is not equal to 'WAIT_SELLER_SEND_GOODS'. This ensures a tracking number is likely available and the item has moved past the initial processing stage.
Filter Condition 2: tracking_number column is not empty.
Filter Condition 3: eBay_Order_ID column is not empty.

Step 2: Carrier Mapping (Optional but Recommended)

AliExpress logistics_company names might not perfectly match eBay's accepted carrier list. Implement a lookup table or a conditional logic step in your integration:

Example: If logistics_company is 'Cainiao Standard Shipping for Special Goods', map it to 'China Post' or 'SpeedPAK' on eBay, depending on your actual shipping method and eBay's options.
Example: If logistics_company is 'Aliexpress Standard Shipping', map it to 'SpeedPAK' or 'China Post'.

Store this mapping in a separate tab in your Google Sheet or directly within your integration platform's logic.

Step 3: Action: Update eBay Order

Use the eBay integration action in your platform to 'Add Tracking Info' or 'Update Order Shipping'.

eBay Order ID: Map this to the eBay_Order_ID column from your Google Sheet.
Tracking Number: Map this to the tracking_number column from your Google Sheet.
Carrier Name: Map this to the result of your carrier mapping (from Step 2) or directly from the logistics_company column if it's a direct match.

Some integration platforms also allow you to mark the item as shipped simultaneously, which is highly recommended.

Step 4: Status Update in Google Sheet (Optional)

To prevent redundant updates and maintain a clear record, add an optional step to update your Google Sheet after a successful eBay update. Create a new column, e.g., eBay_Tracking_Updated, and set its value to 'TRUE' or the timestamp of the update. Add a filter to your trigger (Step 1) to only process rows where eBay_Tracking_Updated is empty or 'FALSE'.

Considerations and Best Practices

Error Handling: Implement robust error handling. What happens if the eBay order ID is invalid? What if the tracking number format is incorrect? Your automation should log these errors and ideally notify you.
Rate Limits: Be mindful of eBay API rate limits. For most dropshippers, this won't be an issue, but if you're processing thousands of orders per hour, you might need to batch updates or introduce delays.
Carrier Names: Regularly review and update your carrier mapping. AliExpress shipping methods can change, and eBay's accepted carriers might evolve.
Partial Shipments: If an AliExpress order results in multiple tracking numbers (rare but possible), ensure your system can handle updating multiple tracking numbers for a single eBay order. Fetch captures all associated tracking numbers.
Refunds/Cancellations: If an order is canceled or refunded on AliExpress (order_status changes to 'CANCELLED' or a gmt_refund timestamp appears), you might want to prevent tracking updates or trigger a different action on eBay.

By implementing this automation, you transform a manual, error-prone task into a seamless background process. This not only saves you significant time but also improves buyer satisfaction by providing timely tracking information, ultimately contributing to better eBay seller performance metrics.

For more insights on optimizing your dropshipping operations with automated data, visit Fetch Order Tracking.

Try the fetcher → More guides