Sorting by category saves significant time. This practical tutorial shows you how to leverage OopBuy Spreadsheet filters to quickly locate fashion items, sneakers, or accessories with high Quality Control (QC) approval rates.
Why Filtering by Category is Essential
Navigating large supplier spreadsheets can be overwhelming. Using the built-in filter function allows you to:
- Focus Your Search:Sneakers, Jackets, or Bags.
- Identify Quality Sellers:QC Approval Rate
- Compare Options Efficiently:
Step-by-Step Filtering Tutorial
Step 1: Access and Prepare the Spreadsheet
Open your OopBuy supplier spreadsheet (e.g., in Google Sheets or Microsoft Excel). Ensure the data has headers in the first row, such as Category, Product Name, QC Rate %, and Price.
Step 2: Activate the Filter Controls
Select the entire header row. Click on DataCreate a FilterFilter
Step 3: Filter by Your Desired Category
Click the dropdown arrow in the "Category"Unselect "Select all" and then choose your target category, for example:
- Fashion
- Sneakers
- Accessories
Click OK. The spreadsheet will now display only rows from that category.
Step 4: Refine by High QC Approval Rate
With the category filter applied, locate the "QC Rate %"Click its filter dropdown. You can now:
- Choose Sort Largest to Smallest
- Use a Conditional filter
Your view is now refined to items in your chosen category that have a high likelihood of passing quality checks.
Step 5: Analyze and Select Your Products
Browse the filtered results. You can add secondary sorts (like by price) for further comparison. Clear individual filters by clicking the dropdown and choosing "Clear filter" or remove all filters via the Data
Pro Tips for Power Users
- Combine Multiple Filters:Price RangeSupplier
- Save Views:
- Watch for Updates:
- Save Views: