Making purchases through BaseTao, one of China's popular Taobao purchasing agents, can sometimes lead to unexpected costs due to shipping fees and service charges.This guide will demonstrate practical spreadsheet formulas
Why Spreadsheet Budgeting is Essential
BaseTao's fee structure includes multiple components: product costs, service fees, domestic shippinginternational shipping.For budget control, calculating these in advance avoids payment surprises.
Key Costs You Need to Track
- Item Prices: Original cost from Taobao sellers.
- Service Fees: BaseTao's commission. Typically 5% of item cost + ¥8 for value-added services.
- Domestic Shipping: Cost to ship items to BaseTao's warehouse within China.
- International Shipping: Final shipping cost to your country via methods like EMS, DHL, etc.
- Exchange Rate: Current USD/CNY rate for currency conversion.
Step-by-Step Spreadsheet Setup
Create Your Column Headers
For example, in cell A1:H1, you might enter:
| Item Name | Quantity | Unit Price (¥) | Domestic Shipping (¥) | Weight/Item | Stored Price? |
|---|
Essential Formulas for Your Spreadsheet
-
Total Cost (Column D):
=B2*(C2) + D2
This multiplies quantity by the item unit price then adds domestic shipping. -
Stored Price Validation (Column F)：
=IF(NOT(G2),C2*0.05+8,0)
IF NOT Stored Price, Then apply the service fee (5% + ¥8), Else 0. -
Sum Service Fee(After Column G): =PRODUCT(C2:E2,"Your Exchange Rate") & SUM() will Compute everything into your currency (ie. USD).
Complete Visibility Through Calculation
As your filled spreadsheet updates, you'll see a real-time Total Cost estimate. This comprehensive figure removes uncertainty and allows for better purchase decisions before submitting payment to BaseTao.