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

smart manager woocommerce wordpress advanced search
  1. Go to Smart Manager Dashboard and select any post type 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. Select ‘all’ or ‘at least one” from the dropdown for the ‘WHEN’ rule to validate a search condition. As the name suggests, ‘all’ means all conditions should satisfy. For ‘at least’, a minimum of one condition should satisfy. Use it to validate search conditions between multiple rule groups.
  5. The same applies to individual rule groups under “This group is a “pass” when”. Choose ‘all’ or ‘at least one” from the dropdown. Once done, click on Search and all your desired results will be displayed.
  6. So, for each rule group and between multiple rule groups, you can select whether all conditions should satisfy or at least one condition should satisfy.
  7. 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 as set under ‘WHEN’.

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 :

  • Go to Smart Manager Dashboard and select Products from the drop-down
  • Click on the Advanced Search toggle which will open a slide over panel to enter search conditions
  • Under When, select ‘at least one’ from the dropdown
  • Under This group is a pass, select ‘all’ from the dropdown
  • Enter Sale price, choose > operator and enter 500
  • Click on ‘Add a condition’ and Enter Sale price, choose < operator and enter 800
  • Again, click on ‘Add a condition’ and Enter SKU contains Dell
  • Now click Add another group to enter rules for other search conditions
  • Under This group is a pass, select ‘all’ from the dropdown
  • Enter Sale price, choose > operator and enter 900
  • Click on ‘Add a condition’ and Enter SKU contains Mac
  • Click on Search

That’s it.

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