Sorting by category saves significant time. This step-by-step tutorial shows you how to use OopBuy Spreadsheet filters to quickly locate fashion items, sneakers, or accessories with high Quality Control (QC) approval rates.
Why Filter by Category?
The OopBuy spreadsheet contains vast amounts of product data. Manually scrolling through it is inefficient. Using the built-in filter functionality
Step-by-Step Guide: Filtering for Fashion, Sneakers & Accessories
Step 1: Access and Prepare the Spreadsheet
Open the shared OopBuy spreadsheet. Ensure you are viewing the main product list sheet (often named "Master List", "Products", or "QC Data").
Step 2: Enable Filters
Click on the header row (usually row 1). Go to Data Create a filter
Step 3: Apply the Category Filter
Click the drop-down arrow To select specific categories:
- Uncheck "Select all" to clear current selections.
- Check the boxes next to "Fashion", "Sneakers", and/or "Accessories".
- Click "OK". The spreadsheet will now only display rows
Step 4: Refine by High QC Approval Rate (The Key Step)
With your category filter active, now filter for quality:
- Find the column titled "QC Pass Rate", "QC Approval", or similar.
- Click its filter arrow and choose "Filter by condition".
- Select "Greater than or equal to""Number is greater than".
- Enter a value threshold (e.g., 850.85
- Click "OK".
Your view is now powerfully refined: only items from your chosen categories and
Step 5: Sort and Analyze Results
For even better organization, sort
Step 6: Save Your Filter View (Optional but Recommended)
To avoid reapplying these filters every time:
- Go to Data Filter views Create new filter view.
- Name it (e.g., "Fashion_Sneakers_High_QC").
- Your current filter settings will be saved. You can access this named view from the same menu anytime.
Pro Tips
- Combine Filters:
- Use Search within Filter:
- Clear Filters:Data Remove filter
- Always check the "QC Notes"
- Use Search within Filter: