Workflow

Mapping eBay's 'Item Shipped' to Fetch Tracking Events

One of the most common questions for eBay dropshippers using Fetch Order Tracking is how to accurately reflect an eBay order's status, particularly 'Item Shipped', based on the more granular tracking data Fetch provides from AliExpress. Simply marking an item 'Shipped' on eBay when the AliExpress tracking shows 'Order created' or 'Seller preparing shipment' can lead to customer confusion or premature expectations. Fetch allows you to automate this mapping with precision.

Understanding eBay's 'Item Shipped' Status

On eBay, 'Item Shipped' typically means the seller has generated a shipping label and the package has been handed over to the carrier or is en route. It's a broad status, but crucial for buyer confidence and managing delivery expectations.

For dropshippers, this means the AliExpress order has moved past initial processing and is actively in transit. The challenge is identifying the exact Fetch tracking event that reliably signifies this point, without being too early or too late.

Key Fetch Fields for Status Mapping

Fetch provides two primary fields that are essential for defining what 'Item Shipped' means for your specific workflow:

• order_status: This reflects the overall status of the AliExpress order. Examples include PLACED, PAID, PROCESSING, SHIPPED, COMPLETED, CANCELLED.
• logistics_status: This provides detailed updates from the shipping carrier. Examples include ORDER_CREATED, PICKUP_SCAN, IN_TRANSIT, DELIVERED, EXCEPTION.

While order_status might show SHIPPED relatively early, logistics_status gives a more accurate picture of physical movement.

Defining 'Item Shipped' with Fetch Logic

The most robust way to define 'Item Shipped' for your eBay orders is to combine conditions from both order_status and logistics_status. This ensures that a shipping label isn't just created, but the package has actually started its journey.

Scenario 1: Basic 'Item Shipped' Definition

A conservative and generally safe definition for 'Item Shipped' is when the AliExpress order has been marked as shipped by the seller AND the carrier has registered the package.

For most dropshippers, 'Item Shipped' on eBay should correspond to the point where the AliExpress order is genuinely in transit, not just label-created.

Fetch Logic:

• order_status is SHIPPED
• AND logistics_status is NOT ORDER_CREATED

Why 'NOT ORDER_CREATED'? Because ORDER_CREATED often means the label was generated but the package hasn't been picked up or scanned into the system yet. By excluding this, you wait for a more concrete scan.

Scenario 2: More Precise 'Item Shipped' (Recommended)

To be even more precise and avoid false positives where a label is created but the item isn't yet moving, you can look for an 'in transit' status.

Fetch Logic:

• order_status is SHIPPED
• AND logistics_status is one of: PICKUP_SCAN, IN_TRANSIT, DEPARTURE_SCAN, ARRIVAL_SCAN

This set of conditions ensures that the item has been physically scanned by the carrier and is actively moving through the logistics network. For example:

• PICKUP_SCAN: The package has been picked up by the carrier.
• IN_TRANSIT: The package is actively moving between facilities.
• DEPARTURE_SCAN: The package has departed a sorting facility.
• ARRIVAL_SCAN: The package has arrived at a sorting facility.

Any of these indicate active shipment.

Scenario 3: Advanced 'Item Shipped' with Exceptions

Sometimes, you might want to consider an item 'shipped' even if there's a minor delay, as long as it's not a critical issue. This is less common but can be useful for specific workflows.

Fetch Logic:

• order_status is SHIPPED
• AND logistics_status is NOT ORDER_CREATED
• AND logistics_status is NOT CANCELED
• AND logistics_status is NOT EXCEPTION (unless the exception is minor and resolvable)

This adds layers of exclusion to prevent marking items as shipped if there's an immediate problem. However, be cautious with excluding EXCEPTION, as some exceptions might still mean the item is technically in transit but experiencing a delay.

Implementing the Logic in your Workflow

Once you've decided on your precise definition for 'Item Shipped', you can implement this logic in your Fetch-integrated Google Sheet. You'll typically use an IF statement in a dedicated column that checks the order_status and logistics_status columns provided by Fetch.

Example Google Sheets Formula (for Scenario 2):

Assuming order_status is in column C and logistics_status is in column D:

=IF(AND(C2="SHIPPED", OR(D2="PICKUP_SCAN", D2="IN_TRANSIT", D2="DEPARTURE_SCAN", D2="ARRIVAL_SCAN")), "Item Shipped", "Not Shipped Yet")

This formula will output 'Item Shipped' when both conditions are met, otherwise 'Not Shipped Yet'. You can then use this column to trigger automation via tools like Zapier or Make.com to update your eBay order status.

Why This Precision Matters

Accurately mapping 'Item Shipped' helps in several ways:

• Improved Customer Satisfaction: Buyers receive accurate updates, reducing inquiries about their order status.
• Reduced Disputes: Clear tracking information prevents premature 'Item not received' disputes.
• Optimized Workflow: Automation triggers only fire when the package is genuinely in transit, avoiding unnecessary actions or false starts.
• Better Refund Detection: Understanding when an item is truly shipped helps differentiate between pre-shipment cancellations and in-transit issues.

By leveraging the detailed data from Fetch Order Tracking, you can create a robust and accurate system for managing your eBay dropshipping orders, ensuring your 'Item Shipped' status reflects the true state of your AliExpress shipments.

For more detailed insights into Fetch's capabilities and integration, explore our main page: Fetch Order Tracking.

---