How to Use Oopbuy Spreadsheet
A practical walkthrough for tracking inventory, pricing, and profits like a pro.
Quick Answer
To use oopbuy spreadsheet effectively, set up columns for item name, SKU, category, purchase cost, selling price, platform fees, profit margin, and status. Update the sheet after every purchase and sale, and review weekly to spot pricing trends.
Knowing how to use oopbuy spreadsheet separates hobby resellers from profitable businesses. The tool itself is simple, a structured grid. What matters is the workflow you build around it. This tutorial covers the exact process that experienced sellers follow every single day.
Before we dive in, make sure you have read our ultimate oopbuy spreadsheet guide for the big-picture framework. This article focuses purely on hands-on execution.
The Essential Column Structure
Every oopbuy spreadsheet should start with these ten columns. They cover the full lifecycle of an item from purchase to payout.
| Column | What to Enter | Why It Matters |
|---|---|---|
| Item Name | Full product name with brand and color | Prevents confusion between similar items |
| SKU | Your internal code, e.g., NK-001 | Links inventory to your listing platform |
| Category | Shoes, Hoodies, T-Shirts, etc. | Lets you filter and analyze by product type |
| Purchase Cost | What you paid including shipping | Baseline for all profit calculations |
| Target Sell Price | Your planned listing price | Keeps pricing strategy consistent |
| Platform Fee | Percentage taken by marketplace | Shows true net revenue per sale |
| Net Profit | Formula: Sell minus Cost minus Fee | The only number that truly matters |
| Status | Listed, Sold, Pending, Returned | Instant visual inventory health check |
| Date Added | When you bought the item | Helps rotate stale inventory |
| Notes | Defects, special features, sourcing location | Memory aid for buyer questions |
Daily Workflow for Oopbuy Spreadsheet Users
Check Overnight Sales
Open your sheet and filter the Status column to 'Listed.' Any item that sold on your platform should be updated to 'Sold' with the actual sell price and date. This keeps inventory accuracy tight.
Add New Inventory
After a sourcing run, add every new item to the bottom of your sheet. Do not wait until evening. Fresh memory means fewer errors in color names, sizes, and condition notes.
Price Review
Scan items that have been 'Listed' for more than 30 days. If the net profit margin dropped below your minimum threshold, adjust the target sell price or consider bundling.
Advanced Filtering Techniques
Once your sheet passes 50 rows, scrolling becomes inefficient. Use filters to slice your data intelligently:
- Filter by Category to see which product type holds the most capital
- Sort by Net Profit descending to identify your best-margin items
- Filter Status to 'Sold' and sum Purchase Cost to see total capital recovered
- Filter Date Added to items older than 60 days to find stale inventory
Platform Fee Reference Table
| Platform | Fee Type | Approximate Rate |
|---|---|---|
| eBay | Final value + listing | 13-15% |
| StockX | Transaction + processing | 12-14% |
| GOAT | Commission + cash out | 9.5% + $5 |
| Depop | Transaction fee | 10% + processing |
| Grailed | Commission | 9-11% |
Maximize Your Spreadsheet Efficiency
Visit our main store for the latest fashion inventory to populate your sheet with high-margin items.
Buy It NowFrequently Asked Questions
How often should I update my oopbuy spreadsheet?
Daily is ideal. At minimum, update after every purchase and every sale. Stale data leads to pricing mistakes.
Can I link my sheet to my listing platform?
Some platforms offer CSV exports you can import. Direct API links require third-party tools, which we cover in our automation guide.
What is the best net profit margin?
Aim for 30% after all fees and shipping. Anything below 20% is risky unless you move volume extremely fast.
Should I track returns in the same sheet?
Yes. Add a 'Returned' status and a 'Return Reason' column. Return patterns reveal quality issues with specific suppliers.
How do I share my sheet with a partner?
Use Google Sheets and set permissions to 'Commenter' or 'Editor.' Avoid sending Excel files back and forth.