by
OllieJones
5 (8 reviews)
Fast Woo Order Lookup
Searches for orders faster on WooCommerce stores with many orders.
Fast Woo Order Lookup ranks #11,733 among WordPress.org plugins with 200+ active installations, is #1,879 of 12,356 in the E-commerce category, a 5/5 rating from 8 reviews, and was last updated Mar 4, 2026. Data from WordPress.org, refreshed twice daily — see methodology.
Tested up to WP 7.0.5 (Current: 7.1)
v1.3.0
Current Version v1.3.0
Updated 6 months ago
Last Update on 04 Mar, 2026
Refreshed 9 hours ago
Last Refreshed on
#1,879 of 12,356 in E-commerce
Top 25% by installs
Downloads -5.3% this week
Rank
#11,733
-32 this week
Active Installs
200+
-31.7%
KW Avg Position
156.5
0.5 better
Downloads
9.1K
+6 today
Support Resolved
0%
—
No change
Rating
100%
Review 5 out of 5
5
(8 reviews)
Next Milestone 300
200+
300+
683
Ranks to Climb
-
Growth Needed
8,000,000
Active Installs
Pro
Unlock Exact Install Count
See the precise estimated active installs for this plugin, calculated from real-time ranking data.
- Exact install estimates within tiers
- Track install growth over time
- Milestone progress predictions
Need 32 more installs to reach 300+
Rank Changes
Current
#11,733
Change
Best
#
Downloads Growth
Downloads
Growth
Peak
Upgrade to Pro
Unlock 30-day, 90-day, and yearly download history charts with a Pro subscription.
Upgrade NowReviews & Ratings
5.0
8 reviews
Overall
100%
5
8
(100%)
4
0
(0%)
3
0
(0%)
2
0
(0%)
1
0
(0%)
Support Threads Overview
Resolved
Unresolved
1
Total Threads
0
Resolved
1
Unresolved
0%
Resolution Rate
Security History
Source: WPVulnerabilityNo known vulnerabilities on record for Fast Woo Order Lookup. Checked 1 month ago.
Track This Plugin
Get detailed analytics, keyword tracking, and position alerts delivered to your inbox.
Start Tracking FreePlugin Details
- Version
- 1.3.0
- Last Updated
- Mar 04, 2026
- Requires WP
- 5.8+
- Tested Up To
- 7.0.5
- PHP Version
- 5.6 or higher
- Author
- OllieJones
Support & Rating
- Rating
- ★ ★ ★ ★ ★ 5
- Reviews
- 8
- Support Threads
- 1
- Resolved
- 0%
Keywords
Upgrade to Pro
Unlock keyword rankings, search positions, and detailed analytics with a Pro subscription.
Upgrade NowSimilar Plugins
Adminify – White Label, Admin Menu Editor, Login Customizer
6K+ installs
#2,754
Master Addons for Elementor – Elementor Addons, Widgets, Mega Menu Builder, Popup Builder, Widget Builder & Template Kits
30K+ installs
#1,007
WooCommerce
7M+ installs
#6
MonsterInsights – Google Analytics Dashboard for WordPress (Website Stats Made Easy)
2M+ installs
#25
ManageWP Worker
1M+ installs
#54
Google for WooCommerce
800K+ installs
#75
WooPayments: Integrated WooCommerce Payments
800K+ installs
#76
WooCommerce PayPal Payments
800K+ installs
#81
WooCommerce Stripe Payment Gateway
700K+ installs
#85
WooCommerce Tax (formerly WooCommerce Shipping & Tax)
500K+ installs
#115
TL;DR
AI summary of the plugin's readmeThis plugin is for WooCommerce store owners whose Orders or Subscriptions pages have grown slow to search. It replaces WooCommerce's default leading-wildcard substring search with a trigram index table, and also speeds up the slow meta_key lookup query on the orders page.
- Trigram index table for search
- Faster order and subscription search
- Background index creation via ActionScheduler
- Speeds up meta_key lookup query
- Caches available meta_key values
- French translation available
Frequently Asked Questions
Common questions about Fast Woo Order Lookup
See this WooCommerce issue for an example of the performance problem store owners have. See this Subscriptions issue for another example.
Build a trigram lookup table, maintain it, and use it for the queries.
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. The rows of the table are each quite small, just three letters and an order ID. And there are many of those rows for each order. The table, named with an abbreviation for "Fast Woo Order Lookup", contains the trigram lookups. It has a terse name to keep queries short. It is dropped automatically if you deactivate the plugin.
No, unless your database tablespace is too small for it. This answer uses the Big O conceptual way of understanding program performance. The table is organized by its primary key so this plugin can search for orders with O(log n) computational complexity. That means if searching 100 orders takes two seconds, then searching 1000 takes about three seconds and 10,000 about four. So it will work at large scale. And without this plugin the complexity of the order search in WooCommerce is a quite unpleasant O(n). Ten times as many orders take ten times as long to search. So, 100 times as many take 100 times as long. Used at large scale that gets nasty. It burns server electricity. Just as importantly, it wastes users' time. That's true even if you use a nice search plugin like Relevanssi to help your customers search for products. The author does that. It works. But not on orders. This plugin improves order search performance by using a better algorithm. It's the InnoDB team we have to thank for this in MariaDB and MySQL. Legendary. (See, Dr. Knuth? Somebody read your book!) If your hosting service is such a cheapskate you don't have the tablespace for the table, that might be a reason to avoid this plugin.
Generating the table seems to take about ten seconds (in the background) for every thousand orders.
Yes. It also works with the performance enhancements in WooCommerce 9.9.0 and beyond. Alas, it is still required to get good performance with order search.
Yes.
Let the author know by creating an issue at https://github.com/OllieJones/fast-woo-order-lookup/issues Deactivate, then activate the plugin. This rebuilds the lookup table.
This plugin addresses database performance problems that only show themselves on stores with many thousands of orders. If your store is smaller than that you probably don't need it. Wise owners of rapidly growing stores return regularly to examine their site performance. If your site is still small, it's better to wait until you actually need performance-enhancing plugins and other features. Installing them "just in case" is ineffective.
