Setting up a wegobuy spreadsheet does not require a computer science degree. In fact, if you can fill out an online form, you can build a tracker that organizes every rep, hoodie, and accessory purchase across all ten OOCBuy categories. This step-by-step guide removes every decision point. Just follow the numbered actions in order, copy the provided formulas exactly, and within ten minutes you will have a live dashboard showing how much you have spent, what is arriving this week, and what still needs payment.
The Philosophy of Simplicity
Most shoppers abandon spreadsheets because they over-engineer them. They add twenty columns, five pivot tables, and a chart gallery that nobody reads. The wegobuy spreadsheet step-by-step method deliberately uses only ten columns and three sheets. Fewer moving parts mean fewer broken formulas and faster updates. Complexity is the enemy of consistency. A simple tracker you update daily beats a fancy dashboard you ignore.
Pre-Setup Checklist
- 1Open Google Sheets or Microsoft Excel on your computer
- 2Bookmark the OOCBuy product pages you plan to order
- 3Check your agent's service fee percentage, usually five to ten percent
- 4Decide your monthly spending cap before touching the spreadsheet
- 5Create a folder named Shopping Tracker 2026 for related files
Step 1: Name Your File
Start with the date. A filename like Haul-June-2026 keeps old orders archived while you start fresh each season. Duplicate this file instead of deleting rows. Historical data becomes surprisingly valuable when you want to know whether that jacket seller from last winter actually delivered on time.
Step 2: Build the Ten-Column Master
In cell A1 type Product URL. In B1 type Product Name. Continue across with Category, Agent, Est Price, Service Fee, Domestic Ship, Intl Ship, Status, and Notes. Format row one with bold formatting and a subtle bottom border. Freeze row one so headers remain visible while scrolling through fifty orders. In the Status column, add a dropdown with these exact options: Wishlist, Paid, QC Received, Shipped, In-Transit, Arrived, Reviewed. Never deviate from these labels because conditional formatting depends on exact text matches.
Status Color Mapping
| Status | Background Color | Meaning |
|---|---|---|
| Wishlist | Pale yellow | Considering but not committed |
| Paid | Pale orange | Money sent, waiting for warehouse |
| QC Received | Light purple | Photos received, review pending |
| Shipped | Light blue | Left agent, heading to you |
| In-Transit | White | Moving through customs or hubs |
| Arrived | Mint green | Package delivered, unboxed |
| Reviewed | Light gray | Checked quality, case closed |
Step 3: Add the Budget Alert
In a new sheet called Summary, type Monthly Cap in A1 and your number in B1. In A2 type Total Spent. In B2 paste a SUM formula that adds the estimated price, service fee, domestic shipping, and international shipping columns from the Master sheet. In A3 type Remaining. In B3 use a subtraction formula. Select B3 and apply conditional formatting: if value is less than two hundred, fill red and font white. Now every time you paste a new product row, the remaining budget updates automatically and screams at you when you are close to broke.
Step 4: Create the Timeline
Add a column K named Days Since Ordered. In K2 calculate the difference between today's date and the Order Date column. Apply conditional formatting so anything over fourteen days turns bold red. This single column prevents packages from sitting forgotten in warehouses. When a row hits twenty-one days and still says Paid, you know it is time to message your agent.
Step 5: Lock and Share
Protect the Summary sheet so accidental clicks do not delete your budget formulas. In Google Sheets, right-click the Summary tab, choose Protect Sheet, and restrict editing to yourself. Share the Master sheet with comment access if you have a buying group. Now your friends can paste product links without touching your formulas.
FAQ
How long does setup really take?
Seven to twelve minutes if you copy the formulas exactly. Add five more minutes if you customize colors.
Should I use Excel or Google Sheets?
Google Sheets for collaboration and live currency rates. Excel for offline privacy and large datasets.
Can I track multiple hauls in one file?
Yes. Add a Batch column and use SUMIF with batch names to separate spending per haul.
Build your tracker, then fill it with products from the OOCBuy store.