Streamline consolidation, QC, and weight tracking for maximum efficiency and savings.
Shopping from multiple stores like Taobao, Weidian, and 1688 offers incredible variety and value. However, managing numerous links, quality control (QC) photos, and shipping weights can quickly become chaotic. The LoveGoBuy Spreadsheet
Why Use a Centralized Spreadsheet?
- One Source of Truth:
- Simplified Consolidation:
- QC & Weight Management:
- Budget Control:
- Error Reduction:
- Simplified Consolidation:
Building Your LoveGoBuy Spreadsheet: Core Columns
Create a new spreadsheet (Google Sheets or Excel) with the following essential columns:
| Column | Purpose | Example Entry |
|---|---|---|
| A: Item # | Unique identifier for each item (e.g., 001, 002). | 001 |
| B: Store Name | Seller/store name for reference. | TopStoney |
| C: Item Description/Link | HYPERLINK
| Navy Sweatshirt - Size L |
|
| D: Price (¥) | Item price in Chinese Yuan. | 250.00 |
| E: Domestic Shipping (¥) | Shipping cost from seller to LoveGoBuy warehouse. | 10.00 |
| F: LoveGoBuy Order # | Paste the order number assigned by LoveGoBuy after submission. | LG12345678 |
| G: QC Photo Link | HYPERLINK
| QC_001_Photos
| |
| H: Warehouse Weight (g) | The actual weight recorded by LoveGoBuy. Crucial for shipping calculation. | 450 |
| I: Status | Track progress: Not Ordered, Ordered, In Warehouse, Shipped. | In Warehouse |
| J: Notes | Size, color, specific instructions for agent. | "Ordered 10/26. Note: Please ask for detailed logo close-up." |
Efficient Workflow: From Cart to Doorstep
Step 1: Populate & Submit
Fill in Columns A-E for all items you intend to buy. When ready, use the Item Description/Link
Step 2: Track & QC
Once submitted, paste the assigned LoveGoBuy Order #
Step 3: Consolidate & Weigh
As items reach the warehouse, update their StatusWarehouse Weight (g). Use the SUM function to calculate total weight of all "In Warehouse" items. This allows you to accurately estimate international shipping costs using LoveGoBuy's price calculator before rehearsal.
Step 4: Finalize & Ship
Select all "In Warehouse" items in your LoveGoBuy parcel interface. Provide your consolidation instructions. Once shipped, update the Status column to "Shipped" and archive the row or sheet for your records.
Pro Tips for Power Users
- Use Color Coding:
- Embed Formulas:
- Create a Separate Tab for Shipping:
- Share with Agents:
- Embed Formulas: