LoveGoBuy Spreadsheet: Master Combining QC Photos & Financial Tracking
How to link image folders and order IDs for full-picture accountability between inspection results and cost details.
For agents, resellers, and seasoned Taobao shoppers, managing the gap between quality control (QC) visualspurchase finances
The Core Concept: Linked Accountability
Traditional tracking separates what you seespendbi-directional link
Step-by-Step Implementation
Step 1: Folder & File Structure
Create a master cloud folder "LoveGoBuy_QC_2024". Inside, create sub-folders named by Order ID. Upload all agent-provided QC images into the corresponding folder.
Step 2: Spreadsheet Architecture
Build your Google Sheets or Excel file with these core columns:
| Order ID | QC Photo Link | Item Cost (¥) | Domestic Shipping (¥) | LoveGoBuy Fee (¥) | Total Cost (¥) | QC Status | Notes |
|---|---|---|---|---|---|---|---|
| LGB-11425 | [LINK TO FOLDER] | 350.00 | 10.00 | 25.00 | 385.00 | PASSED | Color matches, no flaws. |
Step 3: Creating Hyperlinks
In the "QC Photo Link" cell, use the =HYPERLINK("URL", "View QC")
Step 4: Ongoing Tracking & Decision Making
As photos arrive, update the QC Status. If an item fails, note it immediately. The linked structure allows you to instantly compare the cost of the problemvisual evidence, streamlining exchanges or returns.
Key Benefits of This Method
Full Audit Trail
Every yuan spent is directly accountable to a physical item's visual condition at inspection.
Faster Decisions
No more switching between 10 browser tabs. Decide "GL" or "RL" with costs and photos side-by-side.
Dispute Resolution
Provides unambiguous evidence (photos + transaction data) for any discussion with your agent or seller.
Scalability
Works for 5 orders or 500. Filter and sort by status or cost to manage large hauls effectively.