Getting Started with Your First Kakobuy Spreadsheet
The Kakobuy spreadsheet is designed to be intuitive even for first-time users. This step-by-step tutorial walks you through everything from downloading the template to submitting your first organized haul. By the end of this guide, you will be using the spreadsheet like a pro, tracking orders with confidence and calculating shipping costs with precision.
You do not need advanced spreadsheet skills. If you can fill out a form, you can use the Kakobuy spreadsheet. The template comes with pre-built formulas, dropdown menus, color coding, and example rows that teach you by showing rather than telling.
Step-by-Step Setup Guide
Step 1
Download the Template
Visit the Kakobuy resources page and download the official spreadsheet template. It is available in Google Sheets, Microsoft Excel, and Apple Numbers formats. Choose the format that matches your preferred platform.
Step 2
Open and Explore
Open the template and spend five minutes exploring the structure. Notice the example rows, the color-coded columns, and the pre-built formulas in the Total Cost column. Do not delete the example rows yet, they are your training wheels.
Step 3
Set Your Destination
In the Settings tab, enter your destination country and preferred default shipping line. These values populate dropdown menus throughout the spreadsheet and pre-fill your shipping estimates.
Step 4
Add Your First Item
Start a new row below the examples. Enter the product name, paste the product URL, select the category from the dropdown, enter the price in CNY, and choose your size and color. The spreadsheet handles the rest.
Step 5
Estimate Shipping
Use the Weight Estimation column to guess your item weight. The spreadsheet automatically calculates shipping costs across all available carriers. Compare and choose your preferred line.
Step 6
Share and Submit
Once your list is complete, share the spreadsheet link with your agent or paste it into your Kakobuy order notes. Your agent uses the spreadsheet as the source of truth for your entire order.
Spreadsheet Column Reference
Each column in the Kakobuy spreadsheet serves a specific purpose. Understanding what goes where ensures accurate calculations and clear communication with your agent.
| Column | What to Enter | Required? | Notes |
|---|---|---|---|
| Item Name | Product name or description | Yes | Keep it short but descriptive |
| Product URL | Full Weidian/Taobao link | Yes | Agents need this to purchase |
| Category | Select from dropdown | Yes | Affects weight estimation |
| Price (CNY) | Item cost in yuan | Yes | Check current exchange rate |
| Size | Your selected size | Yes | Include region like EU/US/CM |
| Color | Colorway or variant | Yes | Be specific: "Black/White" not "B/W" |
| Qty | Number of units | Yes | Default is 1 |
| Est. Weight | Estimated kg per item | Recommended | Use reference table for accuracy |
| Shipping Line | Select from dropdown | Recommended | Can change later |
| Notes | Special requests | Optional | Extra laces, no box, etc. |
Using the Built-in Formulas
The Kakobuy spreadsheet template comes with pre-built formulas that calculate totals automatically. These formulas are your shortcut to accurate budgeting. Here is how they work and how to use them correctly.
Total Cost Column
Automatically multiplies Price x Quantity and adds estimated domestic shipping. Formula: =B2*C2+D2
Shipping Estimates
Uses VLOOKUP against the shipping rate table in the Settings tab. Updates automatically when you change destination or weight.
Grand Total
Sums all item costs, all shipping costs, and adds the Kakobuy service fee percentage. Gives your true final cost.
Advanced Features
Once you are comfortable with the basics, the Kakobuy spreadsheet offers advanced features that power users love. These tools transform your spreadsheet from a simple list into a full logistics management platform.
Multi-Destination Shipping
Add multiple destination tabs to compare shipping costs for friends in different countries. Perfect for group buys where members live in different regions.
Seasonal Planning
Use separate sheets for Winter Haul, Summer Haul, and Sale Season. Track what you ordered when, and plan future purchases around shipping line performance data.
Reseller Profit Tracking
Add columns for resale price, platform fees, and net profit. Track which items from which sellers deliver the best margins after all shipping and fees.
QC Photo Links
Add a column for QC photo URLs. Paste the warehouse photo links directly into your spreadsheet for permanent record keeping even after items ship.
🌟 Beginner Tips for Success
- •Start with a small haul of 2-3 items to learn the process before committing to a large order.
- •Always round weight estimates up slightly. Better to overestimate shipping than underestimate and face surprise charges.
- •Save a backup copy of your spreadsheet before sharing it with anyone.
- •Use the Notes column generously. Agents read these notes and fulfill requests like \"no box\" or \"extra QC photos.\"
Frequently Asked Questions
Basic spreadsheet knowledge is helpful but not required. The Kakobuy template is pre-built with formulas and instructions. If you can type data into cells, you can use the Kakobuy spreadsheet.