How to Use an Oopbuy Spreadsheet Step-by-Step

Before You Start: Choose Your Platform

You can use an oopbuy spreadsheet in Google Sheets, Microsoft Excel, or Apple Numbers. Google Sheets is the most popular choice because it is free, cloud-based, and works on every device. Excel offers more advanced data tools. Apple Numbers is great if you are deep in the Apple ecosystem. Pick one platform and stick with it. Switching later means reformatting formulas.

Step 1: Create Your Column Headers

Open a blank spreadsheet and create these headers in row one: Order Number, Date Added, Item Name, Store Link, Original Price, Domestic Shipping, Agent Fee, International Shipping, Total Cost, Category, Weight, Tracking Number, Status, Notes. These fourteen columns capture every data point you need. You can always hide columns you do not use yet and unhide them later.

Step 2: Add Your First Real Order

Do not practice with fake data. Open an actual order and fill in every column. This forces you to understand what each field means. If you do not know the domestic shipping cost yet, leave it blank and come back when the agent provides a quote. The goal is to build a habit of recording data at the moment you receive it.

Step 3: Track Fees and Currency Conversions

Add a currency conversion cell at the top of your sheet. Enter the current CNY to USD rate there. In the Total Cost column, write a formula that sums Original Price, Domestic Shipping, Agent Fee, and International Shipping, then multiplies by the conversion rate. Lock the conversion cell so you cannot overwrite it by accident. When the rate changes, update one cell and every total updates automatically.

Step 4: Monitor Delivery Status Visually

Use conditional formatting to color-code your Status column. Set green for Delivered, yellow for In Transit, red for Problem, and gray for Canceled. This lets you scan fifty rows in three seconds and instantly know what needs attention. Update the status every time you get a shipping notification.

Step 5: Archive and Analyze Completed Orders

Create a second sheet tab called Archive. Every month, cut and paste delivered orders from your active sheet into the archive. This keeps your main view fast and uncluttered. Once per quarter, review the archive to identify your most profitable categories, your average delivery time by shipping method, and your total spend per seller.

Conclusion

Now you know how to use an oopbuy spreadsheet from blank sheet to fully operational tracking system. The first order takes the longest. By your tenth order, updating the sheet takes under sixty seconds. For more advanced techniques, read our main oopbuy spreadsheet guide or browse our store to find your next purchase.