Sourcing

Optimize Sourcing: Fetch Data for Product Selection

Inefficient product sourcing directly impacts your eBay store's profitability and customer satisfaction. Manually sifting through AliExpress for new products without a data-driven approach often leads to stocking items with high refund rates, slow shipping, or unreliable suppliers. Fetch Order Tracking provides the granular data you need to move beyond guesswork and make informed sourcing decisions.

Identify Problematic Products and Suppliers

Your Fetch dashboard and Google Sheet integration offer a wealth of data points to pinpoint products and suppliers causing issues. Focus on these key indicators:

High Refund Rates and Reasons

Track the gmt_refund field and associated end_reason data. A high frequency of refunds for a specific SKU, especially with recurring reasons, signals a product or supplier problem.

• 'BAD_QUALITY' / 'NOT_AS_DESCRIBED': Multiple refunds with these reasons indicate a fundamental issue with the product itself or the supplier's quality control. Stop sourcing this item immediately.
• 'MISSING_GOODS' / 'INCORRECT_GOODS': These point to supplier fulfillment errors. If it's a recurring issue with one supplier across different products, consider replacing them.
• 'BUYER_REJECT_GOODS': While sometimes a buyer-specific issue, a pattern for a particular product might suggest a common defect or misrepresentation.

Filter your Fetch data to identify SKUs with a refund rate above 5% over the last 30-60 days. Investigate the end_reason for these items. This direct feedback from buyers, aggregated by Fetch, is invaluable for auditing your current product catalog and preventing future sourcing mistakes.

Logistics Performance

Slow or inconsistent shipping directly impacts buyer experience and can lead to 'ITEM_NOT_RECEIVED' claims. Monitor logistics_status, delivery_time_days, and order_status.

• Frequent 'LOGISTICS_EXCEPTION' or prolonged 'IN_TRANSIT': If certain products or suppliers consistently show extended transit times or exceptions, they are bottlenecks. Buyers expect reasonable delivery.
• High delivery_time_days averages: Compare the average delivery time for different SKUs. If a product consistently takes 40+ days while similar items from other suppliers arrive in 15-20 days, the slower supplier is a liability.
• order_status stuck on 'WAIT_BUYER_ACCEPT_GOODS' for too long: This often correlates with slow shipping. Buyers aren't confirming receipt because they haven't received the item.

Use Fetch to identify suppliers whose average delivery_time_days for all their products exceeds your acceptable threshold (e.g., 25 days). Prioritize suppliers who consistently deliver within a competitive timeframe.

Fetch Order Tracking aggregates buyer feedback through refund reasons and provides clear logistics performance metrics. This data is your earliest warning system for product and supplier quality issues, allowing proactive adjustments to your sourcing strategy.

Identify Top-Performing Products and Suppliers

Conversely, Fetch data helps you double down on what works. Look for:

Low Refund Rates and Positive Outcomes

Products with consistently low refund rates and a high percentage of orders reaching BUYER_ACCEPT_GOODS or FINISH status indicate strong product-market fit and reliable fulfillment.

• High FINISH rate: These are orders completed without issues, indicating customer satisfaction and smooth logistics.
• Low occurrence of any end_reason: Products that rarely generate refunds are strong candidates for continued sourcing and potentially scaling.

Filter your data for SKUs with 0-1% refund rates over a significant period (e.g., 90 days). These are your winning products and the suppliers behind them are valuable partners.

Efficient Logistics

Suppliers who consistently deliver quickly and without exceptions are assets. Prioritize them for future product sourcing.

• Consistent short delivery_time_days: Identify suppliers whose average delivery time is significantly lower than your overall average.
• Minimal logistics_exception occurrences: Suppliers with a clean logistics record across many orders are reliable.

When evaluating a new product, compare its potential supplier's historical performance (if you've ordered from them before) against these benchmarks. If you're considering a new supplier, start with a small test batch of orders and meticulously track their Fetch data before scaling.

Develop a Data-Driven Sourcing Workflow

Integrate Fetch data into your regular sourcing process:

1. Weekly Performance Review: Dedicate time each week to review your Fetch data. Filter for refund rates, specific end_reason codes, and long delivery_time_days.
2. Supplier Audit: If a supplier consistently underperforms across multiple products, consider replacing them. Use the aggregated data to provide specific feedback if you wish to try and salvage the relationship.
3. Product Blacklisting/Whitelisting: Maintain internal lists of products to avoid (high refund rates, poor quality) and products to prioritize (low refunds, fast shipping).
4. New Product Vetting: Before adding a new product, try to find multiple suppliers. Place test orders with 2-3 potential suppliers and use Fetch to compare their performance on initial orders before committing to a primary supplier.
5. Trend Analysis: Look for broader patterns. Are certain product categories experiencing more quality issues? Are specific shipping lines becoming unreliable? Fetch data helps you spot these macro trends.

By systematically leveraging the detailed order tracking, refund, and logistics data provided by Fetch, you can transform your product sourcing from a speculative endeavor into a precise, data-backed operation, ensuring you stock products that delight your customers and boost your bottom line.

Ready to refine your sourcing strategy with automated data? Learn more about Fetch Order Tracking and its powerful features at Fetch Order Tracking.

---