For advanced search, you have to go through the following results.

• Go to Inventory > Products.
• Select the Search icon from the toolbar.
• Click the link Go to Advanced Search.
• Enter the search conditions. You can increase or decrease number of conditions by using the controls of Fewer and More.
• Select the option whether you want to match all the categories or any one of them.
• Click Search Now. It will show you all the relevant results as per search criteria.