Sourcing

Optimize Sourcing: Fetch Data for Product Selection

Inefficient product sourcing directly impacts your bottom line. You spend time listing products that generate low sales, high refund rates, or chronic shipping issues. Fetch Order Tracking provides the granular data you need to move beyond guesswork and make data-driven sourcing decisions for your eBay store.

Instead of randomly testing products, use your historical Fetch data to identify categories, suppliers, and specific items that consistently perform well or poorly. This guide details how to extract actionable insights from your Fetch Order Tracking data to refine your product selection process.

Identify High-Performing Products and Categories

Your Fetch data holds the key to understanding which products are genuinely profitable and hassle-free. Focus on metrics that indicate strong customer satisfaction and reliable fulfillment.

Analyze Profit Margins and Sales Volume

The most straightforward metric is profit. Fetch calculates your net profit for each order, factoring in product cost, shipping, and any refunds. Export your order data and sort by net_profit. Look for products or product categories that consistently show high net_profit combined with significant sales_volume.

• High-Profit, High-Volume: These are your winners. Double down on these products, explore variations, and find similar items from the same suppliers.
• High-Profit, Low-Volume: These might be niche products. Consider expanding your marketing or listing more variations if the profit per sale is substantial.

Examine Refund Rates and Reasons

Refunds are a direct hit to your profit and indicate customer dissatisfaction. Fetch tracks detailed refund data, including gmt_refund, refund_status, and end_reason.

• Filter your orders by refund_status = 'REFUND_SUCCESS' or 'REFUND_PROCESSING'.
• Group these refunded orders by product_id or aliexpress_supplier_id.
• Pay close attention to the end_reason field. Common reasons include:
• GOODS_QUALITY_ISSUE: Indicates a problem with the product itself. Avoid sourcing from suppliers with a high incidence of this.
• LOGISTICS_ISSUE: Points to shipping problems (lost, damaged, extremely late). This could be a supplier issue, a shipping method issue, or a carrier issue.
• BUYER_REASON: Less critical, as it's often buyer's remorse, but still impacts profit.

A high refund rate, especially due to 'GOODS_QUALITY_ISSUE' or 'LOGISTICS_ISSUE', is a clear signal to delist a product or find an alternative supplier, regardless of its sales volume.

Identify Problematic Products and Suppliers

Just as important as finding winners is identifying losers. Fetch data helps you proactively remove underperforming or problematic items from your inventory.

Analyze Logistics Performance

Slow or unreliable shipping is a major cause of customer complaints and refunds. Fetch tracks logistics_status and delivery_time.

• Long Delivery Times: Sort orders by delivery_time (calculated from order date to delivery date). If certain products or suppliers consistently have delivery times exceeding your target (e.g., 25-30 days), investigate.
• Frequent 'LOST' or 'DAMAGED' Status: Filter for logistics_status indicating issues like 'LOST', 'DAMAGED', or 'RETURNED_TO_SENDER'. If these are recurring for specific products or suppliers, it's a red flag.
• Stalled Tracking: Identify orders where logistics_status hasn't updated for an unusually long period (e.g., 10+ days after the last update). This often precedes a 'LOST' status.

These insights help you make decisions like:

• Switching to a faster shipping method for specific products.
• Avoiding suppliers known for poor packaging or unreliable fulfillment.
• Delisting products that are consistently problematic to ship.

Monitor Order Status and Dispute Rates

While refund_status covers successful refunds, also look at the broader order_status and aliexpress_dispute_status. A high number of orders stuck in 'PENDING_REFUND' or 'DISPUTE_IN_PROGRESS' for a particular product indicates ongoing issues, even if not yet resolved as a refund.

If you see a pattern of orders for a specific product frequently entering dispute, it's a strong indicator of underlying problems that will consume your time and impact your reputation.

Refining Your Sourcing Workflow

Integrate these data points into your regular product research and listing process.

Pre-Sourcing Checks

Before listing a new product, cross-reference potential suppliers with your historical data. Have you used them before? What was their performance like for delivery_time, refund_rate, and end_reason?

Post-Listing Monitoring

Once a product is listed, actively monitor its performance in Fetch:

1. Initial Sales Phase (First 30-60 days): Pay close attention to early refund requests, especially those related to quality or logistics.
2. Ongoing Performance: Regularly review monthly or quarterly reports from Fetch, focusing on products that deviate from your average profit margins or refund rates.

Supplier Relationship Management

Use Fetch data to identify your best and worst AliExpress suppliers. Prioritize sourcing from suppliers with a proven track record of:

• Low refund_rate, particularly for quality issues.
• Consistent and reasonable delivery_time.
• Responsive communication (though Fetch doesn't track this directly, it's often correlated with fewer unresolved issues).

By systematically applying these data-driven insights from Fetch Order Tracking, you can significantly reduce your risk, improve customer satisfaction, and ultimately boost the profitability of your eBay dropshipping business.

Ready to put your data to work? Start optimizing your sourcing with Fetch today.

---