So you've just discovered the world of purchasing agents and someone dropped a massive spreadsheet link in your DMs. You open it up, and suddenly you're staring at columns labeled \"W2C,\" \"GP'd,\" \"QC,\" and about fifteen other abbreviations that might as well be ancient hieroglyphics.
Yeah, I've been there. My first time looking at a community spreadsheet, I genuinely thought \"W2C\" was some kind of product code. Spoiler alert: it's not.
Here's the thing about spreadsheet shopping—once you crack the code on what these columns actually mean, the entire purchasing agent experience becomes about ten times easier. You're not just randomly clicking links anymore. You're making informed decisions based on real data from people who've already taken the risk.
The Essential Columns You'll See Everywhere
Let me walk you through the most common spreadsheet headers you'll encounter, starting with the absolute basics. Every decent spreadsheet—including the CNFans Spreadsheet—uses some variation of these core columns.
W2C (Where to Cop)
This is your golden ticket. W2C means \"Where to Cop,\" and it's literally just the link to buy the item. When you see this column, you're looking at direct Taobao, Weidian, or 1688 links that take you straight to the seller's page. No mystery here—click it, and you're shopping.
But here's what nobody tells beginners: not all W2C links are created equal. Some sellers change their store links constantly (especially if they're selling reps that get taken down). I've clicked on W2C links from spreadsheets that were only three months old and found dead pages. Always check the date on the spreadsheet entry.
Price Column (Usually in Yuan ¥)
Pretty self-explanatory, right? Except here's where it gets interesting. The price listed in spreadsheets is almost always the item price only—it doesn't include domestic shipping to the warehouse, international shipping to you, or any agent fees.
I learned this the hard way when I saw a pair of Dunks listed at ¥190 and thought I was getting them for about $27. By the time I paid for everything, I was closer to $65. Still a solid deal compared to retail, but that sticker shock hit different when the final invoice came through.
GP or GP'd (Guinea Pig)
This one's actually kind of funny. When someone \"GPs\" an item, they're the guinea pig—the brave soul who orders from an unknown or new seller first to test the quality. If you see \"GP'd\" with a date, it means someone already took that risk and you can usually find their review or QC photos somewhere.
Look, I respect the GPs out there. They're doing the lord's work so the rest of us don't end up with shoes that fall apart after two wears. If you see a recent GP with positive feedback, that's basically a green light.
QC Status or QC Photos
QC stands for Quality Control, and this column tells you whether quality check photos are available. Some spreadsheets link directly to QC photo albums, while others just mark \"Yes\" or \"No.\"
This is where you need to slow down and actually do the work. Don't just see \"QC: Yes\" and assume everything's perfect. Click through and look at those photos yourself. Check the stitching on those Jordan 1s. Look at the swoosh placement. Compare the color to retail photos. I've seen items marked as having QC photos where the quality was... let's just say questionable.
The Advanced Columns That Separate Rookies from Veterans
Once you've got the basics down, you'll start noticing more detailed columns that give you way more intel about what you're buying.
Batch or Version
Okay, this is where spreadsheet shopping gets really granular, especially for sneakers. The \"Batch\" column tells you which production run or factory version of an item you're looking at. For popular shoes like Yeezy 350s or Travis Scott Jordans, there might be five different batches from different factories, all at different price points and quality levels.
You'll see codes like \"LJR,\" \"PK,\" \"G Batch,\" or \"VT Batch.\" Each one represents a different factory or production standard. LJR batch, for example, is generally considered top-tier for Jordan reps. PK (Perfect Kicks) is known for Yeezys. The CNFans Spreadsheet often includes batch info because it genuinely matters—a ¥150 budget batch is going to look noticeably different from a ¥400 premium batch.
I once bought two pairs of the same shoe from different batches just to compare. The difference was wild. The cheaper batch had this weird chemical smell and the leather felt like cardboard. The premium batch? Honestly couldn't tell it apart from my retail pairs without really inspecting it.
Size Range or TTS (True to Size)
This column saves lives. Or at least saves you from ordering shoes that don't fit. When a spreadsheet lists \"TTS\" it means the item fits true to standard sizing. But you'll also see notes like \"Size up 0.5\" or \"Runs small\" or \"Asian sizing.\"
Pay attention to this. Asian sizing typically runs 1-2 sizes smaller than US/EU sizing, especially for clothing. I've seen people order their normal size Large hoodie and receive what's essentially a Medium because they ignored the sizing notes. The spreadsheet is trying to help you—listen to it.
Weight (Usually in Grams)
This might seem like a weird detail to include, but weight matters a lot when you're paying for international shipping by the kilogram. A 1200g hoodie costs more to ship than an 800g hoodie, even if they're the same price to purchase.
Smart shoppers use the weight column to calculate their total haul cost before ordering. If you're building a 5kg haul and trying to stay under budget, knowing that those chunky sneakers weigh 1400g each helps you plan better. Some spreadsheets even include a shipping calculator based on weight estimates.
Seller Rating or Reputation
Some spreadsheets include a rating system or notes about seller reliability. You might see \"Trusted Seller,\" \"Fast Shipping,\" or \"Good Communication\" in this column. Alternatively, you might see warnings like \"Slow\" or \"B&S Risk\" (Bait and Switch).
This is community knowledge distilled into a single column. When dozens of people have ordered from the same seller and consistently report good experiences, that's valuable data. Conversely, if multiple people got burned, you'll usually see a warning.
The Columns That'll Save You Money
Let's be real—half the reason we're using agents and spreadsheets is to save cash. These columns help you maximize value.
Discount Codes or Coupons
Not every spreadsheet has this, but the good ones do. Some sellers offer discount codes that knock ¥10-50 off your order, and spreadsheet maintainers will include them if they're available. The CNFans Spreadsheet sometimes lists platform-specific coupons that work across multiple sellers.
I've saved probably ¥200+ over the past year just by checking this column before ordering. It's literally free money—use it.
Stock Status
This tells you whether the item is currently available or out of stock. Sounds simple, but here's the catch: stock status changes constantly. A spreadsheet might say \"In Stock\" but by the time you order two weeks later, the seller's sold out.
The best spreadsheets include a \"Last Updated\" date so you know how fresh the information is. If you're looking at stock status from six months ago, take it with a grain of salt and maybe message the seller through your agent first to confirm.
Return/Exchange Policy
This is clutch information that too many people ignore until it's too late. Some sellers accept returns or exchanges, others have a strict no-return policy. The spreadsheet will usually note this.
If you're buying something risky—like a new batch that hasn't been reviewed much, or an item with tricky sizing—prioritize sellers who accept returns. Yeah, you might pay ¥20 more, but that peace of mind is worth it when you're dropping ¥500 on a haul.
How to Actually Use This Information
Knowing what the columns mean is step one. Using them strategically is where you level up your spreadsheet game.
Here's my personal workflow: I start with the item I want—let's say a pair of New Balance 550s. I'll search the spreadsheet for that model and immediately look at three columns: Price, Batch, and QC Status. This gives me a quick overview of my options.
Then I narrow it down. If there are five listings, I'll eliminate any without QC photos (too risky) and any budget batches if I care about accuracy (which I usually do for shoes). That typically leaves me with 2-3 solid options.
Next, I check the W2C links to make sure they're still active, look at the seller ratings, and read any notes about sizing. If everything checks out, I'll click through to the actual QC photos and spend a few minutes comparing them to retail images.
The whole process takes maybe ten minutes, but it's ten minutes that's saved me from countless bad purchases. I used to just buy based on price alone, and I ended up with a drawer full of stuff I never wore because the quality was trash or the sizing was off.
Cross-Reference Multiple Spreadsheets
Here's a pro tip: don't rely on just one spreadsheet. The CNFans Spreadsheet is great, but there are other community spreadsheets out there for specific niches—sneaker spreadsheets, designer rep spreadsheets, streetwear spreadsheets.
If you find the same seller and batch listed across multiple spreadsheets with consistently good reviews, that's about as close to a guarantee as you'll get in this game. It means multiple communities have vetted that source independently.
Pay Attention to Update Frequency
A spreadsheet that hasn't been updated in eight months is basically useless for current stock and pricing info. Links go dead, sellers change, prices fluctuate. Look for spreadsheets that show recent activity—new entries added within the last few weeks, updated QC photos, fresh GP reports.
The CNFans Spreadsheet is actively maintained, which is honestly one of the main reasons I keep coming back to it. There's nothing more frustrating than spending time researching an item only to find out the link's been dead for months.
Common Spreadsheet Mistakes Beginners Make
Let me save you some headaches by pointing out the mistakes I see all the time in Reddit comments and Discord channels.
Mistake #1: Ignoring the notes column. If there's a notes section, read it. Seriously. That's where you'll find critical info like \"Seller ships slow\" or \"Color is off\" or \"Size up twice.\" People skip this and then complain when their order takes three weeks or doesn't fit.
Mistake #2: Assuming higher price equals better quality. Sometimes yes, sometimes no. I've bought ¥400 items that were worse than ¥200 alternatives from a different seller. Price is one factor, but batch quality, seller reputation, and QC photos matter just as much.
Mistake #3: Not checking the date. That \"GP'd 2022\" notation means the information is two years old. Batches change. Sellers change. Quality changes. Always prioritize recent data.
Mistake #4: Trusting stock status blindly. As I mentioned earlier, stock changes fast. If you're serious about an item, have your agent contact the seller to confirm availability before you commit to buying.
Building Your Own Spreadsheet System
Once you've done a few hauls, you might want to create your own personal tracking spreadsheet. I started doing this after my third order because I kept forgetting which sellers I'd used and which batches I'd bought.
My personal spreadsheet includes: Item name, seller name, W2C link, price paid, batch, order date, QC received date, shipping date, and my own quality rating after receiving it. It sounds like overkill, but when I'm planning my next haul, I can quickly reference which sellers were reliable and which items held up well after months of wear.
You don't need anything fancy—Google Sheets works perfectly. The act of logging this information also makes you a more conscious shopper. You start noticing patterns, like \"Oh, I've ordered from this seller three times and every time the quality was solid\" or \"This batch looked great in QC photos but the materials feel cheap in person.\"
The Bottom Line on Spreadsheet Columns
Look, spreadsheet shopping isn't rocket science, but it does require you to actually engage with the information instead of just clicking the first link you see. Those columns exist for a reason—they're the collective wisdom of thousands of people who've already made the mistakes so you don't have to.
Take the time to understand what you're looking at. Cross-reference information. Check those QC photos. Read the notes. And for the love of all that is holy, pay attention to sizing information.
The CNFans Spreadsheet and others like it are genuinely incredible resources that make agent shopping accessible to everyone. But they only work if you use them properly. Treat each column as a piece of the puzzle, and pretty soon you'll be navigating these spreadsheets like a veteran, finding deals and quality items that your friends will ask about.
At the end of the day, the spreadsheet is just a tool. Your judgment, research, and willingness to dig a little deeper—that's what turns a random purchase into a haul you'll actually be excited to wear. Now go forth and decode those columns like the savvy shopper you're becoming.