Workflow

Actual vs. Promised Delivery Times in Fetch Reports

A common friction point in eBay × AliExpress dropshipping is the discrepancy between AliExpress's promised delivery windows and the actual time it takes for an order to reach your customer. These delays can lead to increased 'Item not received' cases, negative feedback, and ultimately, lower seller ratings on eBay. Manually tracking these differences across hundreds or thousands of orders is impossible. Fetch Order Tracking automates this comparison, allowing you to quickly identify underperforming suppliers and shipping methods.

Understanding AliExpress Promised Delivery

When you place an order on AliExpress, the platform typically provides an estimated delivery window. This isn't a guaranteed date but a projection based on the chosen shipping method, origin, and destination. Fetch captures this information directly from the AliExpress API for each order.

Key Data Points for Analysis

• gmt_create: The timestamp when the AliExpress order was placed. This is your starting point.
• gmt_expected_arrive_end: The latest date AliExpress promised the package would arrive. This is your target.
• gmt_actual_arrive: The timestamp when the package was actually delivered, according to the tracking carrier. This is your actual result.
• order_status: The current status of the AliExpress order (e.g., WAIT_SELLER_SEND_GOODS, WAIT_BUYER_ACCEPT_GOODS, FINISH, CANCELLED).
• logistics_status: The detailed logistics status (e.g., WAIT_PACKAGE_RECEIVE, ON_THE_WAY, DELIVERY_SUCCESS, DELIVERY_FAILED).

Setting Up Your Comparison in Google Sheets

Fetch's core function is to pull these data points into your Google Sheet. Once you have the data, you can build simple formulas to calculate the differences and highlight issues.

Step-by-Step Workflow

1. Ensure Data Sync: Verify that your Fetch setup is correctly syncing all relevant fields, especially gmt_create, gmt_expected_arrive_end, and gmt_actual_arrive. If these columns are missing, adjust your Fetch configuration.

2. Filter for Completed Orders: Focus your analysis on orders that have reached a definitive delivery status. Filter your sheet where logistics_status is DELIVERY_SUCCESS and order_status is FINISH or BUYER_ACCEPT_GOODS. This ensures you're only evaluating orders that have actually been delivered.

3. Calculate Days Promised: In a new column (e.g., 'Days Promised'), use a formula to calculate the duration of the promised window. If gmt_create is in column C and gmt_expected_arrive_end is in column D, the formula would be =DAYS(D2, C2).

4. Calculate Actual Delivery Days: In another new column (e.g., 'Actual Delivery Days'), calculate the actual time taken. If gmt_actual_arrive is in column E, the formula is =DAYS(E2, C2).

5. Calculate Difference: Create a 'Delivery Difference' column: =F2-G2 (assuming 'Days Promised' is F and 'Actual Delivery Days' is G). A positive number means it was delivered *before* the promised end date, a negative number means it was *late*.

6. Conditional Formatting: Apply conditional formatting to the 'Delivery Difference' column. Highlight cells with negative values (late deliveries) in red, and positive values (early or on-time) in green or blue. This provides immediate visual cues.

The true value of comparing actual vs. promised delivery lies in identifying systemic issues, not just individual late orders. Look for patterns across suppliers, shipping methods, or specific product categories.

Analyzing the Results and Taking Action

Once your sheet is set up, you can start drilling down into the data.

Identifying Problematic Suppliers

Sort your data by the 'Delivery Difference' column, or use pivot tables to group orders by supplier_name. If you see a particular supplier consistently delivering past their promised window, even by a few days, it's a red flag. This impacts your eBay seller metrics directly.

• Action: Consider finding alternative suppliers for those products, or communicate directly with the supplier about their shipping performance.

Evaluating Shipping Methods

AliExpress offers various shipping options (e.g., AliExpress Standard Shipping, ePacket, Cainiao). Group your data by logistics_channel (Fetch field for shipping method) to see which methods are consistently underperforming. Some cheaper options might have longer promised windows but also a higher rate of exceeding them.

• Action: Adjust your default shipping methods for certain products or destinations, even if it means slightly higher costs, to improve delivery reliability.

Proactive Customer Communication

For orders that are clearly tracking late based on your 'Delivery Difference' calculations, you can proactively message your eBay customers. A simple update like, "We've noticed a slight delay with your order, but it's still on its way!" can significantly reduce 'Item not received' cases and manage expectations, preventing negative feedback.

Refund Detection and Automation

Fetch also monitors for gmt_refund and end_reason. While not directly tied to delivery time, consistent delivery delays often precede refund requests. If an order is significantly past gmt_expected_arrive_end and you see a refund initiated, it's a clear signal to investigate the cause.

By regularly reviewing these reports, you move beyond reactive problem-solving to proactive optimization of your dropshipping operation. This data-driven approach allows you to make informed decisions that protect your eBay seller account and improve customer satisfaction. Get started with detailed order tracking and analysis at Fetch Order Tracking.

---