Buying Strategy

The Best OopBuy Spreadsheet Setup: How to Organize Your Finds and Save Money

Learn how to build and use an OopBuy spreadsheet to track product links, compare prices, manage QC results, and calculate total costs before you order.

2026-05-20·10 min read·best oopbuy spreadsheet

Why You Need an OopBuy Spreadsheet Before You Start Shopping

Shopping through an agent platform like OopBuy gives you access to an enormous catalog — over 10,000 products spanning shoes, hoodies, t-shirts, jackets, and more. Without a system to organize your finds, it is easy to lose track of product links, forget which seller had the best version, or miscalculate your total cost including shipping.

An OopBuy spreadsheet solves this problem by giving you a single place to collect links, compare options across multiple sellers, track QC photo status, and calculate your total landed cost before you commit to purchasing. Whether you are building your first haul or you are a seasoned buyer placing monthly orders, a well-structured spreadsheet is the difference between a smooth experience and a chaotic one.

Essential Columns for Your OopBuy Spreadsheet

The best OopBuy spreadsheet includes these core columns. Customize based on your shopping style, but start with this foundation:

  • Product Name — A short descriptive label so you can identify items at a glance
  • Category — Shoes, Hoodies, T-Shirts, etc. Helps you group similar items for consolidated shipping
  • Platform Link — The original product URL from 1688, Taobao, or Weidian
  • Seller Name — Track which sellers consistently deliver good quality
  • Size / Color / Variant — Record the specific variant you plan to order
  • Listed Price (CNY) — The price shown on the original platform
  • Estimated Weight (g) — Critical for shipping cost calculation
  • QC Status — Track whether QC photos have been received and reviewed
  • QC Pass/Fail — Decision column: approve for shipping or request return
  • Shipping Cost Estimate — Calculate based on weight and your chosen carrier
  • Total Landed Cost — Listed price + service fee + estimated shipping
  • Notes — Any additional observations about the seller, product, or listing

How to Calculate Shipping Costs in Your Spreadsheet

Shipping cost calculation is where many new OopBuy users go wrong. The platform charges shipping based on actual weight or volumetric weight — whichever is higher. For most clothing and accessory items (shoes, hoodies, t-shirts, jackets, headwear), actual weight is the primary factor.

A practical formula for spreadsheet estimation: check the estimated weight on the OopBuy warehouse scale after items arrive, then multiply by the rate for your chosen shipping line. As a rough guide for US destinations, budget $12-18 per kg for express lines (5-10 days), $8-12 per kg for standard lines (10-20 days), and $5-8 per kg for economy routes (20-35 days). Build these into your spreadsheet as lookup values or simple formulas.

For heavier categories like shoes and jackets, always overestimate weight by 10-15% to account for packaging. A pair of sneakers typically weighs 800-1200g with box; a hoodie runs 500-800g; a t-shirt is roughly 200-300g.

Step-by-Step Workflow: From Spreadsheet to Your Doorstep

Here is the complete OopBuy workflow that the spreadsheet supports, from initial product discovery to final delivery.

1
Browse the full catalog to discover products across all 11 categories
2
Copy product links and paste into your spreadsheet under the correct category
3
Compare similar items across different sellers — note price, seller rating, and any available reviews
4
Narrow down your spreadsheet to your final selection and place orders through OopBuy
5
Update QC status as photos arrive; mark pass/fail for each item
6
Once all items are approved, submit your shipping parcel with your chosen carrier
7
Track your package and update delivery status in your spreadsheet
8
Review your spreadsheet after receiving items — note which sellers delivered the best quality for future reference

Pro Tips for Spreadsheet Power Users

Frequently Asked Questions

Should I track prices in CNY or USD in my spreadsheet?

Track original prices in CNY since that is what the platform displays. Add a conversion column to USD using the current exchange rate. This makes it easier to compare against your budget and catch any conversion surprises.

How many items should I include in one haul?

The sweet spot is typically 5-12 items — enough to make consolidated shipping cost-effective, but not so many that your package attracts extra customs scrutiny. Heavier categories like shoes and jackets will push you toward the lower end of that range.

Can I use the same spreadsheet across multiple orders?

Absolutely. Many users maintain a running spreadsheet with separate tabs for each haul. This creates a searchable purchase history that helps you reorder from trusted sellers and track total spending over time.

Ready to Start Shopping?

Now that you understand the essentials, jump into the full catalog and start building your OopBuy spreadsheet with confidence.

Browse Full Shoes Catalog