Streamline your purchasing process by managing every supplier order in one powerful document.
Juggling orders from numerous sellers can be a logistical headache. Sugargoo's spreadsheet feature transforms this complex task into a simple, streamlined process. By centralizing all your order information, you gain unparalleled control and clarity over your purchases.
Why Use a Centralized Spreadsheet?
- Unified Overview:
- Reduce Errors:
- Save Time:
- Enhanced Coordination:
- Reduce Errors:
How to Use the Sugargoo Spreadsheet: A Step-by-Step Guide
Step 1: Creating and Listing Your Items
Begin by creating a new spreadsheet (using software like Google Sheets, Excel, or Sugargoo's built-in notes). For each item you intend to purchase, create a dedicated row with the following columns:
| Item # | Product Name / Description | Seller Name / Store Link | Price (¥) | Quantity | Order Number | Status | Remarks / Notes |
|---|---|---|---|---|---|---|---|
| 1 | Men's Classic Hoodie - Black, Size L | store123.com/item1 | 168.00 | 1 | (Leave blank initially) | Not Ordered | Check stock before ordering |
Step 2: Sorting and Organizing for Efficiency
Use your spreadsheet's sort and filter functions to manage your list effectively:
- Sort by Seller:
- Sort by Status:
- Sort by Price or Priority:
- Sort by Status:
This organization allows you to submit batch orders to your Sugargoo agent per seller, saving time and potential shipping costs.
Step 3: Monitoring and Updating Status
The spreadsheet is a living document. Update it regularly as you progress:
- Once you submit an order through Sugargoo, paste the Sugargoo Order Number
- Change the Status"Ordered - Awaiting Shipment."
- When the seller ships the item and Sugargoo provides tracking, update the status to "Shipped to Warehouse."
- Finally, when the item arrives at your Sugargoo warehouse, update the status to "Arrived"
Pro Tips for Maximum Effectiveness
Use Color Coding
Apply cell colors to indicate status (e.g., Yellow for ordered, Green for arrived, Red for problems). Visual cues speed up scanning.
Link Directly
Hyperlink the product name to its original page and the Sugargoo order number to its corresponding page in your Sugargoo account for one-click access.
Share with Your Agent
You can share a view-only link of your spreadsheet with your Sugargoo purchasing agent. This provides them with perfect clarity for order placement and follow-up.
Add Financial Columns
Include columns for domestic shipping fees, estimated weight, and rehearsal shipping costs to keep a full financial overview.