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 (Quality Control) results, and shipping costs in one simple, transparent document.
Why Use the Order Management Spreadsheet?
Managing multiple orders from different sellers can be chaotic. The LoveGoBuy Spreadsheet solves this by providing:
- Centralization:
- Clarity:
- Accountability:
- Cost Control:
- Clarity:
Key Sections of the Spreadsheet
A well-maintained spreadsheet typically includes the following columns:
| Column | Purpose |
|---|---|
| Product Link & Description | The exact URL and details (color, size, etc.) of the item you want. |
| Price (¥) | The item price quoted by the seller or found on the platform. |
| QC Photos & Status | Link to your QC photos. Mark as "Pending," "Approved," or "Rejected." |
| Domestic Shipping (¥) | Cost for the seller to ship the item to the LoveGoBuy warehouse. |
| Warehouse Status | Indicates if the item has "Arrived" at the warehouse or is "In Transit." |
| International Shipping Cost | The calculated cost to ship the item from the warehouse to your country. |
| Total Cost & Notes | Final calculated cost and any important reminders or special instructions. |
Step-by-Step Workflow
-
Initial Setup & Product Addition
Create a new spreadsheet (using Google Sheets or Excel) with the columns mentioned. For each item you wish to purchase, fill in the Product Link, Description, and the known Price.
-
Submission to Your Agent
Share the spreadsheet with your LoveGoBuy purchasing agent. They will use it as a reference to purchase your items and will update the "Price" and "Domestic Shipping" columns with confirmed amounts.
-
Quality Control & Updates
Once items arrive at the LoveGoBuy warehouse, QC photos are taken. Your agent will add the link to the QC photos in the spreadsheet. You review them and update the "QC Status" to ApprovedRejected.
-
Shipping Consolidation & Final Payment
After all items are warehouse, your agent will calculate the international shipping cost for your consolidated parcel and update the spreadsheet. You review the Total Cost
Pro Tips for Effective Use
Use Hyperlinks
Properly hyperlink product URLs and QC photo albums for one-click access.
Color-Code Status
Use cell colors (e.g., green for approved, red for rejected) for visual tracking.
Regular Communication
Use the "Notes" column for questions and confirmations with your agent.
Keep a Backup
Regularly save or download a copy of your spreadsheet for personal records.