How to Use Basetao Spreadsheet: Daily Workflow Guide
By Basetao Spreadsheet Team · Updated May 27, 2026 · 6 min read
Quick Navigation
Creating a basetao spreadsheet is only half the battle. Knowing how to use it as part of your daily shopping workflow is what turns a static document into a powerful tracking tool. This guide walks you through the exact process from discovery to delivery.
The Discovery Phase
When you find an item you want to buy, do not just copy the link into your agent. Open your basetao spreadsheet first and add a new row. Record the product name, link, size, color, and price while the information is right in front of you. This ten-second habit prevents the dreaded 'what was that item called again' problem three days later.
The Purchase Phase
After submitting the order through your agent, return to your sheet and update two fields: Order Date and Status. Change Status to Ordered. If your agent provides an order number or internal reference, add it to your Notes column. This creates a direct link between your sheet and the agent's system.
The Warehouse Phase
Once your item arrives at the agent warehouse, you will typically receive a notification with QC photos. Open your basetao spreadsheet and change Status to In Warehouse. Take a moment to review the photos against your original order. If something looks wrong, this is your chance to catch it before international shipping begins.
The Shipping Phase
When you submit your parcel for international delivery, update Status to Shipped and add the tracking number to a dedicated Tracking column. If your sheet does not have one yet, add it now. Tracking numbers are easy to lose in email threads but impossible to lose when they live in your spreadsheet.
The Delivery Phase
The final step is the most satisfying. When your package arrives, update Status to Delivered and add the delivery date. Optionally, rate the shipping line you used in your Notes column. Over time, this builds a personal database of which carriers deliver fastest and cheapest to your address.
Weekly Review Routine
Spend five minutes every weekend scanning your basetao spreadsheet for orders stuck in the same status for too long. An item sitting in Ordered status for two weeks might need a follow-up with your agent. A Shipped item without tracking updates after ten days might warrant a carrier inquiry.
| Status | Typical Duration | Action Needed |
|---|---|---|
| Ordered | 3-7 days | Wait for warehouse arrival |
| In Warehouse | 1-14 days | Review QC, submit parcel |
| Shipped | 7-21 days | Track, wait for delivery |
| Delivered | Permanent | Archive or move to history sheet |
Batch Updates
If you placed five orders at once, update all five rows immediately. Do not wait until later when you might forget details.
Use the Mobile App
Google Sheets mobile app makes status updates effortless. A thirty-second update while waiting for coffee keeps your sheet current.
Link Everything
Paste the product URL, agent order page URL, and tracking URL all in your sheet. One click access saves enormous time.
Ready to Start?
Put this workflow into practice with our free basetao spreadsheet template.
Start Using Basetao SpreadsheetHow often should I update my basetao spreadsheet?
Update immediately after every action: ordering, warehouse arrival, shipping, and delivery. A five-minute weekly review catches anything you missed.
What if I buy from multiple agents?
Add an Agent Name column to your basetao spreadsheet. This keeps orders organized even when you use two or three different services.
Should I delete old orders?
Never delete. Create a new sheet tab each quarter and move completed orders there. Historical data is incredibly valuable for budgeting.
Final Thoughts
A basetao spreadsheet only works if you use it consistently. The workflow above takes less than two minutes per order but saves hours of confusion later. Treat your sheet as a living document, not a one-time checklist, and it will serve you for years.