ACBUY Spreadsheet: Your Guide to Strategic SKU Performance Monitoring
Track QC Success, Refund Rates, and Popularity to Make Data-Driven Buying Decisions
In the fast-paced world of e-commerce and dropshipping, intuition alone isn't enough. Success hinges on your ability to track, analyze, and act on key performance data. The ACBUY Spreadsheet
The Three Pillars of SKU Performance
1. QC Success Rate
This metric tracks the percentage of units that pass your quality checks before shipment. A high QC failure rate is a major red flag, indicating potential supplier issues, product flaws, or inaccurate listings.
2. Refund & Return Rate
This measures the percentage of orders that result in a refund or return request from the customer. It directly impacts profitability and customer satisfaction.
3. Popularity & Sales Velocity
This isn't just about total sales, but the pace
How to Structure Your ACBUY Monitoring Spreadsheet
A basic tracking sheet should include the following columns for each unique SKU:
| Column | Data Point | Purpose |
|---|---|---|
| SKU Code | Product Identifier | Unique reference for the product. |
| Total Units Ordered | Numeric | Base volume metric. |
| Units Failed QC | Numeric | Raw count for quality issues. |
| QC Success Rate | Formula: (1 - (Failed QC/Total Ordered))*100 | Automatic percentage calculation. |
| Customer Refunds | Numeric | Count of refund requests. |
| Refund Rate | Formula: (Refunds/Total Ordered)*100 | Automatic percentage calculation. |
| Sales Period (e.g., Last 30 Days) | Numeric (Units Sold) | Measures recent popularity. |
| Performance Tier | Formula/Classification (e.g., A, B, C) | Automated ranking based on combined metrics. |
| Action Note | Manual Input | Strategic decision based on data (e.g., "Increase stock," "Find new supplier," "Discontinue"). |
From Data to Strategy: Actionable Steps
- For "A-Tier" SKUsPrioritize these.
- For "B-Tier" SKUsInvestigate and optimize.
- For "C-Tier" SKUsEliminate or renegotiate.
- For "B-Tier" SKUsInvestigate and optimize.