For users managing large order lists, efficient price comparison is key. This guide shows you how to leverage LoongBuy's public spreadsheet data alongside powerful tools to benchmark prices against agents like CNFANS and Kakobuy.
Why Use Spreadsheet Tools for Agent Comparison?
Managing a large haulLoongBuy's public spreadsheet datacentralized, dynamic price dashboard.
- Accuracy:
- Efficiency:
- Informed Decisions:
Recommended Spreadsheet Tools & How to Use Them
1. Google Sheets
Best for:
Workflow:
- Create a new Google Sheet with columns for
Item Name,Product Link,LoongBuy Price (¥),CNFANS Price (¥),Kakobuy Price (¥), andLowest Price Agent. - Import or paste LoongBuy's public data into your sheet.
- Use the
IMPORTHTMLIMPORTXMLpull live product data - Apply the
MIN - Use
GOOGLEFINANCE("CURRCNYUSD")
2. Microsoft Excel (with Power Query)
Best for:
Workflow:
- Use Power Querymerge multiple data sources
- Clean and transform the data to a uniform format within Excel.
- Create PivotTables
- Build charts and conditional formatting rules
3. Airtable
Best for:
Workflow:
- Create a base with a table for your "Order List."
- Add fields for prices from each agent and link records to product images.
- Use the Formula field
- Create different Views: one sorted by "Greatest Saving" and another as a "Gallery View" to see items.
- Integrate with Zapier
Practical Example: Comparing a 20-Item Haul
Imagine you have a list of 20 items from Taobao.
- You populate your Google Sheet with the LoongBuy quoted prices
- You manually (or via semi-automated import) add the prices for the same items from CNFANSKakobuy.
- Your spreadsheet calculates:
- Item-Level Best Price:
- Total Basket Cost:
- You then add each agent's flat service feeestimated shipping weight cost
- Result:Kakobuy
Pro Tips for Effective Comparison
- Factor in All Costs:
- Update Regularly:refresh your data weekly
- Check Community Sheets:
- Communication is Key:price-match