LoveGoBuy: How to Use the LoveGoBuy Spreadsheet to Manage Your Orders
Streamline your purchasing process with a powerful, centralized tool. The LoveGoBuy Spreadsheet helps buyers track product links, QC results, and shipping costs in one simple, transparent document.
Why Use the Order Management Spreadsheet?
Organizing a group buy or multiple personal orders from Chinese platforms can become chaotic. The LoveGoBuy Spreadsheet eliminates confusion by providing:
- A Single Source of Truth:
- Complete Transparency:
- Efficiency:
- Accuracy:
- Complete Transparency:
Getting Started with Your Spreadsheet
LoveGoBuy typically provides a template, often via Google Sheets or a similar platform. Key sections to look for include:
| Column/Section | Purpose | What to Enter |
|---|---|---|
| Item/Link | Product Identification | The exact URL of the product from the seller (e.g., Taobao, Weidian). |
| Description/Specs | Details & Customization | Size, color, quantity, and any specific notes for the agent. |
| Price (¥) | Item Cost | The product price in Chinese Yuan (RMB). |
| QC Photos | Quality Control | Link to the inspection photos provided by LoveGoBuy after the item arrives at their warehouse. |
| Warehouse Weight | Shipping Cost Basis | The actual weight/volume weight of your item, crucial for calculating freight. |
| Shipping Cost (¥) | Freight Allocation | The portion of the total shipping cost assigned to this item. |
| Status | Progress Tracking | E.g., Ordered, Warehoused, QC Done, Shipped. |
The Workflow: From Order to Doorstep
-
1. Submission & Initial Entry
Fill in your product links and specifications in the designated rows. Share the spreadsheet with your LoveGoBuy agent or manager.
-
2. Purchasing & Price Updates
The agent updates the sheet with the actual item price
-
3. Quality Control (QC) Phase
When items reach the LoveGoBuy warehouse, the agent uploads QC photos. Check the QC Photos
-
4. Shipping Consolidation & Calculation
After all items are warehoused, the agent updates the Warehouse Weight. They will then calculate domestic and international shipping costs, filling in the Shipping Cost (¥)
-
5. Final Payment & Dispatch
The spreadsheet now shows your total cost (Item + Shipping). Make the final payment. Once shipped, the agent updates the Status
Pro Tips for Effective Management
Use Comments & Notes
Utilize the comment feature in cells to ask questions or flag issues without cluttering the sheet.
Freeze Header Rows
Keep the top row with column titles visible as you scroll down for easy reference.
Color Coding
Use cell colors to indicate status (e.g., yellow for pending, green for shipped) for a quick visual overview.
Regular Updates
Designate one person (or the agent) as the primary updater to maintain consistency and avoid version confusion.