Building the Ultimate Superbuy Spreadsheet
When planning your Superbuy haul budget, conscientious spreadsheet setup separates rookie shoppers from veteran taobao
Budget Allocation Framework
- The 60/30/10 Rule
- Priority Tier System
- Dynamic Currency Columns
Yupoo Integration Techniques
Power users recommend embedding Superbuy Yupoo
- Screenshot grid: ALT+PRTSC → paste to create visual catalogs
- Hyperlinked cell: ="¥"&B3&" - "&HYPERLINK(C3,"QC Pics")
- QC Checklist: =IF(D3="Done",CHAR(10004),"Pending")
Coupon & Shipping Logic Functions
Auto-Discount Column:
=VLOOKUP(A3,Coupons!B:D,3,FALSE)*0.95
Shipping Calculator:
=IFS(E3>5000,"SAL",E3>2000,"EMS",TRUE,"DHL")
Discord's @superbuyLoyaltyPro17Superbuy.life
Multisource Data Merging
Source | Import Method | Sync Frequency |
---|---|---|
Taobao Wishlist | CSV Export | Pre-Purchase |
Yupoo Favorites | Manual Entry | Weekly |
Superbuy Promos | RSS Feed | Daily |
The Shipping Variable Factor3>
Reddit user delivertootracking89's volumetric weight formula changed the game:
=IF(SUM(F3:F10)*1.33>actual_weight, (L*W*H)/6000, actual_weight)