Workflow

End-to-End Test: Simulating Full eBay → AliExpress Order Lifecycle

When integrating a new system or onboarding a new team member, you need to verify the entire eBay to AliExpress dropshipping workflow. A full end-to-end test ensures that orders are correctly tracked, status changes are recognized, and potential refund scenarios are flagged. This isn't about testing individual API calls, but about observing the system's behavior across a realistic timeline.

We'll simulate a complete order lifecycle, from a new eBay order appearing in your sheet to its eventual delivery or a refund scenario, using Fetch Order Tracking and a few manual steps to mimic external events.

Phase 1: Order Placement & Initial Tracking

The first step is to get an order into your system and confirm initial tracking is active.

1.1 Create a Test eBay Order

Since you can't create a 'fake' eBay order that will appear in your live feed without a buyer, the simplest approach is to use a low-value item you're willing to purchase or have a friend purchase from your eBay store. Alternatively, if you have access to historical data, you can manually input an old order's details into your Fetch Order Tracking sheet to simulate a new order appearing.

• Scenario A (Live Test): List a low-cost item on eBay. Have a separate eBay account (or a friend) purchase it.
• Scenario B (Simulated Test): Manually add an existing eBay Order ID and its corresponding AliExpress Order ID (if already placed) into your Fetch Order Tracking input sheet. Ensure the order_status is set to 'NEW' or equivalent to simulate a fresh order.

For this walkthrough, let's assume you've used Scenario B and manually added an order. Ensure the eBay_Order_ID and AliExpress_Order_ID fields are populated.

1.2 AliExpress Order Placement & Initial Logistics

Once the eBay order is 'received', you would typically place the order on AliExpress. For our test, we assume this has already happened or you do it immediately after 'receiving' the eBay order.

• Place the order on AliExpress using the buyer's details.
• Once the AliExpress order is confirmed, Fetch Order Tracking will begin monitoring it.

Initially, the order_status from Fetch will likely be 'AWAIT_PAY', then 'WAIT_SELLER_SEND_GOODS'. The logistics_status will be 'PLACE_ORDER_SUCCESS'.

A successful end-to-end test isn't just about data populating; it's about verifying that each status transition correctly triggers subsequent actions or alerts within your operational workflow.

Phase 2: Shipping & Transit

This phase verifies that tracking updates correctly and the system recognizes progress.

2.1 Seller Ships Item

After a few days (or hours if you're lucky with a fast seller), the AliExpress seller will ship the item. This is a critical tracking update.

• Expected Behavior: Fetch Order Tracking will update the logistics_status. It will likely move from 'PLACE_ORDER_SUCCESS' to 'WAIT_BUYER_RECEIVE_GOODS'. The order_status will typically remain 'WAIT_SELLER_SEND_GOODS' until the tracking number is generated and active, then it might transition to 'WAIT_BUYER_RECEIVE_GOODS' or similar.
• Verify: Check your Fetch Order Tracking sheet. Look for changes in logistics_status and the presence of a tracking_number.

2.2 Item in Transit

Over the next few days/weeks, the item will move through various logistics stages. Fetch Order Tracking will continually poll for updates.

• Expected Behavior: The logistics_status will update progressively (e.g., 'IN_TRANSIT', 'ARRIVED_AT_DESTINATION_COUNTRY', 'DELIVERY_IN_PROGRESS').
• Simulate: You can't directly control AliExpress logistics updates. The best way to test this is to monitor a real order over its transit time. For a faster test, you might use an old order that already completed transit and observe its final status, but this won't show the intermediate steps in real-time.

Phase 3: Delivery & Completion

This is the ideal outcome - the item is delivered to the customer.

3.1 Item Delivered

Eventually, the item will be delivered to the buyer.

• Expected Behavior: The logistics_status will update to 'DELIVERED'. The order_status will typically move to 'BUYER_ACCEPT_GOODS' or 'FINISH'.
• Verify: Confirm these status changes in your Fetch Order Tracking sheet. This signals the end of the active tracking period for this order.

Phase 4: Refund Scenarios (Optional but Recommended)

A robust workflow must account for refunds. Testing this ensures your refund detection and management are working.

4.1 Open a Dispute (Buyer Initiated)

This simulates a buyer opening a dispute on AliExpress.

• Simulate: On the AliExpress order page for your test order, manually open a dispute. Choose a reason like 'Item not received' or 'Quality issue'. Do not resolve it immediately.
• Expected Behavior: Fetch Order Tracking will detect the dispute. The order_status will likely change to 'FUND_PROCESSING' or 'IN_DISPUTE'. The gmt_refund field will populate with the time the refund process started.
• Verify: Check your sheet for these changes. This is where your refund detection and alert system should trigger.

4.2 Dispute Resolution (Refund Granted)

If the dispute is resolved in favor of the buyer, a refund is issued.

• Simulate: On AliExpress, proceed with the dispute resolution, granting a full or partial refund.
• Expected Behavior: The order_status will update to 'FINISH' (if the order is closed with a refund) or remain 'FUND_PROCESSING' until the refund is fully processed. The refund_status and refund_amount fields will populate.
• Verify: Confirm the updated status and refund details in your Fetch Order Tracking sheet. This is crucial for reconciling your finances.

4.3 Dispute Resolution (Dispute Closed, No Refund)

Sometimes, a dispute is opened but then closed without a refund (e.g., buyer found item, seller provided proof).

• Simulate: Open a dispute on AliExpress and then manually close it without a refund, or have the seller reject it successfully.
• Expected Behavior: The order_status will revert to its previous non-dispute status (e.g., 'BUYER_ACCEPT_GOODS' or 'FINISH') or a specific 'DISPUTE_CLOSED_NO_REFUND' type status, and the gmt_refund field might clear or update to reflect the closure without a payout.
• Verify: Observe the status changes. Ensure your system doesn't incorrectly flag a refund where none occurred.

Conclusion

By walking through these phases, you gain confidence that your Fetch Order Tracking integration is correctly capturing the full lifecycle of your eBay to AliExpress dropshipping orders. This end-to-end testing highlights any gaps in your automation or manual processes, ensuring you're prepared for both successful deliveries and common refund scenarios.

For more details on specific fields and their meanings, refer to the Fetch Order Tracking documentation.

---