How to Use Itaobuy Spreadsheet Step-by-Step

Learning how to use itaobuy spreadsheet tools is the fastest way to level up your reselling game. This step-by-step tutorial walks you through every feature, formula, and shortcut you need to build a tracking system that grows with your business.

Getting Started

Before you build your spreadsheet, gather these essentials: a Google account (for Sheets), a list of your most-purchased categories, and a rough idea of your target profit margin. Most resellers aim for 20-40% minimum margin on every item they flip.

Step-by-Step Setup

1. Open Google Sheets

Go to sheets.google.com and create a blank spreadsheet. Rename it to Itaobuy Tracker 2026. This will be your central command center for every oocbuy order you place.

2. Add Headers Row

Row 1 should contain these headers: Date, Category, Product, Buy Price, Sell Price, Shipping, Profit, Status, Notes. Make row 1 bold and freeze it so it stays visible as you scroll.

3. Enter the Profit Formula

In the Profit column (column G), type =D2-E2-F2 assuming Buy Price is column D, Sell Price is column E, and Shipping is column F. Copy this formula down for every row by dragging the fill handle.

4. Format for Readability

Bold headers, freeze row 1, set currency format for price columns, and add alternating row colors. A clean spreadsheet is a spreadsheet you will actually use every day.

Tracking Your First Order

Let us walk through a real example. You find a pair of Jordan 1 Mid on oocbuy for $45. Your estimated resale price on StockX is $95. Shipping costs $12. Enter these values into your sheet and watch the profit formula calculate $38 instantly.

Now you can see at a glance whether this purchase makes sense. A 84% profit margin is excellent. Add the order status as Ordered and update it to Shipped when you receive tracking.

Pro Tips for Daily Use

• Use data validation for the Category column to prevent typos
• Create a separate sheet for price history to track trends
• Add a dashboard sheet with charts showing monthly profit
• Use Google Sheets mobile app to update on the go
• Set up conditional formatting for negative margins in red

Common Questions

Conclusion

Using an itaobuy spreadsheet is not about perfection. It is about building a habit. Start today with one product, add a few more tomorrow, and within a week you will have a system that gives you confidence in every purchase decision.