CNfans Cross-Platform Price Comparison: How to Integrate Coupon Resources in Spreadsheets
In the world of daigou (代购) shopping services, CNfans has emerged as a popular platform helping international shoppers access Chinese products. One critical challenge is comparing prices across different platforms while factoring in available coupons and discounts. This article explores how spreadsheets can be your ultimate tool for effective price comparisons.
1. Setting Up Your Comparison Spreadsheet
Create a spreadsheet with these essential columns:
Product Name | Original Platform Price | Platform Fees | Available Coupons | Platform + CNfans Service Fee | Final Price | Availability |
---|---|---|---|---|---|---|
(Your product) | $00.00 | $00.00 | -X% or -$X | $00.00 | $00.00 | Yes/No |
Formulas should automatically calculate the price including service fees/when applying coupons.
2. Strategies for Coupon Integration
Option 1: Conditional Formatting Highlight
Use color coding to highlight products where coupons bring prices below a certain threshold:
=IF(D3>E3,"Good Deal","Standard Price")
Option 2: Creating a Coupon Database Sheet
In a separate worksheet tab, maintain:
- Ongoing platform promotions (Double 11, 618,etc.)
- New user coupons
- Limited-time store coupons
- Membership discounts
Option 3: Web Extracted Data (Advanced)35
For more technical users, use IMPORTXML/IMPORTDATA functions: