Cross-border shopping through proxy agents is exciting until your inbox fills with tracking numbers and your memory fails on what you actually ordered. This wegobuy spreadsheet tutorial transforms chaos into clarity. Whether you are buying sneakers, streetwear hoodies, or accessories from Chinese marketplaces, a structured tracker keeps every product link, fee, and delivery status in one place. By the end of this guide, you will have a fully operational spreadsheet system that saves hours of confusion and prevents costly duplicate orders.
What You Will Build Today
This tutorial teaches you to build a five-sheet workbook: a master order log, a budget summary dashboard, a category filter view, an agent fee calculator, and a delivery timeline tracker. Each sheet connects through formulas so updating one row cascades to totals, alerts, and charts automatically. Unlike generic Excel tutorials, this wegobuy spreadsheet tutorial uses fields specifically designed for proxy shopping workflows.
Sheet Structure Overview
| Sheet Name | Purpose | Key Formula |
|---|---|---|
| Master Log | Record every product URL and status | VLOOKUP for agent details |
| Budget Dashboard | Real-time spend vs. limit | SUMIF by category |
| Category View | Filter by Shoes, Hoodies, etc. | FILTER function |
| Fee Calculator | Service charge plus shipping | Auto-convert CNY to USD |
| Timeline | Days since order per item | DATEDIF plus conditional color |
Step One: Create the Master Log
Open a new spreadsheet. In row one, type these headers across columns A through J: Product URL, Product Name, Category, Estimated Price, Service Fee, Domestic Shipping, International Shipping, Total Cost, Order Status, and Notes. Format row one with bold text and a light gray background so it stays visible when you scroll. In the Category column, create a dropdown with all ten categories: Shoes, Hoodies/Sweaters, T-Shirts, Jackets, Pants/Shorts, Headwear, Sets, Underwear/Underpants, Jersey, and Accessories. This dropdown prevents typos that break your filter formulas later.
Step Two: Link the Budget Dashboard
On a new sheet named Dashboard, place a budget cap cell at B2. Type your monthly limit, for example two thousand dollars. In B3, use a SUMIF formula to total every order in the Master Log where price is greater than zero. In B4, calculate remaining budget with a simple subtraction of B2 minus B3. Apply conditional formatting so B4 turns red when it drops below two hundred dollars. This visual shock alone stops impulse spending more effectively than willpower.
Common Formula Errors and Fixes
| Error | Cause | Fix |
|---|---|---|
| REF error | Deleted referenced column | Undo or rebuild the formula |
| VALUE error | Text in a number field | Check currency format is numeric |
| N/A error | Category typo breaks FILTER | Use dropdown validation strictly |
| Wrong total | Hidden rows included in SUM | Use SUBTOTAL instead of SUM |
Step Three: Add Conditional Formatting
Select the Order Status column on the Master Log. Apply color rules: Paid rows turn pale orange, Shipped rows turn light blue, In-Transit rows stay white, Arrived rows turn mint green, and Reviewed rows turn light gray. This color system lets you see pipeline health at a glance. When you open the spreadsheet during your morning coffee, a wall of green means everything is on track. A sudden patch of orange means a payment is stuck and needs your attention.
Step Four: Build the Category Filter View
On the Category View sheet, type the FILTER function into cell A1 to pull all Master Log rows where the Category column matches Shoes. Repeat this pattern for every category in separate rows or columns. If you prefer a cleaner layout, place a dropdown in cell C1 that lists all categories, then use a dynamic FILTER formula so changing the dropdown instantly updates the visible table. This trick is especially useful when you want to show a friend only the shoes you are considering without revealing your entire underwear order history.
Step Five: Automate Currency Conversion
The fee calculator needs live exchange rates. In a hidden corner of the Dashboard sheet, use GOOGLEFINANCE for currency conversion in Google Sheets, or use a simple manual cell that you update weekly for Excel. Reference that cell in your Total Cost column so prices auto-convert from yuan to dollars. When the yuan weakens, your total spend drops in real time. When it strengthens, you get an early warning before checkout.
Frequently Asked Questions
Do I need advanced spreadsheet skills?
No. If you can sum a column and apply a fill color, you have enough knowledge. The formulas in this tutorial are copy-paste ready.
Can I share the tracker with friends?
Yes. Upload to Google Drive and set sharing to comment-only if you want input without accidental edits.
What if I order from multiple agents?
Add an Agent column to the Master Log. All formulas still work because SUMIF accepts multiple criteria.
How often should I update it?
Update immediately after placing an order and whenever a status changes. Daily five-minute checks prevent disasters.
Ready to shop? Browse the full catalog at OOCBuy and put your new spreadsheet skills to work.