Home > Hoobuy Buying Agent Cross-Platform Price Comparison: How to Consolidate Coupon Resources Using Spreadsheet

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

  1. Highlight items with coupon indicators in your spreadsheet
  2. Upload your Excel file when submitting Hoobuy's "Expert Purchase" form
  3. Include coupon claim links in the "Special Instructions" column
  4. 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.

Last updated: November 2023 | Shopping guides coming weekly
```