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.

WP-EXPERTS.IN

<p>“WooCommerce Sales Count Manager” is the best add-on plugin for WooCommrce that has provide important feature to display sold item number on your store. This plugin provide feature to display the total sold item number for each product on shop page, product category page and product details page . And also provide an option to add the social share buttons i.e Facebook, LinkedIn, Twitter, Pinterest & WhatsApp.</p>
<p>“WooCommerce Sales Count Manager” does work with <a href="https://wordpress.org/plugins/woocommerce/" rel="ugc">WooCommerce Plugin</a>. It’s mainly created to show number of sold item on every product.</p>
<h4>NOTE: Tested with 6.6.1 version of WooCommerce plugin</h4>
<p><span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/5QOkw8QUl1c?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span></p>
<h4>Features</h4>
<ul>
<li>Display total sold item number for each product</li>
<li>Define the custom sold item number (Pro version)</li>
<li>Manage sold counter button Style</li>
<li>Social Share Buttons (Facebook,Pinterest,Linkedin,Twitter,WhatsApp) for each product page</li>
</ul>
<h4>Pro Addon Features</h4>
<ul>
<li>Display item sold counter on shop page</li>
<li>Disable item sold counter on category pages</li>
<li>Display item sold counter on Category/Tag pages</li>
<li>Disable item sold counter on specific Category page</li>
<li>Display item sold counter on product details page</li>
<li>Define custom sold items number for every product</li>
<li>Shortcode to display sold item number on basis of product id</li>
<li>Manage counter button style</li>
<li>Delete old orders on weekly/monthly/yearly basis.</li>
<li>An option to Add conversion tracking code for checkout thank you page</li>
<li>An option to define your custom message to display with sold item number</li>
<li>An option to define your custom message for all 0 sold item products</li>
<li>An option to change text & sold item number position</li>
<li>Preorder custom message feature available</li>
</ul>
<h3>FLAT 15% DISCOUNT ON <a href="https://www.wp-experts.in/products/woocommerce-sales-count-manager-addon/?utm_source=wordpress.org&utm_medium=free-plugin&utm_campaign=wscm-20offer-sale" rel="nofollow ugc">ADD-ON</a>. No Coupon Code Required. Hurry! Limited Time Offer!</h3>
<p>Do You Have Any Query? <strong><a href="https://www.wp-experts.in/contact-us/?utm_source=wordpress.org&utm_medium=free-plugin&utm_campaign=wc-sales" rel="nofollow ugc">Submit here</a></strong></p>
<h4>Our Other WooCommerce Plugins</h4>
<ul>
<li><a href="https://www.wp-experts.in/woocommerce-wishlist-and-compare/?utm_source=wordpress.org&utm_medium=free-plugin&utm_campaign=wcwc" rel="nofollow ugc">WooCommerce Wishlist and Compare Plugin</a> <a href="https://www.wp-experts.in/woocommerce-wishlist-and-compare/?utm_source=wordpress.org&utm_medium=free-plugin&utm_campaign=wcwc" rel="nofollow ugc">Download Plugin</a></li>
</ul>


Sales Count Manager for WooCommerce

Display sold item count for each product in WooCommerce, customize the counter, and add social share buttons for better engagement.

Fast Woo Order Lookup vs Sales Count Manager for WooCommerce