So you've stumbled onto this whole world of buying stuff through purchasing agents using spreadsheet Excel files, and honestly? I get why it feels overwhelming at first. I remember staring at my first spreadsheet thinking \"what am I even looking at here?\" But here's the thing—once you know what to look for, it's actually way simpler than traditional shopping.
Let me walk you through this exactly how it happens, step by step, so you don't waste money or time on rookie mistakes.
Step 1: Finding and Opening the Spreadsheet (Day 1)
Your journey starts when someone shares a spreadsheet link with you—usually an Excel file or Google Sheets. The CNFans Spreadsheet is one of the most popular ones out there, and for good reason. It's regularly updated and has thousands of product links already organized.
First thing you need to check: when was this spreadsheet last updated? Look at the top of the document or check the file properties. I've seen people try to order from spreadsheets that were 8 months old, and guess what? Half the links were dead. You want something updated within the last 30 days, ideally within 2 weeks.
Next, scan the structure. A good spreadsheet will have these columns at minimum:
- Product category or type
- Item description or name
- Direct purchase link (usually to Weidian, Taobao, or 1688)
- Price in Yuan (¥)
- Seller rating or notes
- Size information or charts
If you're looking at a spreadsheet that's just random links with no context? Skip it. You'll waste hours trying to figure out what's what.
Step 2: Evaluating Product Links (Day 1-2)
Now comes the part where most beginners mess up. You can't just click a link and assume it's good to go.
Open each product link you're interested in. Yeah, I know the sites are in Chinese—use Google Chrome's auto-translate feature. Here's what you're checking:
Seller reputation: Look for the crown icons or rating numbers. On Weidian, you want sellers with at least a few crowns. On Taobao, check the percentage rating—anything below 95% is sketchy. I personally won't touch a seller under 97%.
Sales volume: How many people have bought this exact item? If it says 2 sales, you're basically a guinea pig. I look for at least 50+ sales, preferably 200+. More sales means more customer photos and reviews to check out.
Customer photos: Scroll down to the reviews section. The gold mine is customer-uploaded photos—not the professional seller photos. These show you what actually arrives. I once avoided a terrible jacket because customer photos showed the color was completely different from the listing.
Step 3: Price Verification and Comparison (Day 2)
Here's where spreadsheets can either save you money or lead you astray. Just because a price is listed in the spreadsheet doesn't mean it's current or accurate.
Click through to the actual product page and verify the price yourself. Sellers change prices all the time. I've seen spreadsheet prices be off by 50-100 yuan because the seller ran a sale that ended or raised prices due to material costs.
Do a quick comparison check too. Open the same product from 2-3 different sellers if possible. Sometimes the spreadsheet lists a mid-tier option when there's a cheaper batch that's just as good. The CNFans Spreadsheet usually includes multiple seller options for popular items, which makes this easier.
Calculate your total cost including agent fees. Most agents charge 5-10% service fee. So if something costs ¥200, you're actually paying ¥210-220 plus domestic shipping to the warehouse (usually ¥5-10). Keep a running total in a separate note.
Step 4: Deep Dive into Sizing—This Is Critical (Day 2-3)
Look, I'm going to spend extra time on this because sizing is where I see the most expensive mistakes happen. We're talking about Chinese sizing, which is completely different from US or EU sizing.
Never, ever trust the size labels. A Chinese \"Large\" might fit like a US Small. I'm serious.
Here's your exact process:
Find the size chart on the product page. It's usually in the product images—scroll through all of them. Screenshot it or save it. The measurements will be in centimeters.
Now measure yourself or a piece of clothing you own that fits perfectly. You need these measurements:
- Shoulder width (seam to seam across the back)
- Chest width (armpit to armpit, laid flat)
- Length (top of shoulder to bottom hem)
- Sleeve length (shoulder seam to cuff)
For pants:
- Waist (laid flat, doubled)
- Hip width (at the widest point)
- Inseam length
- Thigh width
Compare YOUR measurements to the size chart. Don't compare your usual size—compare actual centimeter measurements. I wear US Medium in most brands, but I order Chinese XL or XXL depending on the seller. It varies wildly.
Pro tip I learned the hard way: Chinese sizing often assumes a slimmer, shorter build. If you're between sizes, size up. Returns are expensive and complicated with agents. I once spent $40 shipping back a hoodie that was too small when I should've just ordered one size up from the start.
Check the product reviews for sizing feedback. Use Google Translate on the Chinese reviews. People often say stuff like \"order one size up\" or \"fits true to chart.\" This is insider information you can't get anywhere else.
Step 5: Checking Stock Availability (Day 3)
Spreadsheets don't update in real-time. A product that was in stock last week might be sold out today.
Before you commit to ordering through your agent, check the product page for stock indicators. Look for size/color options that are grayed out or crossed out—those are out of stock. Some sellers show stock numbers (like \"999+ available\" or \"23 remaining\").
If you're ordering multiple items, prioritize checking stock on your must-haves first. I've had agents come back and say 3 out of 5 items were out of stock, which messed up my shipping cost calculations since I was under the weight threshold for a cheaper shipping method.
Step 6: Quality Indicators and Red Flags (Day 3-4)
Not everything in a spreadsheet is worth buying. Here's what separates good finds from garbage:
Green flags:
- Detailed product photos showing close-ups of materials, stitching, tags, and hardware
- Video content in the listing showing the item from multiple angles
- Seller responds to customer questions in the Q&A section
- Recent positive reviews (within last 30 days)
- Clear return/exchange policy stated
Red flags:
- Only 1-2 photos, all from the same angle
- Stock photos that look professionally shot (might be stolen from brand websites)
- No customer reviews or photos despite being listed for months
- Price is dramatically lower than other sellers (like 50% cheaper—probably a scam or terrible quality)
- Seller account is brand new with no history
I personally skip anything that has more than two red flags. It's not worth the hassle.
Step 7: Organizing Your Order List (Day 4)
Before you send anything to your purchasing agent, get organized. Create your own simple spreadsheet or document with:
- Product link
- Item name/description
- Size and color you want
- Price (verified by you, not just from the spreadsheet)
- Any special notes (\"ask seller about material\" or \"need QC photos of logo\")
This saves you from the back-and-forth with your agent. Trust me, the clearer you are upfront, the faster your order gets processed. I've cut my processing time from 5 days to 2 days just by being more organized.
Step 8: Requesting QC Photos (Day 7-10)
Once your agent orders the items and they arrive at the warehouse, you'll get QC (quality control) photos. This is your last chance to catch problems before international shipping.
Look at those photos carefully. Zoom in. Check:
- Does it match the product listing?
- Any visible defects, stains, or damage?
- Are logos or text printed clearly?
- Does the color look right?
- Any loose threads or poor stitching?
Don't be shy about asking for additional photos. Most agents give you 3-5 free photos, then charge ¥1-2 per extra photo. It's worth spending ¥10 on extra photos to avoid receiving a ¥300 item that's defective.
If something looks off, reject it immediately. Tell your agent you want a return or exchange. Yeah, it delays your haul by a week, but it's better than being stuck with something unwearable.
The CNFans Spreadsheet Advantage
Why do I keep mentioning the CNFans Spreadsheet specifically? Because it's maintained by people who actually use these agents and buy these products. It's not some random collection of links.
The spreadsheet includes notes about sizing, quality tiers, and which sellers are reliable. Someone's already done the homework for you. But—and this is important—you still need to verify everything yourself. Use it as a starting point, not gospel truth.
The community behind CNFans also shares updates when sellers change links or when quality drops. That kind of real-time information is invaluable when you're spending your own money.
Final Reality Check
Buying through spreadsheet Excel files and purchasing agents isn't instant gratification shopping. You're looking at 2-4 weeks total from order to delivery, sometimes longer. But the trade-off is access to products and prices you literally can't get anywhere else.
The key is being thorough upfront. Spend those first few days really researching, measuring, and verifying. I know it feels like a lot of work, but I've saved thousands of dollars this way compared to buying the same stuff through resellers or middlemen who mark everything up 200-300%.
Start small if you're nervous. Order 2-3 items your first time to learn the process. Once you've done it successfully once, the second time takes half the effort because you know what to look for.
And honestly? After you get your first haul and realize you paid ¥800 for stuff that would've cost $400+ elsewhere, you'll understand why people swear by this method.