Demystifying the Litbuy Spreadsheet for Beginners
Demystifying the Litbuy Spreadsheet for Beginners
TL;DR: The Litbuy spreadsheet, once you grok its structure and shorthand, is an indispensable tool for serious reps collectors navigating the vast, often opaque world of Chinese e-commerce.
Check the always-updated master list at my site →
Comparison with alternatives
Look, I've been in the game long enough to remember when the only "spreadsheet" was a furiously updated text file on some obscure forum, or even worse, just a mental catalog of what trusted sellers were pushing. We've come a long way. Before the Litbuy model became more prevalent, sourcing was a fragmented mess. You had individual seller albums on platforms like WeChat or Yupoo, often linked to through Reddit communities like r/FashionReps or r/Repsneakers. Each seller had their own idiosyncratic naming conventions, their own QC methods (or lack thereof), and their own price structures. It was like piecing together a mosaic made of a thousand different puzzles.
Then came the aggregation phase. People started compiling rudimentary Google Sheets, often focused on a single niche (e.g., "popular sneakers GL list"). These were better, but still suffered from rapid obsolescence, poor version control, and a heavy reliance on manual updates from a single, often overwhelmed, curator. The data was frequently stale, links dead, and key information missing. Batches weren't consistently noted, pricing wasn't standardized, and key attributes like material composition or sizing charts were often absent.
The Litbuy spreadsheet, in its current iteration, represents a significant evolution. It’s not just a list; it’s a structured, somewhat standardized database. Compared to the old ways, its strength lies in its attempt at comprehensive data points: direct links to product pages (often Taobao or Weidian), consistent price ranges (though always subject to change), a focus on batch quality distinctions, and often, a rudimentary QC grading or a consensus "best batch" recommendation. While not perfect, it centralizes information in a way that previous methods simply couldn’t, offering a more efficient, albeit still complex, entry point for navigating the labyrinthine world of Chinese manufacturing. For anyone serious about collecting, moving beyond scattered Yupoo albums to a centralized system like this is non-negotiable.
Why I ended up using this
My journey to fully embracing the Litbuy spreadsheet wasn't immediate. For years, I prided myself on my deep-dive forum scavenging, my intricate network of seller contacts, and my ability to sniff out a decent batch from a mile away based purely on obscure photo angles. I felt like an artisan, meticulously crafting my own GL lists. But honestly? It was unsustainable. The sheer volume of new releases, new batches, and new sellers quickly outpaced my capacity to track it all manually. I spent more time finding information than actually evaluating it.
The tipping point was a couple of bad orders. I'd relied on outdated information from a year-old Reddit post for a "designer hoodie" only to receive a completely different batch – inferior fabric, off-color, and clearly not what was advertised. My own ad-hoc system, once a source of pride, had become a liability. That’s when I started experimenting with the emerging consolidated lists. I tried a few, and most were still too basic, too inconsistent.
What drew me to the Litbuy model, specifically, was its relatively robust structure and the collaborative nature (even if behind the scenes) that keeps it somewhat current. It's not perfect, but it attempts to address the core pain points: identifying the "best" available batch for specific items, linking directly to a purchase point, and providing some context around sizing and pricing. The sheer breadth of items covered, from various popular sneakers to accessories, also meant less jumping between disparate lists. It became my primary landing page for any new search, a starting point from which I’d then branch out to specific seller QCs if needed. It saves me hours. Seriously. I can quickly scan for what I’m tracking this month, see the general consensus, and then dive deeper if I need to. It's about efficiency and reducing the mental overhead of maintaining an ever-expanding mental catalog of disparate information. You can also dive into my curated spreadsheet for an even more refined selection that I personally vouch for.
Walkthrough
Alright, let's break down the beast. When you first open the Litbuy spreadsheet (or any similar comprehensive rep sheet), it can feel like staring at a matrix code. Don't panic. It’s organized for efficiency, not aesthetics.
Understanding the Columns
While specific column headers might vary slightly between different versions or curators, the core information usually remains consistent. Here’s a typical breakdown:
Item Name / Description: This is usually the most straightforward column, identifying the product. Don’t expect official brand names; expect descriptive terms.
Batch / Factory: CRITICAL. This is arguably the most important column. It tells you which factory or which production run this particular item comes from. Examples: LJR, PK, OG, M Batch, FQ, VT. Different batches have different strengths and weaknesses (e.g., LJR might be great for popular sneakers, while PK might excel in "designer bags"). Always cross-reference this with specific item reviews.
Price (CNY): The price in Chinese Yuan. This is usually the item cost before agent fees, domestic shipping, and international shipping. Always factor in these additional costs. Use a quick currency converter.
W2C (Where to Cop) Link: This is your direct link to the product page, typically on Taobao or Weidian. You'll need an agent (like Pandabuy, Sugargoo, etc.) to purchase from these links. For more info on this, check out the Wikipedia article on e-commerce in China.
Notes / Comments: This is where the curator or community provides crucial context. You’ll find things like: "GL if minor flaws," "RL if X flaw," "Best batch for X colorway," "Size up/down recommended," or "Material is 0.9:1." PAY ATTENTION TO THIS.
QC (Quality Check) Photos Link: Often a separate link to an album (Imgur, Yupoo) showing actual QC photos from buyers or the seller. Essential for visual inspection before ordering.
Sizing Chart / Fit: Sometimes a link to a sizing chart, or just a note on how the item fits (TTS - True To Size, runs small, runs large).
Last Updated: Indicates when that specific entry was last verified or changed. Crucial for understanding data freshness.
Navigating & Filtering
Most spreadsheets will have filter options. Learn to use them. If you’re looking for a specific item, use Ctrl+F (or Cmd+F on Mac) to search. If you want to see all items from a particular batch, filter the 'Batch' column. Want to find items under a certain price? Filter the 'Price' column.
Abbreviations You Need to Know:
QC: Quality Check. Photos taken by your agent of the actual item they received, before it ships to you.
GL: Green Light. Means the item passed QC and is good to ship.
RL: Red Light. Means the item failed QC and should be returned/exchanged.
W2C: Where to Cop. A link to purchase.
TTS: True To Size. Fits as expected.
Batch: A production run from a specific factory. Key to understanding quality and accuracy.
GL/RL Reasons: Common flaws to look for (e.g., stitching, logo placement, material, color accuracy).
CNY: Chinese Yuan. The local currency.
Agent: A third-party service (like Pandabuy) that buys items for you from Chinese retailers and ships them internationally.
Yupoo: A common image hosting platform used by sellers.
Weidian/Taobao: Primary Chinese e-commerce platforms.
Pro-Tip: Cross-Reference Everything
Never rely solely on one source. Find an item on the spreadsheet? Good. Now, take the item name and batch, and search Reddit (e.g., r/FashionReps, r/Repsneakers) for recent QC posts of that specific batch. Look at multiple QC photos. Read comments. See what flaws others are finding. This due diligence is what separates a smart collector from someone making impulse buys. My sourcing notes section often highlights these cross-references for items I'm considering.
Finds
Over the past few months, the Litbuy spreadsheet has helped me dial in some solid pickups. Here’s a quick overview of some notable finds and general trends I’ve observed:
Popular Sneakers (v1) — Batch I Looked For: LJR, PK · Typical Price (CNY): 400-600 · Key Feature/Flaw: LJR often better overall shape · Sizing Notes: TTS for most
Popular Sneakers (v2) — Batch I Looked For: LW, OG · Typical Price (CNY): 350-500 · Key Feature/Flaw: LW has consistent sole durability · Sizing Notes: Size up 0.5 for wider
Designer T-Shirts — Batch I Looked For: M, FQ · Typical Price (CNY): 120-200 · Key Feature/Flaw: M for better neck tags/wash tags · Sizing Notes: Size up 1-2 for US
Designer Hoodies — Batch I Looked For: G, XP · Typical Price (CNY): 250-400 · Key Feature/Flaw: G for thicker blanks/print quality · Sizing Notes: Size up 1 for relaxed
Popular Accessories — Batch I Looked For: No specific batch · Typical Price (CNY): 80-150 · Key Feature/Flaw: Check hardware/material closely · Sizing Notes: N/A
I've seen the "LJR batch" continue to dominate for certain popular sneakers, especially those with intricate designs, consistently delivering good overall shape and material accuracy, though sometimes with minor stitching inconsistencies on the outsole. For "designer tees," the "M batch" frequently comes up as a strong contender, often praised for its blank quality and relatively accurate tags, though print alignment can occasionally be a gamble.
What's really fascinating is observing the evolution of batches. A "best" batch one month might be superseded the next, or a factory might improve an older batch. For example, I recently tracked a "popular bag" that initially had glaring hardware flaws in the "old batch." Within weeks, the Litbuy spreadsheet noted a "new batch" from the same factory, and subsequent QC photos confirmed significant improvements. This dynamic nature is precisely why an actively maintained list is so crucial. It’s not just about finding an item, it’s about finding the best current iteration of that item.
My current list highlights several items where recent batch updates have truly made a difference. I highly recommend anyone new to this to pay close attention to the "Notes" and "Last Updated" columns. They’re often more valuable than the initial item description itself. It's a continuous learning process, but the right tools make it manageable.
FAQ
Q1: What's the biggest mistake beginners make using these spreadsheets?
A1: Relying solely on the spreadsheet without cross-referencing. The spreadsheet is a starting point. You must take the item and batch information and search for recent QC photos and reviews on Reddit or other forums. An entry might say "best batch," but if the most recent QC photos show a significant flaw for your specific item/colorway, you need to know that before you order.
Q2: Why are there so many different batches for the same item?
A2: Different factories specialize in different aspects or have varying access to materials and skilled labor. One factory might nail the material, but struggle with stitching. Another might have perfect branding but use a slightly off-color fabric. These "batches" are essentially different factories' attempts to replicate an item, each with its own strengths, weaknesses, and price points.
Q3: How do I know if the prices are accurate?
A3: The prices listed are generally the base product cost in CNY from the direct seller. However, these can fluctuate. More importantly, they do not include domestic shipping (from seller to agent), agent service fees, or international shipping to your door. Always factor in an additional 10-30% for agent fees and domestic shipping, plus the significant cost of international freight. Use the listed price as a guide, not a final total.
Q4: My agent says the link is dead or item is out of stock. What do I do?
A4: This happens frequently. Products go OOS, sellers close down, or links get updated. First, check the "Last Updated" column on the spreadsheet. If it's old, the info might be stale. Second, try searching the seller's store directly on Taobao/Weidian if the spreadsheet provides the store name – they might have re-listed it. If not, you'll need to look for an alternative batch or seller for that item, or simply wait for an update to the spreadsheet.
This post contains affiliate links; I may earn a small commission at no cost to you.
Last reviewed: April 2026