Organizing purchases from different sellers can be chaotic. This guide shows you how to use our free spreadsheet template to consolidate links, QC photos, and weights into one efficient plan.
Why Use a Consolidation Spreadsheet?
Managing a haul from Taobao, Weidian, or other platforms means tracking multiple orders, communication threads, and potential quality checks. Without a system, costs and errors add up.
- Centralize Information:
- Track QC & Weight:
- Calculate True Cost:
- Streamline Submission:
- Track QC & Weight:
How to Use the LoveGoBuy Spreadsheet
Step 1: Copy and Set Up Your Template
Make a copy of the LoveGoBuy Master Sheet Template. The main columns include:
| Column | Purpose |
|---|---|
| Product Link & Store | The item URL and seller name for easy reference. |
| Price (¥) | Item cost. Use formulas to auto-calculate totals. |
| Domestic Shipping (¥) | Shipping fee from seller to LoveGoBuy warehouse. |
| QC Photos & Results | Link to your QC pics and notes (e.g., "GL" or "RL"). |
| Weight (kg) | Actual or estimated weight from your agent. |
| International Freight Cost | Calculated cost based on total package weight. |
Step 2: Input All Purchases and Track QC
As you buy, paste each link into the sheet. After purchase, LoveGoBuy provides QC photos
Step 3: Record Weights and Calculate Freight
Once all items are approved and arrive at the warehouse, LoveGoBuy will weigh them. Input each item's weight. The sheet automatically sums the total haul weight.
Use LoveGoBuy's freight calculator
Step 4: Finalize and Submit for Consolidation
Your spreadsheet now has everything needed for a smooth parcel submission:
- A complete list of items to be packed together.
- Verified QC status for every item.
- An accurate total weight and shipping cost.
Submit this clear list to your LoveGoBuy agent when requesting parcel consolidation, minimizing back-and-forth communication.
Get Started Now
Download our ready-to-use template and take control of your next multi-seller haul:
Download the LoveGoBuy Consolidation SpreadsheetNote: