For power buyers navigating global marketplaces, a systematic approach to seller management is key. The Kakobuy Spreadsheet method is a popular community-driven solution for tracking, evaluating, and organizing sellers. This guide walks you through creating your own personalized database.
Step 1: Duplicate the Master Spreadsheet
Locate the community-shared Kakobuy Master Spreadsheet. This template contains the essential structure. Use the "File" menu to create a copy
File - Make a Copy - Name it "My Kakobuy Seller Database"
Step 2: Create Personalized Seller Tabs
The master sheet likely has one primary tab. Your goal is to create individual tabs for each seller.
- Rename the first tab:
- Add new sheets:
- Standardize columns:Product Link, Date Ordered, Price Paid, QC Photos Received, QC Rating, Ship Date, Delivery Date, and Notes.
- Add new sheets:
Step 3: Rank Sellers with Performance Metrics
The true power of the database comes from ranking sellers to inform future purchases. Focus on two critical metrics:
1. QC (Quality Control) Performance
Rate sellers based on product accuracy, consistency, and proactiveness in providing pre-shipment photos. Use a simple scale (e.g., 1-5):
- 5:
- 3:
- 1:
- 3:
Log this score in the seller's tab and on your master Dashboard.
2. Delivery Speed & Logistics
Calculate the time from order confirmation to delivery. Track both:
- Processing Speed:
- Transit Speed:
Create an average speed score or tier (e.g., "Fast: < 10 days", "Medium: 10-20 days", "Slow: 20+ days").
Step 4: Build a Summary Dashboard
Your "Dashboard" tab is the command center. It should provide an at-a-glance view of all sellers. Key columns include:
| Seller Name | Primary Category | Avg. QC Score | Avg. Delivery Days | Total Orders | Trust Tier | Link to Tab |
|---|---|---|---|---|---|---|
| Example: CoolKicks | Sneakers | 4.5 | 12 | 8 | A - Trusted | [View Log] |
Use spreadsheet functions like AVERAGEVLOOKUP
Maintaining Your Advantage
By diligently updating your Kakobuy Seller Database, you transform subjective experience into objective data. This allows you to:
- Quickly identify your top-performing sellers for different product types.
- Spot negative trends (e.g., a seller's QC score dropping).
- Make informed, low-risk purchasing decisions based on historical performance.
Start with a few frequent sellers, refine your tracking columns as needed, and let the data guide your buying strategy.