
The Beginner's Guide to Using the OOPBUY Spreadsheet for Agent Shopping
Learn how to navigate OOPBUY product spreadsheets, compare batches, understand W2C links, and make your first haul with confidence through any shopping agent.
What is a Shopping Agent and Why OOPBUY?
A shopping agent acts as your local proxy in China, purchasing items from platforms like Taobao, Weidian, and 1688 on your behalf and shipping them internationally. OOPBUY is one of the most trusted agents in the community, offering warehouse inspection, QC photos, and consolidated shipping. For newcomers, the sheer volume of listings can be overwhelming. That is exactly why curated spreadsheets exist.
A well-maintained OOPBUY spreadsheet distills thousands of listings into a shortlist of verified finds. Each row typically includes the product name, W2C link, price in yuan, sizing notes, known flaws, and batch recommendations. Rather than scrolling through endless search results on Chinese platforms, you get a pre-vetted directory of items that experienced buyers have already tested and approved.
Batch Comparison Checklist
Reading the Spreadsheet Columns
Most OOPBUY spreadsheets follow a familiar column layout. The first column is the item name or a short descriptor, followed by the seller or factory name. Price is usually listed in Chinese yuan; you can convert mentally at roughly seven yuan per dollar, but agents will show real-time conversion at checkout. The W2C column contains the direct purchase link that you paste into your agent order form.
The batch or version column is critical. In replica and streetwear communities, factories produce multiple iterations of the same item. A batch labeled "PK" or "LJR" for sneakers indicates which production run the item comes from. Higher-tier batches generally cost more but offer better materials, accurate shapes, and fewer flaws. The spreadsheet often color-codes or ranks these tiers so you can decide quickly.
Sizing notes deserve special attention. Chinese sizing frequently runs smaller than Western standards, and many spreadsheets include centimeter measurements or recommended size-up guidance. If the note says "size up one," you should generally add a full size or size up for a relaxed fit. W2C links should always be tested before ordering to ensure they are still active.
Placing Your First Order
Once you find an item in the spreadsheet, copy its W2C link and paste it into your agent order form. Add the price from the spreadsheet as a reference so the agent can verify the listing quickly. Select your size and color if prompted, then submit. Within a few days, the seller ships to the warehouse and you receive QC photos.
When your items arrive at the agent warehouse, you will receive quality control photos, commonly called QC pics. These are taken under bright overhead lighting and show every angle of your product. Compare these against reference images online, and if anything looks off, you can request an exchange before the item is forwarded to you. This checkpoint is why using an agent is infinitely safer than direct shipping.
When you are satisfied with your QC photos, consolidate your items into a single parcel and choose a shipping line. Budget lines like EUB or SAL are slower but cheaper; express lines like DHL or FedEx arrive within a week but cost significantly more. First-time buyers should start with a small haul of three to five items to test the process before ordering in bulk.
Copy the W2C link from the spreadsheet and paste it into your agent order form.
Enter the listed price as reference so the agent can verify the seller quickly.
Select your size using the measurement chart, not the generic label.
Submit the order and wait for warehouse arrival notification.
Review QC photos carefully against retail reference images before approving shipment.
Avoiding Common Pitfalls
One common mistake is ignoring the estimated weight. A pair of sneakers and a hoodie together can easily exceed two kilograms, pushing shipping costs higher than the items themselves. Use the spreadsheet weight notes, if available, to estimate your total parcel mass before buying. A smart haul builder tracks every item's estimated weight in a simple list.
Another pitfall is ordering without checking the spreadsheet update date. Sellers change batches, prices fluctuate, and W2C links go dead. A spreadsheet updated three months ago might contain broken links or outdated batch recommendations. Always look for the most recent revision and cross-reference with community discussions.
Finally, be cautious with extremely low prices. If a sneaker batch is twenty percent cheaper than every other listing, there is usually a reason: worse materials, softer foam, or incorrect colors. The spreadsheet price column exists to help you spot these outliers before you waste money. Trust the spreadsheet community; they have already tested the items you are considering.
Frequently Asked Questions
Related Guides

QC Photos Deep Dive: How to Spot Flaws Before Shipping Your Haul
A forensic guide to reading quality control photos so you never receive a disappointing item in your haul. Learn what to look for in every product category.

W2C Links Decoded: Understanding Purchase URLs in the OOPBUY Spreadsheet
Learn how W2C links work, how to verify they are active, and how to paste them correctly into any shopping agent order form.

How to Build Your First Haul Using the OOPBUY Finds Spreadsheet
From spreadsheet to doorstep: a step-by-step walkthrough for assembling your first curated shopping haul through any agent.
