The Complete Litbuy Spreadsheet Guide: How We Curate Every Listing

The Litbuy spreadsheet in 2026 is not a simple price list. It is a living database of over six thousand active listings spanning eleven product categories, from sneakers and hoodies to accessories and jerseys. Each row contains a Weidian identifier, seller metadata, CNY pricing, SKU variant arrays, QC image links, and an editorial sort_level score. For buyers, the spreadsheet can be overwhelming. Without filtering, you are staring at raw commodity data with no narrative context. That is where our directory adds value. We ingest the spreadsheet daily via automated pipeline, run it through our curation algorithms, and surface items that meet minimum thresholds for data completeness, community sentiment, and visual consistency. The result is a browsable, searchable catalog where every product card you click has already passed through multiple quality gates before it ever reaches your screen.

Stage one is ingestion: we pull all is_active=true records from the source spreadsheet every six hours. Stage two is deduplication: identical Weidian IDs listed under multiple category tags are merged and their metadata reconciled. Stage three is integrity scoring: we verify that main_image URLs resolve, that SKU arrays are parseable, and that price fields contain numeric values. Stage four is community cross-reference: we match seller identifiers against our community sentiment index, flagging listings from sellers with recent complaint clusters. Stage five is editorial review: our team manually inspects the top 15 percent of items by sort_level, confirming that product photography matches the described SKU and that pricing aligns with market norms. Only after all five stages does an item appear in our Hot Picks or category grids. This pipeline processes roughly 380 items per hour and removes approximately 12 percent of listings during each cycle for data quality or sentiment issues.

The sort_level field is the primary ranking signal in the Litbuy spreadsheet. It ranges from 0 to 130 in the current dataset, with higher values indicating stronger editorial confidence. However, we do not simply show the highest sort_level items first. Instead, we sort descending by sort_level and then apply a seeded shuffle using a stable hash derived from our domain name. This prevents the same few top-scored items from monopolizing the homepage every day while still ensuring that high-confidence products appear more frequently than low-confidence ones. The shuffle is deterministic, meaning the same seed always produces the same order for a given dataset version. This creates fairness for sellers and discovery variety for buyers. If you refresh the Hot Picks section, you will notice different items surfacing, but the underlying quality floor remains constant. This hybrid approach balances editorial control with user discovery, a methodology we have refined since early 2025.

SKU arrays are where most casual buyers get lost, yet they contain the most actionable purchase intelligence. Each SKU group has an attr_title, such as "Color" or "Size," and an attr_values array containing specific variants. When attr_values include img fields with has_img=true, you are looking at photo-verified variants, which are significantly more reliable than text-only descriptions. Cross-reference the SKU image with the main product carousel. If the SKU thumbnail shows a different stitching pattern or sole color than the hero images, that mismatch warrants investigation. For size attributes, pay attention to whether the seller uses CN, EU, or US sizing conventions, as conversion errors are the single largest source of post-purchase dissatisfaction. Our modal interface renders SKU selectors dynamically, showing image swatches where available and text buttons otherwise, precisely to help you avoid these errors without spreadsheet literacy.

Think of this directory as the user-friendly front end to the raw spreadsheet backend. When you browse a category here, you are looking at a filtered, shuffled, and visually formatted subset of spreadsheet data. The product cards show converted USD prices, brand tags, and view counts that the raw spreadsheet does not surface. When you click into a product modal, you see full image carousels, QC photos, SKU selectors, and multi-agent purchase links, all generated from the same underlying data row. For power users who want to verify our editorial decisions or find items we have not surfaced, the raw spreadsheet remains the source of truth. We recommend starting your search here for discovery and convenience, then cross-referencing specific listings in the spreadsheet if you are making a high-value purchase or buying from a seller you have not used before.