Workflow

Managing eBay Multi-Item Orders with Mixed SKUs

You've scaled your eBay dropshipping operation, and now you're regularly seeing orders with multiple distinct items. A customer might buy a phone case, a screen protector, and a charging cable all in one eBay transaction. Each of these items could be sourced from a different AliExpress supplier, or even the same supplier but as separate SKUs with unique tracking numbers.

This scenario introduces complexity beyond single-item orders:

• Multiple AliExpress order IDs per eBay order.
• Different tracking numbers for each line item.
• Varying delivery times and statuses for each item.
• Partial refunds or returns for individual items within a larger order.

Fetch Order Tracking is built to handle this. Instead of treating an eBay order as a single unit, it breaks down the order into its constituent line items, allowing granular tracking and refund detection for each component.

How Fetch Order Tracking Manages Multi-Item Orders

When you link your eBay store, Fetch Order Tracking pulls each line item from an eBay order. For example, if an eBay order (e.g., 1234567890) contains three distinct items:

1. Item A: 'Premium Phone Case'
2. Item B: 'Tempered Glass Screen Protector'
3. Item C: 'Fast Charging USB Cable'

Fetch will create three separate entries in your Google Sheet, each corresponding to one of these line items. Each entry will have its own row, even though they share the same ebay_order_id.

Mapping AliExpress SKUs to eBay Line Items

The core of managing mixed SKUs is accurately linking your AliExpress purchases to the correct eBay line items. When you fulfill an eBay order by placing orders on AliExpress, you'll record the AliExpress order ID(s) and tracking number(s) in your Google Sheet. For multi-item orders, you'll do this for each line item.

For example, using the eBay order 1234567890:

• Line Item 1 (Phone Case): You source this from AliExpress Order ALX111, tracking TRK111. You'll update the row for the phone case with these details.
• Line Item 2 (Screen Protector): Sourced from AliExpress Order ALX222, tracking TRK222. You'll update its respective row.
• Line Item 3 (USB Cable): Sourced from AliExpress Order ALX333, tracking TRK333. This row gets its own updates.

Each row in your sheet will then show the specific aliexpress_order_id and tracking_number for that particular line item. Fetch will then query the AliExpress API for each of these distinct tracking numbers, providing granular status updates.

Treat each eBay line item as an independent unit for sourcing and tracking. This granular approach is critical for accurate status updates and refund detection in complex orders.

Tracking Individual Item Statuses

With each line item having its own aliexpress_order_id and tracking_number, Fetch Order Tracking can report individual statuses. Your sheet columns will reflect this:

• order_status: This will show the overall AliExpress order status (e.g., BUYER_ACCEPT_GOODS, FINISH, CANCELLED) for that specific line item's AliExpress order.
• logistics_status: Provides the detailed shipping status for that line item's tracking number (e.g., IN_TRANSIT, DELIVERED, WAITING_FOR_PICKUP).
• estimated_delivery_date: Unique to each item's tracking.

This means you could have one line item from an eBay order show logistics_status: DELIVERED while another shows logistics_status: IN_TRANSIT. This is the expected behavior for mixed SKU orders.

Detecting Refunds and Disputes for Specific Items

One of the most valuable features for multi-item orders is the ability to detect refunds and disputes at the line-item level. If a customer opens a dispute for only the 'Screen Protector' from our example order, Fetch will detect this specific dispute associated with ALX222.

• gmt_refund: This column will show the timestamp of the refund request for that specific AliExpress order.
• refund_status: Will indicate the current status of the refund (e.g., REFUND_SUCCESS, WAIT_SELLER_AGREE, REFUND_CLOSED).
• end_reason: Provides the reason for the refund or dispute, specific to that line item (e.g., ITEM_NOT_RECEIVED, ITEM_NOT_AS_DESCRIBED).

This prevents false positives for refunds on items that were delivered successfully, and ensures you only act on actual disputes relevant to specific failed deliveries or product issues.

Handling Partial Refunds on eBay

If you issue a partial refund on eBay for only one of the items in a multi-item order, Fetch will not automatically detect this directly from eBay (as it focuses on AliExpress refunds). However, the underlying AliExpress refund detection for the specific line item will still function. You can use the notes column in your sheet to record the eBay partial refund and reconcile it with the AliExpress status if necessary.

Best Practices for Your Workflow

1. Record AliExpress IDs per Line Item: Ensure that when you fulfill, you populate the aliexpress_order_id and tracking_number for each individual line item in your Google Sheet. Do not just put one AliExpress ID for the entire eBay order if it contains multiple items sourced separately.
2. Monitor Individual Statuses: Regularly filter or sort your sheet by ebay_order_id to see all components of a single eBay order. This helps you understand the overall delivery picture for your customer.
3. Automate Notifications: Set up conditional formatting or Google Apps Script triggers to alert you when any line item's logistics_status changes to DELIVERED, or if a refund_status appears for any item.
4. Reconcile Disputes: If a customer contacts you about a specific item, use the line-item data in Fetch to quickly pull up the relevant AliExpress order and tracking information to resolve the issue efficiently.

By leveraging Fetch Order Tracking's line-item granularity, you transform the complexity of multi-item, mixed SKU orders into manageable, trackable units, improving customer service and your refund management.

Ready to streamline your multi-item order tracking? Learn more at Fetch Order Tracking.

---