Hoobuy Buying Agent Cross-Platform Price Comparison: How to Consolidate Coupon Resources Using Spreadsheet
2025-07-27
For international shoppers using Hoobuy
Step 1: Source Your Shopping List
- Item names in original Chinese
- Preferred platforms (Taobao, Tmall, JD, Pinduoduo)
- Base prices (Yuan/RMB)
- String IDs (to help Hoobuy agent locate identical items)
Item | Taobao Price | Tmall Price | JD Price | Active Coupons |
---|---|---|---|---|
iPhone 15 Pro Case | ¥89 | ¥99 | ¥109 | Taobao: NEW10 (-¥10) |
AirPods Pro 2023 | ¥1449 | ¥1399 | ¥1299 | JD: JDFLASH200 (-¥200) |
Step 2: Coupon Tracking Formulas
=IFERROR(VLOOKUP(A2,Coupon_DB!A:F,6,FALSE),"None") // Checks centralized coupon database =MIN(B2:D2)-IF(E2="None",0,VALUE(REGEXTRACT(E2,"(-¥\d+)"))) // Calculates final price
Step 3: Hoobuy Integration
- Highlight items with coupon indicators in your spreadsheet
- Upload your Excel file when submitting Hoobuy's "Expert Purchase" form
- Include coupon claim links in the "Special Instructions" column
- Mark time-sensitive coupons with red font warnings
Pro Tip:
``` With proper spreadsheet organization, you can reduce Hoobuy procurement costs by 15-40% through strategic coupon stacking across China's competing e-commerce platforms.