OllieJones

<p>WooCommerce’s Order and Subscription pages allow store owners to search for orders and subscriptions by customer name, email, and other attributes. By default, it does a general substring search. For example, if you put OllieJones into the search box, it will search with <code>LIKE '%OllieJones%'</code> using the leading wildcard <code>%</code>. That’s astonishingly slow on sites with many orders.</p>
<p>Upon activation this plugin uses ActionScheduler to run a background process to create a special-purpose index table, a table of trigrams, to speed up that search. Then it uses those trigrams to search for orders.</p>
<p>The downside: the trigram table takes database space and takes time to generate.</p>
<p>The orders page itself contains a slow query to look up meta_keys. This fixes that query’s performance too, using a cache of available values.</p>
<h4>If you have problems</h4>
<p>The WordPress and WooCommerce ecosystems offer many optional features enabled by plugins. And, WooCommerce sites run on many different versions of database server. It is not possible to test this plugin on every imaginable combination. So, you may have problems getting it to work.</p>
<p>Sometimes the process of creating the index table does not complete correctly. And, sometimes you cannot find some orders after the index is created.</p>
<p>If you tell the author about these problems, he will attempt to fix them. Please create a support topic, then visit Site Health, view the Info tab, click the Copy Site Info to Clipboard button, and paste that information into the support topic. And, of course, please describe what is going wrong.</p>
<h4>Credits</h4>
<p>Thanks to Leho Kraav for bringing this problem to my attention.</p>
<p>Thanks to Sebastian Sommer and Maxime Michaud for using early versions of the plugin on large stores, and to Maxime Michaud for creating the transation into French.</p>
<p>Thanks to Jetbrains for the use of their software development tools, especially <a href="https://www.jetbrains.com/phpstorm/" rel="nofollow ugc">PhpStorm</a>. It’s hard to imagine how a plugin like this one could be developed without PhpStorm’s tools for exploring epic code bases like WordPress’s.</p>
<h4>How can I learn more about making my WordPress site more efficient?</h4>
<p>We offer several plugins to help with your site’s database efficiency. You can <a href="https://www.plumislandmedia.net/wordpress/performance/optimizing-wordpress-database-servers/" rel="nofollow ugc">read about them here</a>.</p>


Fast Woo Order Lookup


this is, by far, the "must have" plugin for big shops, pair this with HPOS and you search in 300k+ orders in less than 1 second! (with 100 order listing!).very great work, this should be merged in core!


holy grail of shop managers

Searches for orders faster on WooCommerce stores with many orders.

Alex Wigmore

<p>This plugin prevents a specific set of WooCommerce fake/spam orders.<br />
Simply install and activate the plugin; there are no settings or tweaks to be made unless you want to add your own filters.<br />
The plugin extends WooCommerce’s built-in checkout validations to check for a specific set of known spam email accounts and names. If triggered, the spam bot simply cannot checkout and importantly does not get to the account creation stage.<br />
The names/emails it checks for would only be used by spam bots, so there is no need to worry about false positives.</p>
<p>If you’ve found this plugin useful, you can support my work by buying me a coffee at:<br />
<a href="https://buymeacoffee.com/alexwigmore" rel="nofollow ugc">Buy Me a Coffee</a>.</p>
<h3>How to Use Custom Filters</h3>
<p>Starting from plugin version 0.77, you can extend the list of blocked email domains and blocked customer names using custom filters.</p>
<h3>Available Filters:</h3>
<ol>
<li><strong>BSSO_extra_domains:</strong> Add custom email domains to block during the checkout process.</li>
<li><strong>BSSO_extra_names:</strong> Add custom first names to block during the checkout process.</li>
</ol>
<h3>Example Usage</h3>
<p>To use these filters, add code to your theme’s <code>functions.php</code> file or a custom plugin.</p>
<h4>1. Blocking Additional Email Domains</h4>
<p>If you want to block additional email domains like <code>exampledomain.com</code> and <code>spamdomain.net</code>, use the <code>BSSO_extra_domains</code> filter.</p>
<p><strong>Code Example:</strong></p>
<pre><code>add_filter('BSSO_extra_domains', function () {
    return ['exampledomain.com', 'spamdomain.net'];
});
</code></pre>
<h4>2. Blocking Additional First Names</h4>
<p>If you want to block additional first names like <code>spambot</code> and <code>faker</code>, use the <code>BSSO_extra_names</code> filter.</p>
<p><strong>Code Example:</strong></p>
<pre><code>add_filter('BSSO_extra_names', function () {
    return ['spambot', 'faker'];
});
</code></pre>
<h3>Complete Example</h3>
<p>Here’s how you might use both filters together:</p>
<p><strong>Code Example:</strong></p>
<pre><code>add_filter('BSSO_extra_domains', function () {
    return ['exampledomain.com', 'spamdomain.net'];
});

add_filter('BSSO_extra_names', function () {
    return ['spambot', 'faker'];
});
</code></pre>
<h3>Version Compatibility</h3>
<p>Please note that these filters are only available starting from version 0.77 of the plugin. Ensure your plugin is updated to at least this version to use the custom filters.</p>


Block Specific Spam Woo Orders

Just be targeted by this robot. Thanks a lot for your plugin.

Thanks


I love this plugin and the ability to add additional problem bot names and domains has solved my issues. IMO any WooCommerce site needs this.


simple wonderful plugin, great support, and extensible

A simple plugin to automatically block spam Woo orders that began in October 2020.

Fast Woo Order Lookup vs Block Specific Spam Woo Orders