Free Oopbuy Spreadsheet Template
Download our professionally designed template. Zero cost. Instant productivity.
What You Get
Our free oopbuy spreadsheet template includes pre-built columns for item tracking, automatic profit calculations, color-coded status labels, category filters, and a monthly summary dashboard. It is designed specifically for fashion resellers and works in both Google Sheets and Excel.
Building a spreadsheet from scratch is tedious. You forget columns, mess up formulas, and waste hours formatting cells that should be spent sourcing inventory. Our template removes every friction point so you can open the file and start entering products within two minutes.
This template is the exact starting point we recommend in our ultimate oopbuy spreadsheet guide. Thousands of resellers have used it to organize their first inventory batches.
Template Structure Overview
Main Inventory Tab
The core tracking sheet with 12 pre-configured columns: Item Name, SKU, Category, Purchase Cost, Shipping Cost, Target Sell Price, Platform Fee, Net Profit, Status, Date Added, Supplier, and Notes. Every column has example data so you understand the format instantly.
Profit Dashboard Tab
A read-only summary that auto-calculates total inventory value, average margin, best-performing category, and capital tied up in unsold items. All numbers pull directly from the Main Inventory tab. No manual updates needed.
Sold History Tab
When you mark an item as 'Sold' in the main sheet, a script moves it here automatically. This creates a clean audit trail for taxes and performance reviews without cluttering your active inventory view.
Supplier Tracker Tab
Log every supplier with contact info, average quality rating, shipping speed, and reliability score. Over time, this data reveals which suppliers deserve repeat business and which ones to drop.
Pre-Built Formulas Included
| Formula | What It Does | Where It Lives |
|---|---|---|
| Net Profit | Auto-calculates selling price minus all costs | Main Inventory |
| Margin % | Shows profit as percentage of selling price | Main Inventory |
| Days Listed | Counts how long an item has been unsold | Main Inventory |
| Category Summary | Totals items and profit per category | Dashboard |
| Monthly Sales | Aggregates sold items by month | Dashboard |
| Stale Alert | Flags items over 45 days old in red | Main Inventory |
How to Download and Use
- 1Click the download button below to get the Google Sheets link
- 2Open the link and click File > Make a Copy to create your private version
- 3Delete the example rows and start entering your own inventory
- 4Customize the Category dropdown to match your niche: Shoes, Hoodies, Jackets, etc.
- 5Set your default platform fee percentage in the Settings cell at the top
- 6Bookmark the sheet on your phone for mobile sourcing updates
Get Your Free Template
No email required. No signup. Just click, copy, and start tracking.
Template vs Building From Scratch
| Factor | Our Template | From Scratch |
|---|---|---|
| Setup Time | 2 minutes | 45-90 minutes |
| Formula Errors | Zero (pre-tested) | Common in first builds |
| Column Completeness | All essential columns included | Easy to forget shipping cost or SKU |
| Visual Design | Color-coded, clean layout | Usually plain white grid |
| Dashboard | Built-in summary tab | Requires advanced skills |
| Best For | Everyone | Experienced spreadsheet builders |
Customization Tips
- Add a 'Photos' column with hyperlinks to your Google Drive folders for each item
- Create conditional formatting that turns the Net Profit cell green above 30% and red below 10%
- Add a 'Season' column if you sell items with seasonal demand like winter jackets
- Link the Supplier Tracker to your email drafts for quick reorder requests
- Duplicate the Main Inventory tab per platform if you list the same item on eBay, StockX, and Depop
Frequently Asked Questions
Is the template really free?
Yes. No credit card, no email gate, no hidden fees. We built it to help the community grow.
Can I share it with my business partner?
Absolutely. Since it is a Google Sheet, share it like any other document with edit or comment permissions.
Does it work on Excel?
Yes. Download as Excel from Google Sheets. Most formulas translate perfectly. Macros will not transfer.
How often is the template updated?
We review and improve it quarterly based on user feedback. Your copied version stays static unless you manually update.
What if I need more columns?
Add as many as you want. The existing formulas use relative references and will adapt automatically.