JoyaGoo Spreadsheet 2026: Complete Navigation and Filter Guide
Learn how to master the JoyaGoo spreadsheet layout, hidden filters, category shortcuts, and advanced search techniques for faster finds.
Introduction
The JoyaGoo spreadsheet has evolved significantly from its 2025 predecessor. What started as a simple shared document has become a dynamic, filterable catalog with over 11,000 active listings across eleven core categories. In 2026, the spreadsheet supports real-time stock indicators, batch-level tagging, agent-specific deep links, and mobile-responsive browsing. Yet most users still navigate it like a static list, scrolling endlessly without leveraging the built-in power tools. This guide teaches you how to navigate the 2026 JoyaGoo spreadsheet like a power user, from basic category filtering to advanced SKU matching and batch identification.
Understanding the 2026 Spreadsheet Architecture
The current spreadsheet is divided into three logical layers. The category layer contains the eleven fixed groups: Shoes, Hoodies/Sweaters, T-Shirts, Jackets, Pants/Shorts, Headwear, Sets, Underwear/Underpants, Jersey, Accessories, and Others. Within each category, products are sorted first by an internal quality score and second by community popularity. The product layer contains individual rows with columns for SKU, price in RMB, agent links, batch identifier, and QC status. The metadata layer sits behind the scenes, tracking click-through rates, restock dates, and seller reliability scores. In 2026, the mobile interface was redesigned to collapse this three-layer structure into a single-scrollable feed with smart category tabs, making phone browsing significantly faster than the 2025 desktop-only experience.
Basic Filtering Every Shopper Should Use
Start with the category dropdown at the top of the sheet. Do not scroll through the entire catalog. Select your target category, then apply a price ceiling using the RMB filter. In 2026, the average sweet spot for high-quality sneakers is 280-450 RMB, hoodies fall between 180-320 RMB, and accessories typically range from 60-150 RMB. After price filtering, use the batch tag column to narrow results. Look for tags like "LJR", "PK", "OG", or "XP" for sneakers; "TopStoney" or "Busystone" for outerwear; and "Hansolo" or "CloyAd" for general apparel. These batch codes correspond to specific factories, and the 2026 spreadsheet now includes a hover tooltip explaining each batch's reputation tier. Finally, sort by the QC available column to see only products with verified in-hand photos.
Advanced Techniques: SKU Matching and Image Search
For experienced users, the 2026 spreadsheet supports reverse SKU lookup. If you find a Weidian item elsewhere, copy its item ID and paste it into the search box prefixed with "WD-". The spreadsheet will return the matching row if it exists in the catalog, including any affiliated batch tags and historical price data. Another powerful tool introduced in early 2026 is the image search integration with AstroReps. Click the camera icon next to the search bar, upload any product photo, and the system returns visually similar items ranked by similarity score. This is particularly useful when you see a piece on Instagram or TikTok and want to find the spreadsheet equivalent without knowing the brand or product name. The image search currently indexes over 40,000 product photos with 94 percent top-5 accuracy.
Mobile Shortcuts and Bookmarking
The 2026 mobile interface includes three shortcuts that save hours. First, the star icon next to any product adds it to your personal saved list, which syncs across devices via browser local storage. Second, the share button generates a direct deep link that opens the exact product row in the spreadsheet, bypassing category navigation entirely. Third, the compare mode lets you select up to four products and view their specs side-by-side in a modal overlay, including price delta, batch comparison, and QC photo count. Power users recommend bookmarking filtered URLs directly — for example, bookmarking "Shoes + LJR + under 400 RMB" creates a one-click entry point to your preferred hunting ground.
