For avid shoppers using Taobao's proxy service, BaseTao, managing numerous purchases over time can become a logistical puzzle. The powerful yet underutilized BaseTao Spreadsheet
Shopping across different months, from various stores, and consolidating items into multiple shipments creates a flood of data. Relying solely on memory or disparate notes leads to confusion: "Which items are in my current warehouse haul?", "What did I buy from that store two months ago?", "How much did I spend last quarter?". The BaseTao Spreadsheet is designed explicitly to solve these problems. The spreadsheet transforms your shopping list into a clear, actionable, and historical database. Here’s how its categorization works: Log every item with details like name, direct Taobao link, BaseTao warehouse link, price (RMB), quantity, and notes (size, color, specific requests). This creates a master inventory of everything you've ever purchased or planned to purchase. By noting the store name for each product, you can easily track which sellers you frequent, compare reliability, and re-order successful finds. This turns your spreadsheet into a valuable personal directory of trusted stores. This is the core of multi-haul management. Assign each product to a specific Shipment IDPurchase Month. You can then filter the sheet to see only items in your pending warehouse parcel, or review all purchases made in a particular month for budgeting, effortlessly separating past, present, and future hauls. To get started, access the Spreadsheet tool from your BaseTao member center. Create columns that fit your workflow. A basic structure includes: Use filters to view only "Ordered" items for a specific Shipment ID
By leveraging the BaseTao Spreadsheet for categorization across multiple months, you gain unparalleled clarity and control. It eliminates duplicate orders, ensures no paid item is forgotten in the warehouse, and provides a complete spending history. For the frequent shopper, it’s not just a spreadsheet—it’s the central command center for all your hauls.The Multi-Haul Management Challenge
Key Features for Organized Shopping
1. Clear Product Categorization
2. Store & Seller Tracking
3. Shipment & Monthly Overview
Implementing Your Management System
Product Name
Store
Price (¥)
Purchase Month
Shipment ID
Status
Winter Knit Sweater
StoreABC
150.00
October
HAUL-2024-Q4
In Warehouse
Ceramic Mugs (Set of 2)
HomeGoods Direct
80.00
November
HAUL-2024-Q4
Ordered
The Result: Stress-Free Shopping
Mastering Your Hauls: How the BaseTao Spreadsheet Simplifies Multiple Shipments
2026-02-18