Joyagoo: How to Track Orders and QC Updates with the Joyagoo Spreadsheet
Stay informed from purchase to delivery. This guide explains how to use the Joyagoo Spreadsheet to monitor QC photos, shipping stages, and product conditions.
Managing multiple purchases from different sellers can be challenging. The Joyagoo Spreadsheet simplifies this process by providing a centralized, real-time dashboard for all your order information. From the moment you make a purchase to the second your package arrives, you stay in complete control.
Why Use the Joyagoo Spreadsheet?
- Centralized Tracking:
- Visual QC Verification:
- Transparent Logistics:
- Condition Monitoring:
- Collaboration Ready:
- Visual QC Verification:
How to Use the Spreadsheet: A Step-by-Step Guide
Step 1: Access & Initial Setup
You will receive a unique link to your Joyagoo Spreadsheet (typically a Google Sheet). Bookmark this link for easy access. The spreadsheet contains predefined columns for essential tracking data.
Step 2: Logging Your Purchase
For each new order, create a new row and enter the following information:
| Column | What to Enter |
|---|---|
| Product Name/Link | A description and a link to the product page. |
| Seller/Agent | The name of the seller or your purchasing agent. |
| Order Date & Price | The date of purchase and the total cost. |
| Order Number | The unique order ID from the seller. |
Step 3: Monitoring QC Photos
The "QC Photos""QC Status"
Step 4: Tracking Shipping Stages
The spreadsheet will have columns for "Shipping Status""Tracking Number."
Step 5: Recording Final Condition & Notes
Upon delivery, use the "Product Condition""Final Notes"
Pro Tips for Effective Tracking
Use Color Coding
Apply cell colors (e.g., yellow for "In Transit," green for "Delivered") for an instant visual overview of all order statuses.
Enable Notifications
Turn on comment notifications for your spreadsheet. This way, you get alerts when your agent adds a QC link or updates a status.
Freeze the Header Row
Keep your column titles visible while scrolling by freezing the top row of your spreadsheet.
Integrate Tracking Links
Use the =HYPERLINK() function to turn tracking numbers into clickable links that open directly to the carrier's tracking page.