How to Filter Records using Advanced Search

WooCommerce Smart Manager Advanced Search functionality lets you get to specific results by allowing you to put multiple conditions while searching.

You can also use the Advanced Search with multiple AND, multiple OR, multiple AND + OR conditions and search operators (<,>,=,<=, >=, is, contains, etc.)
Example – Search for SKU – WC01 and price >= $100.

Watch this video on how to perform simple and advanced search

Steps to perform Advanced Search

1. Go to Smart Manager Dashboard and select any post type or taxonomy from the drop-down.
2. Click on the Advanced Search toggle which will open a slide over panel to enter search conditions
3. Here, you will see the ‘WHEN’ option and rule group. You can add multiple conditions within a rule group using the ‘Add a condition’ option. And also create multiple rule groups using the ‘Add another group’ option located at the bottom right in each rule group.
4. Between multiple rule groups, at least one condition must be satisfied. However, within a single rule group, all conditions must be satisfied.
5. Click on Search and all your desired results will be displayed.
6. To reset / clear your search, click on the ‘Clear’ button

Important note – First, all conditions within a rule group will be checked. And then, conditions between two or more main rule groups will be checked.

Advanced search example

You want to search based on the following conditions –

• Sale price between $500 to $800 and SKU contains Dell OR
• Sale price above $500 and SKU contains Mac

As shown in the image above :

1. Go to Smart Manager Dashboard and select Products from the drop-down
2. Click on the Advanced Search toggle which will open a slide over panel to enter search conditions
3. Enter Sale price, choose > operator and enter 500
4. Click on ‘Add a condition’ and Enter Sale price, choose < operator and enter 800
5. Again, click on ‘Add a condition’ and Enter SKU contains Dell
6. Now click Add another group to enter rules for other search conditions
7. Enter Sale price, choose > operator and enter 900
8. Click on ‘Add a condition’ and Enter SKU contains Mac
9. Click on Search

That’s it.

Note: Advanced Search with multiple AND and multiple OR is available in Smart Manager Pro version only.