Guide 02 · Getting Started & List Checks
How to Build an Oopbuy Spreadsheet Shopping List
To build an Oopbuy spreadsheet shopping list, start with one clear scenario, then add a small set of columns: item, category, size, a USD budget line and shipping notes. Group candidates as must-have, optional or waiting to be confirmed so the list stays short and usable.
Decide the scenario before you add items
A list that mixes a dorm room refresh with a wedding outfit will blur your budget. Pick one scenario first, such as a commuter work week, a single trip, or a holiday gift round. Name the list after it so a week later you still know what it was for. If you need a general starting point, review the practical Oopbuy spreadsheet guide before opening a blank sheet.
A field comparison that sorts priorities
Instead of one long list, use three buckets. Sorting as you go prevents the sheet from turning into a wish list.
| Bucket | What goes here | Rule |
|---|---|---|
| Must-have | Core items that fill a real gap | Buy first if budget allows |
| Optional | Nice upgrades and second colors | Only after must-haves are covered |
| Waiting to confirm | Items with missing size or material info | Move on once details are verified |
Recording sizes and budget lines
Write body measurements in inches once, then copy them into every candidate. Keep the item price, any domestic shipping and the international shipping line separate, and label any guessed figure as a sample budget. This makes the total easy to recheck later instead of guessing at the end.
- One scenario per list, named clearly.
- Body measurements reused across candidates.
- Item price and shipping kept on separate lines.
- Guessed numbers marked as example budgets.
- Unconfirmed items parked in their own bucket.
Keeping the list honest over time
- Add a "last checked" date whenever you verify an item.
- Delete or archive links that no longer load.
- Review the list once a week and move confirmed items forward.
Since sizes drive so many decisions, continue with comparing clothing sizes in an Oopbuy spreadsheet to make the size column reliable.
Quick answers
How many items should one list hold?
Keep it under about fifteen. Beyond that, it becomes hard to compare and easy to overspend.
Should I include prices right away?
Yes, but mark any unverified figure as a sample budget so you do not treat it as final.
What if I cannot confirm a size?
Place the item in the waiting-to-confirm bucket and move on until the detail is available.