Step-by-step setup for a 2026 Kakobuy spreadsheet
- Create your core columns. Use: Item Name, Store Link, Agent Link, Category, Size, Color, CNY Price, Local Currency Price, Domestic Shipping, Quantity, Warehouse Status, QC Status, Estimated Weight, Actual Weight, Shipping Line, Service Fee, Coupon Used, Total Landed Cost, and Keep/Return. These 19 fields are enough for most hauls without making the sheet slow or messy.
- Lock your exchange rate. Add one cell at the top called “CNY Rate” and reference it in every price formula. For example, if the rate is 0.14 USD in March 2026, your local price formula can be CNY Price × 0.14. When the rate changes, update one cell instead of 40 rows.
- Separate estimate from reality. Before the item arrives, enter an estimated weight, such as 650 g for sneakers, 350 g for a hoodie, or 120 g for accessories. After warehouse intake, replace only the Actual Weight field. This helps you compare seller claims against warehouse data.
- Add QC decision rules. Use simple dropdowns: Pending, Pass, Minor Flaw, Return, Exchange. If a logo, stitching, size tag, or sole shape looks off, mark the reason in a Notes column before approving shipment. For a ready-made layout, check it out and copy the sections that match your haul size.
- Calculate landed cost per item. Split international shipping by actual weight. If your parcel costs $82 to ship and weighs 6,200 g, the shipping rate is about $0.0132 per gram. A 700 g pair of shoes adds about $9.24 in international shipping, which is far more useful than looking only at the product price.
Practical columns that prevent expensive mistakes
The best Kakobuy spreadsheet is not just a shopping list; it is a risk control tool. Add a “Return Deadline” column because many sellers allow only a short window after warehouse arrival. Add “Photo Needed” for close-ups such as labels, measurements, embroidery, zippers, or outsole patterns. Add “Parcel Plan” if you split shipments into 3 kg, 5 kg, or 8 kg boxes to manage customs exposure and shipping rates.
For budgeting, create three totals: product subtotal, domestic plus service fees, and international shipping estimate. A 12-item haul might look cheap at 1,850 CNY, but after 90 CNY domestic shipping, 120 CNY service-related costs, and $95 international shipping, the real number changes quickly. This is where Kakobuy planning pays off: you can remove low-value items before they inflate parcel weight.
2026 maintenance checklist
- Update exchange rates weekly, especially before large purchases.
- Record actual warehouse weight within 24 hours of item arrival.
- Flag any item over 1,000 g for shipping-cost review.
- Keep screenshots of seller pages, because listings can disappear after purchase.
- Archive completed hauls by month, such as “2026-04 Spring Parcel.”
Short FAQ
How many items should one sheet handle? For speed and clarity, keep one tab to 50-75 rows. If you buy monthly, create a new tab per parcel rather than one endless list.
Should I track coupons? Yes. A 30 CNY coupon on a 240 CNY item is a 12.5% reduction, but only if you record it before calculating landed cost.
What is the most important formula? Landed cost per item. Product price alone is misleading; weight-based shipping can turn a bargain into an expensive purchase.
Build the sheet once, update it every time an item moves status, and use the numbers before approving shipment; for a clean starting point, read more here.