gnaka08

The plugin gives search boxes on the blog additional functionalities for operators among search words, such as Google’s. The other supported operators than the standard ‘and’ search are OR, -(exclude), *(any string) and parenthesis.
The plugin contains <a href="https://github.com/yonaka/SearchWordsSQL" rel="nofollow ugc">SearchWordsSQL</a> and <a href="http://genericons.com" rel="nofollow ugc">Genericons</a> libraries. These are subject to the respective licenses. If you want to redistribute this plugin with Genericons, you may have to comply with GPLv2 (not lesser).
<h3>Search Operators</h3>
<ul>
<li>Specify words separated by space(s) to search posts containing all the words.</li>
<li>Quote a string containing space(s) by double quotes to search posts which contain phrase(s) consisted of those words only in the order.</li>
<li>Insert an asterisk (*) in a word without any space to search posts which contain the word(s) regardless of what the part of the asterisk is.</li>
<li>Prepend a minus sign (-) without any space to a word to search posts which do not contain the word(s).</li>
<li>Specify two words separated by ” OR ” in upper case to search posts which contain either of words or both. This takes precedence over words separated by space(s) only.</li>
<li>You can combine the above expression. Use a pair of parenthesis to group expressions if needed.</li>
</ul>
It searches in the bodies and titles of posts in a case-insensitive manner.

Compound Searcher

Lets search boxes on your blog support search operators like Google's.

mattsgarage

The search functionality in woocommerce doesn’t search by sku by default.
This simple plugin adds this functionality search facility of your site, in both the public site and admin panel
Just install and activate – no config required.
Tested with Woocommerce 1.5.6, 2.0.7, 2.0.18, 2.2.4, 2.2.10, 3.4.4, 4.0.1 and 4.2.0
See the <a href="http://www.mattyl.co.uk/2012/12/11/woocommerce-plugin-to-search-products-by-sku/" title="accompanying blog post" rel="nofollow ugc">Accompanying blog post</a> for more information.

Search by SKU for Woocommerce

Extend the search functionality of woocommerce to include searching of sku

Compound Searcher vs Search by SKU for Woocommerce