{"id":4361,"date":"2025-02-16T18:52:03","date_gmt":"2025-02-16T18:52:03","guid":{"rendered":"https:\/\/s-o-s.net\/fast-woo-order-lookup\/"},"modified":"2025-02-16T18:52:03","modified_gmt":"2025-02-16T18:52:03","slug":"fast-woo-order-lookup","status":"publish","type":"post","link":"https:\/\/s-o-s.net\/en_gb\/fast-woo-order-lookup\/","title":{"rendered":"Fast Woo Order Lookup"},"content":{"rendered":"<p> <br \/>\n<\/p>\n<article id=\"post-192875\" class=\"alignwide post-192875 plugin type-plugin status-publish hentry plugin_tags-database plugin_tags-orders plugin_tags-performance plugin_tags-search plugin_tags-woocommerce plugin_category-ecommerce plugin_category-security-and-spam-protection plugin_category-utilities-and-tools plugin_contributors-olliejones plugin_business_model-community plugin_committers-olliejones\">\n<div class=\"plugin-banner\" id=\"plugin-banner-fast-woo-order-lookup\"><\/div>\n<header class=\"plugin-header\">\n<div class=\"entry-heading-container\">\n<div>\n<div class=\"entry-thumbnail\">\n\t\t\t\t\t<img decoding=\"async\" class=\"plugin-icon\" src=\"https:\/\/ps.w.org\/fast-woo-order-lookup\/assets\/icon-128x128.jpg?rev=3093322\" alt=\"\">\t\t\t\t<\/div>\n<div>\n<h1 class=\"plugin-title\">Fast Woo Order Lookup<\/h1>\n<p>\t\t\t\t\t<span class=\"byline\">By <span class=\"author vcard\"><a target=\"_blank\" class=\"url fn n\" href=\"https:\/\/profiles.wordpress.org\/olliejones\/\" rel=\"noopener\">OllieJones<\/a><\/span><\/span>\n\t\t\t\t<\/div>\n<\/p><\/div>\n<div class=\"plugin-actions\">\n<div class=\"wp-block-button is-small plugin-download download-button\"><a target=\"_blank\" class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/downloads.wordpress.org\/plugin\/fast-woo-order-lookup.1.1.3.zip\" rel=\"noopener\">Download<\/a><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/header>\n<p><!-- .entry-header --><\/p>\n<p>\t<span id=\"description\"><\/span><br \/>\n\t<span id=\"reviews\"><\/span><br \/>\n\t<span id=\"installation\"><\/span><br \/>\n\t<span id=\"developers\"><\/span><br \/>\n\t<span id=\"advanced\" class=\"\"><\/span><br \/>\n\t<span id=\"section-links\"><\/p>\n<ul class=\"tabs clear\">\n<li id=\"tablink-description\"><a target=\"_blank\" href=\"https:\/\/wordpress.org\/plugins\/fast-woo-order-lookup\/#description\" rel=\"noopener\">Details<\/a><\/li>\n<li id=\"tablink-reviews\"><a target=\"_blank\" href=\"https:\/\/wordpress.org\/plugins\/fast-woo-order-lookup\/#reviews\" rel=\"noopener\">Reviews<\/a><\/li>\n<li id=\"tablink-installation\">\n\t\t\t\t<a target=\"_blank\" href=\"https:\/\/wordpress.org\/plugins\/fast-woo-order-lookup\/#installation\" rel=\"noopener\">Installation<\/a>\n\t\t\t<\/li>\n<li id=\"tablink-developers\"><a target=\"_blank\" href=\"https:\/\/wordpress.org\/plugins\/fast-woo-order-lookup\/#developers\" rel=\"noopener\">Development<\/a><\/li>\n<\/ul>\n<div id=\"link-support\">\n\t\t\t<a target=\"_blank\" href=\"https:\/\/wordpress.org\/support\/plugin\/fast-woo-order-lookup\/\" rel=\"noopener\">Support<\/a>\n\t\t<\/div>\n<p>\t<\/span><br \/>\n\t<script type=\"text\/javascript\">if ( '#changelog' == window.location.hash ) { window.setTimeout( function() { window.location.hash=\"#developers\"; }, 10 ); }<\/script><\/p>\n<div class=\"entry-content\">\n<div id=\"tab-description\" class=\"plugin-description section\">\n<h2 id=\"description-header\">Description<\/h2>\n<p>WooCommerce\u2019s 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\u2019s astonishingly slow on sites with many orders.<\/p>\n<p>Upon activation this plugin runs 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>\n<p>The downside: the trigram table takes database space and takes time to generate.<\/p>\n<p>The orders page itself contains a very slow query (to be fixed in Woocommerce 9.0.0) to look up meta_keys. This fixes that query\u2019s performance too.<\/p>\n<h4>Credits<\/h4>\n<p>Thanks to Leho Kraav for bringing this problem to my attention.<\/p>\n<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>\n<p>Thanks to Jetbrains for the use of their software development tools, especially <a target=\"_blank\" href=\"https:\/\/www.jetbrains.com\/phpstorm\/\" rel=\"nofollow ugc noopener\">PhpStorm<\/a>. It\u2019s hard to imagine how a plugin like this one could be developed without PhpStorm\u2019s tools for exploring epic code bases like WordPress\u2019s.<\/p>\n<h4>How can I learn more about making my WordPress site more efficient?<\/h4>\n<p>We offer several plugins to help with your site\u2019s database efficiency. You can <a target=\"_blank\" href=\"https:\/\/www.plumislandmedia.net\/wordpress\/performance\/optimizing-wordpress-database-servers\/\" rel=\"nofollow ugc noopener\">read about them here<\/a>.<\/p>\n<\/div>\n<div id=\"tab-installation\" class=\"plugin-installation section\">\n<h2 id=\"installation-header\">Installation<\/h2>\n<p>Follow the usual procedure for installing a plugin from the wordpress.org plugin repository.<\/p>\n<\/div>\n<div id=\"faq\" class=\"plugin-faq section\">\n<h2 id=\"faq-header\">FAQ<\/h2>\n<dl>\n<dt id=\"what%27s%20the%20background%20for%20this%3F\">\n<h3>What\u2019s the background for this?<\/h3>\n<\/dt>\n<dd>\n<p>See this <a target=\"_blank\" href=\"https:\/\/github.com\/woocommerce\/woocommerce\/issues\/32826\" rel=\"nofollow ugc noopener\">WooCommerce issue<\/a> for an example of the performance problem store owners have. See this <a target=\"_blank\" href=\"https:\/\/github.com\/Automattic\/woocommerce-subscriptions-core\/issues\/183\" rel=\"nofollow ugc noopener\">Subscriptions issue<\/a> for another example.<\/p>\n<\/dd>\n<dt id=\"what%27s%20the%20fix%3F\">\n<h3>What\u2019s the fix?<\/h3>\n<\/dt>\n<dd>\n<p>Build a <a target=\"_blank\" href=\"https:\/\/www.plumislandmedia.net\/wordpress-plugins\/fast-woo-order-lookup\/#how-does-it-work-trigrams\" rel=\"nofollow ugc noopener\">trigram lookup table<\/a>, maintain it, and use it for the queries.<\/p>\n<\/dd>\n<dt id=\"how%20much%20space%20does%20the%20trigram%20lookup%20table%20take%3F\">\n<h3>How much space does the trigram lookup table take?<\/h3>\n<\/dt>\n<dd>\n<p>It takes about 5-10KiB per order, as MariaDB \/ MySQL database storage, counting both data and indexes. So, if your site has a million orders, the table will take something like 5-10 GiB.<\/p>\n<\/dd>\n<dt id=\"how%20long%20does%20it%20take%20to%20generate%20trigram%20lookup%20table%3F\">\n<h3>How long does it take to generate trigram lookup table?<\/h3>\n<\/dt>\n<dd>\n<p>When you activate the plugin, it starts generating the table in the background. Everything continues as normal while the plugin is generating the table.<\/p>\n<p>Generating the table seems to take about ten seconds (in the background) for every thousand orders.<\/p>\n<\/dd>\n<dt id=\"does%20it%20work%20with%20high%20performance%20order%20storage%20%28hpos%29%3F\">\n<h3>Does it work with High Performance Order Storage (HPOS)?<\/h3>\n<\/dt>\n<dd>\n<p><strong>Yes<\/strong>.<\/p>\n<\/dd>\n<dt id=\"does%20it%20work%20with%20pre-hpos%20order%20storage%3F\">\n<h3>Does it work with pre-HPOS order storage?<\/h3>\n<\/dt>\n<dd>\n<p><strong>Yes<\/strong>.<\/p>\n<\/dd>\n<dt id=\"the%20lookup%20table%20seems%20to%20be%20out%20of%20date.%20i%20can%27t%20find%20recent%20orders.%20what%20do%20i%20do%3F\">\n<h3>The lookup table seems to be out of date. I can\u2019t find recent orders. What do I do?<\/h3>\n<\/dt>\n<dd>\n<ol>\n<li>Let the author know by creating an issue at https:\/\/github.com\/OllieJones\/fast-woo-order-lookup\/issues<\/li>\n<li>Deactivate, then activate the plugin. This rebuilds the lookup table.<\/li>\n<\/ol>\n<\/dd>\n<dt id=\"what%20is%20this%20wp_fwol%20table%20created%20by%20the%20plugin%3F\">\n<h3>What is this wp_fwol table created by the plugin?<\/h3>\n<\/dt>\n<dd>\n<p>This table, named with an abbreviation for \u201cFast Woo Order Lookup\u201d, contains the trigram lookups. It has a terse name to keep queries short. It is dropped automatically if you deactivate the plugin.<\/p>\n<\/dd>\n<dt id=\"my%20store%20only%20has%20a%20few%20hundred%20orders.%20do%20i%20need%20this%20plugin%20%3F\">\n<h3>My store only has a few hundred orders. Do I need this plugin ?<\/h3>\n<\/dt>\n<dd>\n<p>This plugin addresses database performance problems that only show themselves on stores with many tens of thousands of orders. If your store is smaller than that you probably don\u2019t need it.<\/p>\n<p>Wise owners of rapidly growing stores return regularly to examine their site performance. If your site is still small, it\u2019s better to wait until you actually need performance-enhancing plugins and other features. Installing them \u201cjust in case\u201d is ineffective.<\/p>\n<\/dd>\n<\/dl>\n<\/div>\n<div id=\"tab-reviews\" class=\"plugin-reviews section\">\n<h2 id=\"reviews-header\">Reviews<\/h2>\n<div class=\"plugin-reviews\">\n<article class=\"plugin-review\">\n<div class=\"review-avatar\">\n\t\t\t\t\t\t<img decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/ee421d3fd85b44d745307f4aba5cdfac6c8b05237fbfe7d443b9827d164ba234?s=60&amp;d=retro&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/ee421d3fd85b44d745307f4aba5cdfac6c8b05237fbfe7d443b9827d164ba234?s=120&amp;d=retro&amp;r=g 2x\" class=\"avatar avatar-60 photo\" height=\"60\" width=\"60\">\t\t\t\t\t<\/div>\n<div class=\"review\">\n<header>\n<div class=\"header-top\">\n<div class=\"wporg-ratings\" aria-label=\"5 out of 5 stars\" data-title-template=\"%s out of 5 stars\" data-rating=\"5\" style=\"color:#ffb900;\"><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><\/div>\n<h3 class=\"review-title\"><a target=\"_blank\" class=\"url\" href=\"https:\/\/wordpress.org\/support\/topic\/holy-grail-of-shop-managers\/\" rel=\"noopener\">holy grail of shop managers<\/a><\/h3>\n<\/p><\/div>\n<div class=\"header-bottom\">\n\t\t\t\t\t\t\t\t<span class=\"review-author author vcard\"><a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/rwky\/\" title=\"Posts by Eduard Doloc\" rel=\"author noopener\">Eduard Doloc<\/a><\/span><br \/>\n\t\t\t\t\t\t\t\t<span class=\"review-date\">October 11, 2024<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/header>\n<div class=\"review-content\">this is, by far, the \u201cmust have\u201d 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!<\/div>\n<\/p><\/div>\n<\/article>\n<article class=\"plugin-review\">\n<div class=\"review-avatar\">\n\t\t\t\t\t\t<img decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/f731bd1ab0eb2acd6aee8eea248e8e0ff440053ff9de27f459e5b1bcaee7aa67?s=60&amp;d=retro&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/f731bd1ab0eb2acd6aee8eea248e8e0ff440053ff9de27f459e5b1bcaee7aa67?s=120&amp;d=retro&amp;r=g 2x\" class=\"avatar avatar-60 photo\" height=\"60\" width=\"60\">\t\t\t\t\t<\/div>\n<div class=\"review\">\n<header>\n<div class=\"header-top\">\n<div class=\"wporg-ratings\" aria-label=\"5 out of 5 stars\" data-title-template=\"%s out of 5 stars\" data-rating=\"5\" style=\"color:#ffb900;\"><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><\/div>\n<h3 class=\"review-title\"><a target=\"_blank\" class=\"url\" href=\"https:\/\/wordpress.org\/support\/topic\/amazing-plugin-2652\/\" rel=\"noopener\">Amazing Plugin<\/a><\/h3>\n<\/p><\/div>\n<div class=\"header-bottom\">\n\t\t\t\t\t\t\t\t<span class=\"review-author author vcard\"><a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/notblowingsmoke\/\" title=\"Posts by E-Liquids UK\" rel=\"author noopener\">E-Liquids UK<\/a><\/span><br \/>\n\t\t\t\t\t\t\t\t<span class=\"review-date\">October 2, 2024<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/header>\n<div class=\"review-content\">We have been using this plugin since its initial release, their updates are brilliant never a hitch and being a fast based ecommerce company we need all the speed we can get. With over 120,000 orders in active view this plugin makes looking up orders super quick for our support team.<\/div>\n<\/p><\/div>\n<\/article>\n<article class=\"plugin-review\">\n<div class=\"review-avatar\">\n\t\t\t\t\t\t<img decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/d637b6970261e454e5043b1ba4c72168b522ad1cc2fba83dbce8fdf275870789?s=60&amp;d=retro&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/d637b6970261e454e5043b1ba4c72168b522ad1cc2fba83dbce8fdf275870789?s=120&amp;d=retro&amp;r=g 2x\" class=\"avatar avatar-60 photo\" height=\"60\" width=\"60\">\t\t\t\t\t<\/div>\n<div class=\"review\">\n<header>\n<div class=\"header-top\">\n<div class=\"wporg-ratings\" aria-label=\"5 out of 5 stars\" data-title-template=\"%s out of 5 stars\" data-rating=\"5\" style=\"color:#ffb900;\"><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><\/div>\n<h3 class=\"review-title\"><a target=\"_blank\" class=\"url\" href=\"https:\/\/wordpress.org\/support\/topic\/boosting-woocommerce-search-speed-with-fast-woo-order-lookup\/\" rel=\"noopener\">Boosting WooCommerce Search Speed with Fast Woo Order Lookup<\/a><\/h3>\n<\/p><\/div>\n<div class=\"header-bottom\">\n\t\t\t\t\t\t\t\t<span class=\"review-author author vcard\"><a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/maximemichaud\/\" title=\"Posts by Maxime Michaud\" rel=\"author noopener\">Maxime Michaud<\/a><\/span><br \/>\n\t\t\t\t\t\t\t\t<span class=\"review-date\">September 14, 2024<\/span><br \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"review-replies\">1 reply<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/header>\n<div class=\"review-content\">We\u2019ve been using Index WP MySQL For Speed for some time, and the creator also recommended the Fast Woo Order Lookup plugin. This plugin seems to function correctly, and the method used to accelerate searches is ingenious. The order search feature was a frequent offender in our MySQL slow query log, but it seems to be much less of an issue now. According to both customer service testimonials and personal experience, searches are significantly faster. Previously, a search could take up to ten seconds now, it often takes about three seconds. There are times when it may take slightly longer, but generally, it\u2019s much quicker.<\/p>\n<p>One downside of this plugin\u2014which I personally don\u2019t consider a negative\u2014is that the trigram table uses about 6.4GB of space. It\u2019s also worth mentioning that we have over 630,000 orders on the site in question.<\/p>\n<p>We therefore recommend this plugin if you\u2019re looking to reduce search times for anyone needing to look up orders on your site. It will enhance their productivity and also reduce processing time to deliver the desired results.<\/p>\n<p>We haven\u2019t encountered any problems with this plugin, but I should mention that it should be implemented by someone with some technical knowledge to measure the impact it will have. This can depend on whether your site has plugins that modify certain aspects. Also, if your site is inherently slow, this plugin won\u2019t perform miracles to solve underlying issues.<\/p><\/div>\n<\/p><\/div>\n<\/article>\n<article class=\"plugin-review\">\n<div class=\"review-avatar\">\n\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/de8a8e13810915f96f5cc2617b51682bb43cbb146ccdd19e9843a8719d379e74?s=60&amp;d=retro&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/de8a8e13810915f96f5cc2617b51682bb43cbb146ccdd19e9843a8719d379e74?s=120&amp;d=retro&amp;r=g 2x\" class=\"avatar avatar-60 photo\" height=\"60\" width=\"60\">\t\t\t\t\t<\/div>\n<div class=\"review\">\n<header>\n<div class=\"header-top\">\n<div class=\"wporg-ratings\" aria-label=\"5 out of 5 stars\" data-title-template=\"%s out of 5 stars\" data-rating=\"5\" style=\"color:#ffb900;\"><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><\/div>\n<h3 class=\"review-title\"><a target=\"_blank\" class=\"url broken_link\" href=\"https:\/\/wordpress.org\/support\/topic\/sped-up-my-slow-admin-pages-2\/\" rel=\"noopener\">Sped Up My Slow Admin Pages<\/a><\/h3>\n<\/p><\/div>\n<div class=\"header-bottom\">\n\t\t\t\t\t\t\t\t<span class=\"review-author author vcard\"><a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/slservice33\/\" title=\"Posts by slservice33\" rel=\"author noopener\">slservice33<\/a><\/span><br \/>\n\t\t\t\t\t\t\t\t<span class=\"review-date\">September 3, 2024<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/header>\n<div class=\"review-content\">I\u2019ve had very slow wp-admin and woocommerce admin pages for a while now. Query monitor plugin showed a very high number of database queries from the woocommerce plugin. No idea why.<\/p>\n<p>Installing this plugin and Index WP mySQL For Speed plugin has immediately reduced the very high number of queries and sped up both wp-admin and woocommerce admin pages.<\/p>\n<p>Thank you very much and I hope my admin stays working this quick !<\/p><\/div>\n<\/p><\/div>\n<\/article>\n<article class=\"plugin-review\">\n<div class=\"review-avatar\">\n\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/a2b74f06901e1e5bc55af50cd48fca6f9c0bf2109c967a83a28b6b81a16af93b?s=60&amp;d=retro&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/a2b74f06901e1e5bc55af50cd48fca6f9c0bf2109c967a83a28b6b81a16af93b?s=120&amp;d=retro&amp;r=g 2x\" class=\"avatar avatar-60 photo\" height=\"60\" width=\"60\">\t\t\t\t\t<\/div>\n<div class=\"review\">\n<header>\n<div class=\"header-top\">\n<div class=\"wporg-ratings\" aria-label=\"5 out of 5 stars\" data-title-template=\"%s out of 5 stars\" data-rating=\"5\" style=\"color:#ffb900;\"><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><\/div>\n<h3 class=\"review-title\"><a target=\"_blank\" class=\"url\" href=\"https:\/\/wordpress.org\/support\/topic\/this-plugin-is-a-game-changer-for-woocommerce\/\" rel=\"noopener\">This plugin is a game changer for WooCommerce!<\/a><\/h3>\n<\/p><\/div>\n<div class=\"header-bottom\">\n\t\t\t\t\t\t\t\t<span class=\"review-author author vcard\"><a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/blockagency\/\" title=\"Posts by blockagency\" rel=\"author noopener\">blockagency<\/a><\/span><br \/>\n\t\t\t\t\t\t\t\t<span class=\"review-date\">July 19, 2024<\/span><br \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"review-replies\">1 reply<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/header>\n<div class=\"review-content\">I have been using Oliver\u2019s plugins for years and they are amazing.<\/p>\n<p>This one is no exception.<\/p>\n<p>It improved the time to search for orders on a site with over 130,000 orders from 120 seconds to just 3 seconds!<\/p>\n<p>Just one question: does this plugin keep generating the indexes over and over again? Because I get this message constantly on the site:<\/p>\n<p>\u201cFast Woo Order Lookup indexing still in progress. 100% complete. See the Scheduled Actions status page for details.\u201d<\/p>\n<p>And when this happens, the site backend and order lookup slows down again.<\/p><\/div>\n<\/p><\/div>\n<\/article><\/div>\n<p>\t\t<a target=\"_blank\" class=\"reviews-link\" href=\"https:\/\/wordpress.org\/support\/plugin\/fast-woo-order-lookup\/reviews\/\" rel=\"noopener\"><br \/>\n\t\t\tRead all 5 reviews\t\t<\/a><\/div>\n<div id=\"tab-developers\" class=\"plugin-developers section\">\n<h2 id=\"developers-header\">Contributors &amp; Developers<\/h2>\n<div class=\"plugin-contributors\">\n<p>\u201cFast Woo Order Lookup\u201d is open source software. The following people have contributed to this plugin.<\/p>\n<p><span class=\"screen-reader-text\">Contributors<\/span><\/p>\n<ul id=\"contributors-list\" class=\"contributors-list\">\n<li>\n\t\t\t\t<img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/6ac7c2e9bb1e43d09d87b780c06c09b391a52680c3b1512bcd094176376a1a26?s=32&amp;d=mm&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/6ac7c2e9bb1e43d09d87b780c06c09b391a52680c3b1512bcd094176376a1a26?s=64&amp;d=mm&amp;r=g 2x\" class=\"avatar avatar-32 photo\" height=\"32\" width=\"32\">\t\t\t\t<a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/olliejones\/\" rel=\"noopener\"><br \/>\n\t\t\t\t\tOllieJones\t\t\t\t<\/a>\n\t\t\t<\/li>\n<\/ul><\/div>\n<div class=\"plugin-development\">\n<p>\u201cFast Woo Order Lookup\u201d has been translated into 3 locales. Thank you to <a target=\"_blank\" href=\"https:\/\/translate.wordpress.org\/projects\/wp-plugins\/fast-woo-order-lookup\/contributors\" rel=\"noopener\">the translators<\/a> for their contributions.<\/p>\n<p><a target=\"_blank\" href=\"https:\/\/translate.wordpress.org\/projects\/wp-plugins\/fast-woo-order-lookup\" rel=\"noopener\">Translate \u201cFast Woo Order Lookup\u201d into your language.<\/a><\/p>\n<h3>Interested in development?<\/h3>\n<p><a target=\"_blank\" href=\"https:\/\/plugins.trac.wordpress.org\/browser\/fast-woo-order-lookup\/\" rel=\"noopener\" class=\"broken_link\">Browse the code<\/a>, check out the <a target=\"_blank\" href=\"https:\/\/plugins.svn.wordpress.org\/fast-woo-order-lookup\/\" rel=\"noopener\">SVN repository<\/a>, or subscribe to the <a target=\"_blank\" href=\"https:\/\/plugins.trac.wordpress.org\/log\/fast-woo-order-lookup\/\" rel=\"noopener\" class=\"broken_link\">development log<\/a> by <a target=\"_blank\" href=\"https:\/\/plugins.trac.wordpress.org\/log\/fast-woo-order-lookup\/?limit=100&amp;mode=stop_on_copy&amp;format=rss\" rel=\"noopener\" class=\"broken_link\">RSS<\/a>.<\/p>\n<\/div>\n<\/div>\n<div id=\"tab-changelog\" class=\"plugin-changelog section\">\n<h2 id=\"changelog-header\">Changelog<\/h2>\n<h4>1.1.3 October 7, 2024<\/h4>\n<p>Handle tables and colums with character sets other than $wpdb-&gt;charset.<\/p>\n<h4>1.1.1 August 12, 2024<\/h4>\n<ul>\n<li>Limit batch runtime to 25 seconds. Include a cronjob shell script to purge stale ActionScheduler actions.<\/li>\n<\/ul>\n<h4>1.1.0 August 11, 2024<\/h4>\n<ul>\n<li>Some MariaDB \/ MySQL versions implicitly cast integers to latin1 strings causing problems. Explicit casting fixes the issue.<\/li>\n<\/ul>\n<\/div><\/div>\n<p><!-- .entry-content --><\/p>\n<p>\t<!-- .entry-meta --><br \/>\n<\/article>\n<p><br \/>\n<br \/><a href=\"https:\/\/wordpress.org\/plugins\/fast-woo-order-lookup\/\" target=\"_blank\" rel=\"noopener\">Source link <\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>Fast Woo Order Lookup By OllieJones Download Details Reviews Installation Development Support Description WooCommerce\u2019s 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 [&hellip;]<\/p>","protected":false},"author":75,"featured_media":4362,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"give_campaign_id":0,"footnotes":""},"categories":[1933,39,40],"tags":[2842,2844,2587,2843],"class_list":["post-4361","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-community-plugin","category-lite-version","category-wp-plugin-solution","tag-fast","tag-lookup","tag-order","tag-woo"],"acf":[],"fifu_image_url":"https:\/\/ps.w.org\/fast-woo-order-lookup\/assets\/banner-772x250.jpg?rev=3093322","_links":{"self":[{"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/posts\/4361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/comments?post=4361"}],"version-history":[{"count":0,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/posts\/4361\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/media\/4362"}],"wp:attachment":[{"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/media?parent=4361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/categories?post=4361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/tags?post=4361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}