ACBUY Spreadsheet: Your Master Guide to Strategic SKU Performance Tracking
2025-12-10
Master your sourcing strategy by systematically monitoring QC success, refund rates, and product popularity across all orders.
In the fast-paced world of e-commerce and dropshipping, data is your most valuable asset. The ACBUY Spreadsheet
The Three Pillars of SKU Performance
1. Quality Control (QC) Success Rate
What it tracks:
How to calculate:
Strategic Insight:
2. Customer Refund & Return Rate
What it tracks:
How to calculate:
Strategic Insight:
3. Popularity & Sales Velocity
What it tracks:
Key Data Points:
Strategic Insight:
Structuring Your ACBUY Performance Spreadsheet
A simple, consistent table is key. Here’s a recommended column structure:
| SKU Code | Product Name | Order Date | Units Ordered | Units QC Passed | QC Pass Rate % | Units Sold | Units Refunded | Refund Rate % | Sales Last 30 Days | Popularity Trend | Action/Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACB-WT001 | Wireless Earbuds | 2023-10-15 | 100 | 94 | 94.0% | 88 | 5 | 5.7% | 45 | Steady ↑ | Good performer. Monitor QC. |
| ACB-LS202 | LED Desk Lamp | 2023-10-10 | 50 | 45 | 90.0% | 40 | 8 | 20.0% | 12 | Slow ↓ | High Risk! |
From Data to Strategic Buying Decisions
- For High-Performing SKUs (High QC, Low Refund, High Popularity):Increase order quantities, consider negotiating bulk discounts, and feature them prominently in marketing.
- For SKUs with Low QC Pass Rates:Conduct root-cause analysis. Communicate with the supplier, request replacements, or seek alternative suppliers before reordering.
- For SKUs with High Refund Rates (but decent QC):Re-evaluate product description/imagery for accuracy. Check packaging and shipping methods. The issue may be mismatched customer expectations.
- For Low-Popularity SKUs:Liquidate stock, avoid reordering, and analyze why they aren't selling (price, marketing, competition).