Refunds
Tracking Partial Refunds on AliExpress Multi-Item Orders
A common pain point for eBay dropshippers sourcing from AliExpress is managing partial refunds. When a customer orders multiple items, and only one is eligible for a refund, AliExpress processes this differently than a full order cancellation. Manually reconciling these partial refunds across dozens or hundreds of orders quickly becomes a bottleneck, leading to missed refund claims and eroded profit margins.
Fetch Order Tracking addresses this by providing granular visibility into partial refunds, distinguishing them from full refunds or order cancellations. This ensures you always know the exact status of every item in a multi-item order, even when only a subset is refunded.
How AliExpress Handles Partial Refunds
AliExpress’s refund system is designed around individual order items, even within a single transaction. When a buyer initiates a refund for one item in a multi-item order, the order_status for the overall order typically remains BUYER_ACCEPT_GOODS or FINISH if other items were successfully delivered. The refund status is instead reflected at the item level or through specific refund fields.
The critical distinction is that a partial refund does not change the primary order_status to something like CANCELLED or REFUNDED for the entire order. Instead, new data points emerge related to the specific item(s) being refunded.
Identifying Partial Refunds in Fetch Order Tracking
Fetch Order Tracking pulls detailed refund data directly from the AliExpress API. When a partial refund occurs, you won't necessarily see a global refund_status change for the entire order, but rather specific indicators related to the refunded item's transaction.
gmt_refund(Refund Timestamp): This field will populate with a timestamp indicating when the refund was processed. For partial refunds, this timestamp will correspond to the individual item's refund event, not necessarily the original order creation or completion.refund_status(Item-level): While not always a direct API field at the 'order' level, Fetch's processing logic identifies and surfaces the status of individual refund requests linked to specific items within an order. This might manifest as a new row in your sheet or an updated status for the affected item.end_reason(Refund Reason): This field will provide the reason for the partial refund (e.g., 'ITEM_NOT_AS_DESCRIBED', 'DAMAGED_ITEM', 'MISSING_PARTS'). This is crucial for understanding the root cause and potentially adjusting your product listings or supplier selection.
Manually tracking partial refunds is a losing battle. The key is to automate the detection of
gmt_refundand associated item-level details to prevent profit leakage on multi-item orders.
Workflow for Tracking Partial Refunds
Integrating partial refund tracking into your existing Google Sheets workflow with Fetch Order Tracking is straightforward.
1. Initial Order Import
When you import an AliExpress order with multiple items, Fetch creates a single entry for the order but maintains internal data structures for each item within that order. Your initial sheet might show one row per order, with consolidated pricing.
2. Monitoring for Refund Events
Fetch continuously monitors your AliExpress orders for status changes, including refund events. When an AliExpress buyer initiates a refund for one item in a multi-item order, the system detects this specific event.
3. Data Population in Google Sheets
Upon detection of a partial refund, Fetch updates the relevant row in your Google Sheet. Depending on your sheet's configuration and the level of detail you require, this could manifest in a few ways:
- New Refund-Specific Columns: If you've configured your sheet to include columns like
gmt_refund,refund_amount, orrefund_reason, these will populate for the specific item that was refunded. For items not refunded, these fields will remain empty or show 'N/A'. - Item-Level Breakdown (Advanced): For users requiring extreme granularity, Fetch can be configured to create separate rows or nested data structures for each item within a multi-item order, allowing you to track the
refund_statusandgmt_refundfor each individual item independently. This is particularly useful for complex inventories. - Automated Alerts: You can set up conditional formatting or Google Sheets scripts to highlight rows where
gmt_refundis populated but the overallorder_statusis notCANCELLED, indicating a partial refund event.
Example Scenario
Imagine an eBay buyer purchases a phone case ($10) and a screen protector ($5) from your store, sourced from a single AliExpress order. The phone case arrives, but the screen protector is damaged. The buyer requests a refund for only the screen protector.
- Initial Fetch Sync: Your sheet shows an order for $15 (phone case + screen protector).
order_status:PENDING, thenSHIPPED, thenBUYER_ACCEPT_GOODS.gmt_refund: empty. - Partial Refund Event: AliExpress processes a refund for $5 for the screen protector. The overall
order_statusremainsBUYER_ACCEPT_GOODS. - Fetch Update: Fetch detects the refund event. The
gmt_refundcolumn for this order updates with the timestamp of the $5 refund. A new column, perhapspartial_refund_amount, shows $5, andend_reasonshows 'DAMAGED_ITEM'. Your total profit calculation for that order automatically adjusts, reflecting the $5 refund.
Without Fetch, you might only see the BUYER_ACCEPT_GOODS status and assume full delivery, missing the $5 refund you need to claim from your supplier or account for in your profit calculation.
Preventing Profit Loss
The primary benefit of accurate partial refund tracking is preventing profit leakage. Each missed partial refund on AliExpress represents money left on the table. By automating the detection and logging of these events, you can:
- Timely Supplier Claims: Immediately identify which items were partially refunded and initiate a claim with your AliExpress supplier, ensuring you recover your costs.
- Accurate Accounting: Maintain precise profit and loss statements, as all incoming and outgoing funds are correctly accounted for.
- Improved Decision Making: Use
end_reasondata to identify problematic products or suppliers that frequently lead to partial refunds, informing future sourcing decisions.
Fetch Order Tracking ensures that even the most granular refund events, like a partial refund on a multi-item order, are captured and presented in your Google Sheet, giving you complete financial visibility and control over your dropshipping operations. Start streamlining your refund tracking today by visiting Fetch Order Tracking.