Workflow

Why 'Awaiting Dispatch' Needs Nuance in Your Sheet

When you're running an eBay dropshipping store sourced from AliExpress, 'Awaiting Dispatch' is a status you see frequently. On the surface, it seems straightforward: the seller has received the order and is preparing it for shipment. However, relying solely on this generic status in your Google Sheet can lead to missed red flags, delayed refunds, and ultimately, unhappy eBay customers.

Fetch Order Tracking pulls the raw order_status and logistics_status directly from AliExpress. While the AliExpress UI might group several backend states under a single 'Awaiting Dispatch' label, the API data reveals critical distinctions. Understanding these nuances is key to proactive management of your dropshipping operation.

The Core Problem: 'Awaiting Dispatch' Isn't Always 'Awaiting Dispatch'

The AliExpress API can return different values that all effectively translate to 'Awaiting Dispatch' in the user interface. Misinterpreting these can cost you time and money.

• Genuine Processing: The seller is actively preparing the order. This is the ideal state.
• Stalled Order: The seller has accepted the order but hasn't moved it forward in a reasonable timeframe. This often precedes a seller-initiated cancellation.
• Pre-Cancellation State: The order is technically 'Awaiting Dispatch' but is already flagged for cancellation by the system or the seller.

Without distinguishing these, you might wait days for an order that will never ship, missing the window to reorder or initiate a refund promptly.

API Fields to Watch for Nuance

Fetch Order Tracking gives you access to specific API fields that provide a more granular view:

• order_status: The primary status of the order.
• logistics_status: The logistics phase of the order.
• end_reason: If an order has ended (e.g., cancelled), this field explains why.
• gmt_create: The timestamp when the order was created.
• gmt_pay: The timestamp when the order was paid.
• gmt_refund: The timestamp when a refund was initiated or completed.

By combining these, you can create more intelligent alerts and workflows in your Google Sheet.

Refining Your 'Awaiting Dispatch' Workflow

Let's break down how to interpret different scenarios and what actions you should take.

Scenario 1: True 'Awaiting Dispatch'

API Indicators:

• order_status: WAIT_SELLER_SEND_GOODS
• logistics_status: WAIT_SELLER_SEND_GOODS (or null/empty, depending on specific conditions)
• gmt_refund: null/empty
• end_reason: null/empty

Interpretation: This is a healthy order. The seller has confirmed the order and is expected to ship it soon. Your focus here is on monitoring for a tracking number within your expected timeframe (e.g., 2-3 business days after gmt_pay).

Action in Sheet: Mark as 'Processing - On Track'. Set a conditional formatting rule to highlight if gmt_create + 3 days passes without a tracking number appearing.

Scenario 2: Stalled 'Awaiting Dispatch'

API Indicators:

• order_status: WAIT_SELLER_SEND_GOODS
• logistics_status: WAIT_SELLER_SEND_GOODS (or null/empty)
• gmt_refund: null/empty
• end_reason: null/empty
• Key Indicator: gmt_pay + X days (e.g., 5 days) has passed without a tracking number.

Interpretation: The seller is taking too long to dispatch. This could indicate a stock issue, a lazy seller, or an impending cancellation. This is a critical point to intervene.

Don't wait for AliExpress to tell you an order is cancelled. Proactive monitoring of stalled 'Awaiting Dispatch' orders is your first line of defense against extended refund delays and negative eBay feedback.

Action in Sheet: Mark as 'Processing - Stalled'. Initiate communication with the AliExpress seller. If no response or resolution within 24 hours, prepare to reorder from a different seller or initiate a refund if the original product is no longer viable.

Scenario 3: 'Awaiting Dispatch' with Impending Cancellation

This is where the nuance is most critical. AliExpress might still show 'Awaiting Dispatch' but the backend data hints at a problem.

API Indicators:

• order_status: WAIT_SELLER_SEND_GOODS
• logistics_status: WAIT_SELLER_SEND_GOODS (or null/empty)
• gmt_refund: A recent timestamp, even if the refund isn't fully processed yet.
• end_reason: Contains values like SELLER_CANCEL_ORDER, CLOSE_ORDER, BUYER_CANCEL_ORDER, ORDER_TIMEOUT, or descriptions related to seller inability to ship.

Interpretation: The order is technically 'Awaiting Dispatch' but the system, or the seller, has already decided to cancel it. The refund process might have already started (gmt_refund populated), or the end_reason explicitly states the cancellation cause.

Action in Sheet: Mark as 'Cancelled - Refund Pending' or 'Cancelled - Refund Initiated'. Immediately notify your eBay customer and process a refund or offer an alternative. Your goal is to get ahead of the official cancellation notification and refund process, which can sometimes lag on AliExpress.

Scenario 4: Refund Already Processed (but still 'Awaiting Dispatch' in UI)

Sometimes, the refund is already underway or even completed, but the UI hasn't fully updated or the order_status hasn't transitioned to FINISH or CLOSE yet.

API Indicators:

• order_status: WAIT_SELLER_SEND_GOODS
• logistics_status: WAIT_SELLER_SEND_GOODS (or null/empty)
• gmt_refund: A timestamp indicating a refund has been processed.
• end_reason: Could be null, or indicate a cancellation reason.

Interpretation: A refund has been processed, even if the order status hasn't fully updated to reflect it. This is common when sellers cancel quickly and the system processes the refund before fully closing the order.

Action in Sheet: Mark as 'Refunded'. Confirm the refund amount and initiate a refund for your eBay customer. This is crucial for maintaining good customer service and avoiding unnecessary delays.

Building Conditional Formatting in Google Sheets

Leverage Fetch Order Tracking's API data to build robust conditional formatting rules in your Google Sheet.

1. Stalled Orders: Highlight orders where order_status is WAIT_SELLER_SEND_GOODS AND gmt_pay + 5 days < TODAY(). Color this red.
2. Refund Initiated: Highlight orders where gmt_refund is NOT empty. Color this orange.
3. Cancellation Reason: Highlight orders where end_reason contains 'CANCEL' or 'CLOSE'. Color this purple.
4. True Awaiting Dispatch: Highlight orders where order_status is WAIT_SELLER_SEND_GOODS AND gmt_pay + 5 days > TODAY() AND gmt_refund is empty AND end_reason is empty. Color this green.

By applying these rules, your sheet will visually inform you of the true state of your 'Awaiting Dispatch' orders, allowing you to prioritize and act decisively.

Stop treating 'Awaiting Dispatch' as a monolithic status. By using the granular data provided by Fetch Order Tracking, you can build a more resilient, proactive, and profitable dropshipping operation. For more details on integrating and leveraging Fetch Order Tracking, visit our main page: Fetch Order Tracking.

---