Home > OopBuy Tutorial: Using Spreadsheet Filters for Efficient Category Searches

OopBuy Tutorial: Using Spreadsheet Filters for Efficient Category Searches

2026-01-26
Product 1

football jersey

$10.68
Product 1

Short T Set

$16.22
Product 1

T-shirt

$12.97
Product 1

Jordan T-shirt

$11.89
Product 1

T*S socks 3PCS (2 random colors or note colors）

$2.69
Product 1

NIKE T-shirt

$11.89
Product 1

football jersey

$10.68
Product 1

football jersey

$10.68
Product 1

ARM@Nl 3PCS

$17.3
Product 1

football jersey

$10.68
Product 1

NIKE T-shirt

$11.89
Product 1

nike t-shirt

$12.7
Product 1

NIKE T-shirt

$11.89
Product 1

GUCl mens 3pcs

$17.3
Product 1

Puma football jersey

$10.68
Product 1

adidas T-shirt

$12.97
Product 1

C*K mens Buy 1 Get 1 Free

$10.14
Product 1

adidas T-shirt

$11.89
Product 1

NIKE football jersey

$10.68
Product 1

adidas football jersey

$10.68

In the world of online sourcing, time is your most valuable asset. Manually scanning through vast product lists is inefficient. Sorting by category saves timeOopBuy Spreadsheet

Step 1: Accessing Your OopBuy Spreadsheet

Open your OopBuy supplier or product spreadsheet. Ensure you are using the latest version provided by your agent or sourcing service to access all available filter columns.

Step 2: Understanding Key Columns for Filtering

Before applying filters, identify these crucial columns in your spreadsheet header row:

  • CategoryType: The primary column for sorting items (e.g., "T-Shirts," "Sneakers," "Bags").
  • QC Pass Rate %QC Score: A numerical or percentage column indicating the historical quality approval rate for that item or seller.
  • Subcategory

Step 3: Applying the Category Filter

  1. Click the filter icon (usually a funnel symbol) in the header cell of the Category
  2. A dropdown list will appear showing all unique categories (e.g., Fashion, Sneakers, Electronics, Accessories).
  3. To search for specific items:
    • Select Single Category:
    • Select Multiple Categories:
  4. Click "OK." Your spreadsheet will now display only items from the selected category(ies).

Step 4: Refining by High QC Approval Rate

With your category filter active, it's time to prioritize quality.

  1. Locate the QC Pass Rate %
  2. Click its filter icon and choose "Sort Largest to Smallest" or "Sort Z to A" if it's a percentage. This brings items with the highest QC scores to the top.
  3. For more precise filtering, select "Filter by Condition" or "Number Filters."
  4. Choose "Greater than" and enter a threshold value (e.g., 90

Your view is now refined to show, for instance, only "Sneakers" with a QC approval rate above 90%.

Step 5: Combining Filters for a Targeted Search

Let's say you want to find fashion accessories with excellent quality. Here’s the combined workflow:

  • Apply the Category
  • Then, sort or filter the QC Pass Rate %
  • You can add a third filter, like sorting the Price

Benefits and Pro Tips

Time Efficiency:

Better Sourcing Decisions:

Pro Tip:

By mastering the OopBuy Spreadsheet category and QC filters, you streamline your sourcing pipeline, ensuring you spend less time searching and more time selecting the best products for your customers.

pingubuyfinds.com Legal Disclaimer: Our platform functions exclusively as an information resource, with no direct involvement in sales or commercial activities. We operate independently and have no official affiliation with any other websites or brands mentioned. Our sole purpose is to assist users in discovering products listed on other Spreadsheet platforms. For copyright matters or business collaboration, please reach out to us. Important Notice: pingubuyfinds.com operates independently and maintains no partnerships or associations with Weidian.com, Taobao.com, 1688.com, tmall.com, or any other e-commerce platforms. We do not assume responsibility for content hosted on external websites.

© 2005-2024 pingubuyfinds.com