Guide

How to Read a Spreadsheet: Decode Seller Ratings and Batch Codes

2026-03-2814 min read
spreadsheet guidebatch codesseller ratingsquality indicators
How to Read a Spreadsheet: Decode Seller Ratings and Batch Codes

Why Spreadsheets Rule

The KakoBuy Spreadsheet and community-maintained spreadsheets are the most powerful tools in replica shopping. They consolidate thousands of products, verified links, batch quality data, and seller reputations into a single searchable resource. Learning to read them efficiently saves hours of research and prevents costly mistakes.

Spreadsheets represent the collective intelligence of the buying community. Every entry has been verified by at least one buyer, and popular entries have been tested by dozens or hundreds of buyers across different batches and sizes. This crowd-sourced verification is more reliable than any single review or seller claim. When a spreadsheet entry has 50+ positive reviews across multiple buyers, you can order with high confidence.

The KakoBuy Spreadsheet specifically is maintained by a dedicated team that verifies links, updates batch information, and removes dead or low-quality entries. This active curation distinguishes it from community spreadsheets that may contain outdated or unverified information. Understanding how to navigate and interpret the spreadsheet efficiently is one of the most valuable skills a replica buyer can develop.

5878Products Cataloged
50+Batch Codes
31Agents Listed
11Categories

Understanding Batch Codes

Batch codes are shorthand for the factory or production run that made the item. Different batches have different quality levels, flaw rates, and price points. Here are the most common batch codes for sneakers.

The batch code system developed organically within the community as buyers needed a shorthand way to communicate quality levels. Factory names, seller names, and production run identifiers all became batch codes over time. Some codes refer to specific factories (LJR = a factory known for Jordan 1 quality), while others refer to specific sellers (TopStoney = a seller known for consistent quality). Understanding the distinction helps you interpret batch codes correctly.

Batch quality is not static. A batch that was excellent six months ago may have declined in quality due to factory changes, material substitutions, or increased production volume. Always check the date of reviews when evaluating batch quality. Recent reviews (within 3 months) are more reliable than older reviews for assessing current quality. Community forums regularly discuss batch quality changes, so staying active in these communities keeps you informed.

BatchQuality TierPrice RangeKnown ForBest For
LJRHigh$120-180Jordan 1 accuracyJordan 1 High, Dunks
PKHigh$100-160Yeezy Boost accuracyYeezy 350, 700
OGHigh$110-170Overall consistencyGeneral Nike models
M BatchMid-High$80-120Dunk accuracyNike Dunks
HP BatchMid$60-90Budget qualityBeater pairs, basics
DT BatchBudget$40-70Lowest priceFirst-timers, testing

Seller Rating System

Most spreadsheets include seller ratings or recommendations. Understanding these indicators helps you choose reliable sellers and avoid scams. Seller ratings are typically based on a combination of transaction volume, review scores, community reputation, and response time.

Transaction volume is one of the most reliable quality indicators. A seller with 10,000+ transactions has processed enough orders to have a meaningful track record. Their quality consistency, shipping reliability, and customer service have been tested across thousands of buyers. New sellers with fewer than 100 transactions are unproven and carry higher risk, regardless of their initial review scores.

Review scores on Chinese marketplaces can be manipulated through incentivized reviews, so they should not be the only factor in seller evaluation. Look for the distribution of reviews — a seller with 95% positive reviews and detailed, specific feedback is more trustworthy than one with 100% positive reviews consisting only of generic praise. Negative reviews, when they exist, often reveal important information about the seller's weaknesses.

Verified Seller

5

Established seller with consistent quality and reliable shipping. Recommended for all buyers.

Pros
  • Consistent quality
  • Honest QC
  • Reliable shipping
Cons
  • Slightly higher prices
  • Popular items sell out

Trusted Seller

4

Good reputation with occasional minor issues. Worth trying for specific items they specialize in.

Pros
  • Competitive prices
  • Specialized items
Cons
  • Inconsistent stock
  • Slower response times

New/Unknown

3

Limited track record. Approach with caution and order small test items first.

Pros
  • Potentially lower prices
  • New inventory
Cons
  • Unpredictable quality
  • Higher risk

Reading Quality Indicators

Spreadsheets use various markers to indicate quality. Learn these symbols and abbreviations to scan efficiently.

Beyond symbols, spreadsheets often include written quality notes that provide context for the rating. These notes might mention specific flaws to watch for, sizing quirks, or batch-specific issues. Reading these notes carefully before ordering can save you from known problems. For example, a note saying "runs small, size up one" is invaluable information that prevents a sizing mistake.

  • ✅ = Verified high quality, community tested
  • ⭐ = Recommended seller or batch
  • 🔥 = Currently trending or restocked
  • ⚠️ = Known minor flaws, read notes
  • ❌ = Avoid, significant issues reported
  • GP = Guinea Pig, new batch being tested
  • WTG = Budget seller with decent quality
  • UA = Unauthorized Authentic (verify claims carefully)

Pro Tip: Pro Tip: Sort by "sort_level" or quality rating first, then filter by your size and budget. This surfaces the best options without scrolling through hundreds of entries. Use the search function to find specific models or brands quickly.

Navigating the KakoBuy Spreadsheet

The KakoBuy Spreadsheet is organized by category, with each category containing products sorted by quality rating and popularity. The spreadsheet includes direct purchase links, price ranges, batch information, and community review summaries. Understanding the column structure helps you extract the information you need quickly.

The most important columns to check are: the product link (verify it is current and not dead), the price range (compare against your budget), the batch code (cross-reference with community reviews), the quality rating (filter to your minimum acceptable tier), and the last updated date (ensure information is current). Secondary columns like seller name, sizing notes, and community comments provide additional context for borderline decisions.

Filter by CategorySort by QualityCheck Last UpdatedVerify LinksRead NotesCross-Reference ReviewsCompare PricesCheck Batch Codes

Frequently Asked Questions

What does "GP" mean in a spreadsheet?
GP stands for "Guinea Pig" — meaning the batch or seller is new and has not been extensively community-tested. The first buyers act as testers. GP items can be great deals but carry higher risk. If you buy a GP item, share your QC photos and review with the community to help others make informed decisions. Your feedback contributes to the collective knowledge that makes spreadsheets valuable.
Should I always buy the highest-rated batch?
Not necessarily. High-tier batches cost significantly more. For items you wear casually or infrequently, mid-tier batches offer the best value. Reserve high-tier for statement pieces you wear often, items where quality is highly visible (like sneakers), or situations where you want maximum confidence in the product. The cost-per-wear calculation often reveals that mid-tier is the smarter choice for most items.
How often are spreadsheets updated?
Quality community spreadsheets are updated weekly or bi-weekly. Sellers come and go, batches improve or degrade, and prices change. Always check the "last updated" date on any spreadsheet you use. The KakoBuy Spreadsheet is actively maintained with regular link verification and quality updates. For time-sensitive information like current batch quality, supplement spreadsheet data with recent community forum posts.
What if a seller in the spreadsheet stops responding?
Contact your agent first — they can sometimes reach sellers you cannot. If the seller is truly unresponsive, request a refund through the agent. Established agents will handle disputes on your behalf. Report the unresponsive seller to the spreadsheet maintainers so the entry can be flagged or removed. This protects other buyers from the same experience.
How do I contribute to spreadsheets?
Most community spreadsheets have a submission form or Discord channel for new entries. To submit a product, provide the purchase link, seller name, batch code, price, your QC photos, and an honest quality assessment. Include sizing information and any notable flaws. High-quality submissions with photos and detailed notes are most likely to be accepted and help other buyers the most.

Start Shopping with KakoBuy

Ready to put this knowledge into action? Browse our curated product spreadsheet and find your next haul.

Visit KakoBuy