Step 1: Foundation & Item Logging
Create core columns: Item Name, Store/Link, Quantity, Item Price (¥), Domestic Shipping (¥), and Notes. This is your master list of purchased goods.
LoveGoBuy: How to Automate Order Tracking Using the LoveGoBuy Spreadsheet
2025-12-31
Streamline your hauls with automated calculations and transparent tracking.
For seasoned online shoppers, especially those navigating the world of international agents and Taobao hauls, managing multiple packages, fluctuating exchange rates, and complex shipping fees can quickly become a logistical nightmare. The LoveGoBuy Spreadsheet
Why the Spreadsheet is a Game-Changer
Traditional methods involve juggling between agent websites, email confirmations, and manual calculators. The LoveGoBuy Spreadsheet consolidates everything into one living document, offering:
- Automated Cost Calculations:
- Centralized Order Tracking:
- Financial Transparency:
- Multi-Haul Management:
- Centralized Order Tracking:
Setting Up Your Automated Tracking System
While templates may vary, the core setup follows a logical structure to automate the workflow.
Step 2: Warehouse & Weight Data
Add columns for when your agent receives the item: Warehouse Received?, Actual Weight (kg), Photos Link. This data is crucial for the next step.
Step 3: Automation with Formulas (The Heart of the System)
This is where the magic happens. Using simple spreadsheet formulas (like in Google Sheets or Excel), you link cells to perform automatic calculations.
- Total Item Cost (¥):=(Item Price * Quantity) + Domestic Shipping
- International Shipping Cost:=Actual Weight * Shipping Rate per kg. You can have a separate cell for your agent's current rate.
- Total Cost (Converted):=(Total Item Cost + International Shipping) / Exchange Rate.
Step 4: Dynamic Tracking Status
Create a StatusOrdered, Warehouse Received, Photos Added, Shipped Internationally, Delivered. Color-code these for instant visual clarity.
Step 5: Dashboard & Summary
Dedicate a section at the top of your sheet for key metrics using SUMCOUNTIF
Pro Tips for Maximum Efficiency
- Freeze Header Rows:
- Use Hyperlinks:
- Conditional Formatting:
- Duplicate Sheets:
- Share with Friends:
- Use Hyperlinks: