How to Use the Oopbuy Spreadsheet

If you have never used a buying agent before, the process can feel intimidating. You browse products on foreign-language websites, copy links into an agent's portal, pay in a currency you do not hold, and then wait weeks for a package to cross an ocean. The oopbuy spreadsheet removes the chaos from that workflow by giving you a single place to plan, track, and review every step.

This tutorial assumes you have zero spreadsheet experience. We explain every click, every formula, and every column. By the end, you will have a working tracker that tells you exactly how much your next haul will cost and where every item sits in the order pipeline.

What You Need Before You Start

You only need three things: a free Google account, our basic tracker template, and a rough idea of what you want to buy. If you prefer Excel, the template works identically, though some cloud features like real-time sharing are Google-only.

Open the template in a new browser tab. You will see three tabs at the bottom: Tracker, Fee Config, and Dashboard. Do not touch the Dashboard yet. It is fully automatic. Your job is to fill the Tracker and configure the Fee Config sheet.

Step 1: Configure Your Fee Structure

Click the Fee Config tab. You will see a small table with three columns: Fee Type, Rate, and Notes. The most common fee types are service fee per item, photo fee per item, and shipping insurance percentage. Visit your buying agent's pricing page and copy the exact numbers into this table.

For example, if your agent charges a 10% service fee with a minimum of ¥35 per item, enter "Service Fee", "10%", and "Minimum ¥35" in the notes. If they also charge ¥5 per QC photo, add that as a separate row. These values feed into the main tracker automatically.

Important: Use the same currency your agent displays. Most Chinese agents show fees in RMB. The tracker converts to your home currency later. Do not convert manually here. Let the formula handle it.

Step 2: Enter Your First Product

Switch to the Tracker tab. Row 1 contains headers. Row 2 is pre-filled with example data so you can see how it works. Starting from Row 3, enter your own products one per row.

Column A is the product name. Keep it short but descriptive, like "Nike Dunk Low Panda". Column B is the marketplace URL. Paste the full link. Column C is the marketplace source. Use the dropdown: Taobao, Weidian, 1688, or Other. Column D is the item price in local currency. Just type the number, no symbols.

Column E is the estimated weight in grams. If you do not know, leave it blank for now. You can fill it in after the agent measures the item at the warehouse. Column F is the agent name. Use the dropdown or type it. Column G is status. Use the dropdown: Wishlist, Ordered, Arrived, QC, Approved, Packed, Shipped, Delivered.

The moment you enter the price and agent name, several green columns to the right will auto-populate. These show domestic shipping estimate, agent service fee, international shipping estimate, and total landed cost in USD. Do not edit the green cells. They are formula-protected.

Step 3: Add Five More Products

Repeat the process for five items. This gives you enough data to see patterns. You might notice that small accessories have disproportionately high agent fees because of the per-item minimum. You might see that a heavy jacket pushes your shipping estimate into a higher bracket. These insights only appear once you have multiple rows.

Use the Wishlist status for items you are still considering. This keeps them in the sheet without adding them to cost totals. Only items marked Ordered or beyond count toward your spending dashboard.

Step 4: Review the Dashboard

Click the Dashboard tab. This is the reward for your data entry. You will see a summary box showing total items, total spent, items in transit, items delivered, and average landed cost per item. Below that is a bar chart showing spending by category and a small table showing your most expensive item.

The dashboard updates instantly whenever you edit the tracker. Add a new product, and the total spent jumps. Mark an item as Delivered, and the delivered count increments. This real-time feedback loop is what makes the spreadsheet addictive: you always know your numbers.

Step 5: Update Status as Orders Progress

The real power of a tracker emerges during the waiting period. After you submit an order to your agent, change the status from Wishlist to Ordered. When the agent confirms they received it at the warehouse, change to Arrived. When QC photos are uploaded, change to QC. Review the photos. If the item looks correct, change to Approved. Once the agent packs your haul, change to Packed. When they hand it to the courier, change to Shipped. When it lands on your doorstep, change to Delivered.

Each status change triggers conditional formatting. Approved rows turn green. Shipped rows turn amber. Delivered rows turn gray. At a glance, you know what needs attention and what is already finished.

Step 6: Optimize Before Submitting Your Haul

Before you tell the agent to pack and ship, review your tracker. Sort by weight descending. Are there heavy items that push your total into a costly shipping bracket? Consider removing one. Filter by status Arrived. How many items are sitting in the warehouse? If it is only two or three, you might wait for more to arrive and consolidate into a bigger, more efficient haul.

Use the total landed cost column to decide whether an item is worth shipping at all. Sometimes a ¥30 accessory ends up costing $18 after fees and shipping. Delete the row and buy it locally instead.

Quick Tips for Faster Data Entry

Copy and paste URLs in bulk. If you browse Taobao and open ten items in separate tabs, copy all ten URLs at once and paste them down the URL column. Then fill in names and prices afterward.

Use keyboard shortcuts. Tab moves right. Enter moves down. Ctrl+D fills down a formula or value. These three shortcuts cut data entry time in half.

Bookmark your tracker. Make it the first tab you open when you start shopping. The more accessible it is, the more likely you are to keep it updated.

Set a weekly review alarm. Every Sunday, spend five minutes updating statuses and reviewing the dashboard. This prevents stale data and missed deadlines.

Spreadsheet vs. No Spreadsheet: A Real Example

Let us compare two shoppers buying the same five items. Shopper A uses our tracker. Shopper B wings it with mental math and browser bookmarks.

Frequently Asked Questions

Conclusion

Setting up a buying agent spreadsheet takes less time than watching one episode of a TV show, yet it saves you hours of confusion, dozens of dollars in avoidable fees, and countless headaches down the road. Start simple. Use the basic tracker. Enter five products. Watch the dashboard come alive. Then expand as your confidence grows.

For a deeper dive into advanced formulas, multi-agent workflows, and reseller profit tracking, read our comprehensive Ultimate Oopbuy Spreadsheet Guide. If you are still evaluating whether buying agents are right for you, check our safety and legitimacy analysis before placing your first order.