The Art of Finding the Perfect Shade

Navigating the expansive world of CNFans spreadsheets can sometimes feel like searching for a needle in a digital haystack. With thousands of rows featuring everything from heavy winter coats to miniature keychains, finding a specific pair of high-quality designer sunglasses requires a strategy. Simply scrolling is not an option if you value your time.

This tutorial focuses specifically on the "Accessories" and "Eyewear" niche. Whether you are looking for classic aviators, bold acetate frames, or rimless luxury styles, mastering the spreadsheet filters is the key to securing the best batches without overpaying. Follow this guide to turn a chaotic list of links into a curated catalog of premium eyewear.

Step 1: Accessing and Preparing the Spreadsheet

Before you can filter, you need the right environment. Most community-curated CNFans spreadsheets are hosted on Google Sheets.

• Open the Spreadsheet: Click the link to the reputable spreadsheet you are using (often found in Discord communities or Reddit).
• Create a Temporary Filter View: If you have edit access (rare) or if the sheet allows temporary views, go to Data > Filter views > Create new temporary filter view. This ensures your sorting doesn't mess up the view for other users.
• Freeze the Header: If the top row disappears when you scroll, go to View > Freeze > 1 row. This keeps the column titles (Name, Price, QC Link, W2C) visible at all times.

Step 2: Filtering by Category

The first cut is the deepest—and the most necessary. You need to eliminate all clothing and footwear to focus on accessories.

1. Locate the column labeled "Category" or "Type".
2. Click the funnel icon (filter icon) in the header cell.
3. Click "Clear" to uncheck all boxes.
4. Type "Glasses," "Sunglasses," "Eyewear," or "Accessories" into the search bar within the filter menu.
5. Select the relevant terms and click OK.

Pro Tip: Some spreadsheets are less organized. If there is no Category column, use the "Item Name" column filter and use the "Text contains" condition to search for "sunglasses" or "shades."

Step 3: Refining by Price Verification

When it comes to eyewear, price often correlates with the quality of materials used (e.g., cheap plastic vs. high-grade acetate and real metal hinges). You want to filter out the bottom-of-the-barrel budget items that might lack UV protection.

• Locate the "Price (CNY)" column.
• Click the filter icon and choose "Filter by condition".
• Select "Is between".
• Enter a range. For premium quality reps, a sweet spot is usually between 150 and 350 CNY. Anything lower often sacrifices hinge quality; anything higher might be overpriced unless it includes full packaging and prescription lenses.

Step 4: Searching for Specific Materials and Styles

Now that you have a list of eyewear within a reasonable price range, you want to find specific styles. This is where text filters shine.

Use the filter on the "Name" column again. This time, use these keywords depending on what you are looking for:

• For Durability: Filter for "Acetate." Acetate frames are heavier, more durable, and feel more luxurious than standard plastic.
• For Function: Filter for "Polarized" or "UV400." This is crucial. Never buy sunglasses purely for fashion without ensuring they offer eye protection.
• For Aesthetics: Search for terms like "Rimless," "Metal," "Oversized," or specific brand codes if you know them.

Step 5: The QC Check (Crucial Step)

The spreadsheet tells you the price and name, but the QC (Quality Control) photos tell the truth. This is the most important step for eyewear.

Once your list is filtered down to 10-20 options:

1. Click the link in the "QC Photos" column for your top choices.
2. Check the Hinges: Zoom in on the hinges. Are they sturdy metal? Do they look aligned? Cheap sunglasses fail at the hinge first.
3. Check the Logo: Look at the temple arms. Is the branding engraved or just printed on? Engraving usually indicates a higher-tier batch.
4. Check the Accessories: Does the QC photo show a leather case, cleaning cloth, and box? While you don't wear the box, it’s a good indicator of the seller's attention to detail.

Step 6: Checking Manufacturer Stock

Spreadsheets are updated frequently, but stock runs out fast for popular summer items. Before getting your hopes up:

• Click the "W2C" (Where to Cop) or "Product Link."
• This will take you to the CNFans agent page.
• Ensure the colorway you want is actually selectable and not grayed out.

Conclusion

By using these targeted filtering techniques, you save hours of scrolling and significantly increase your chances of landing premium eyewear. Remember, with sunglasses, the details matter. Use the spreadsheet to find the right price bracket, but use your eyes on the QC photos to confirm the quality. Happy hunting!