by Ollie Jones
5 (6 reviews)
Fast Woo Order Lookup
Searches for orders faster on WooCommerce stores with many orders.
Tested up to WP 6.8 (Current: 6.9)
v1.2.2
Current Version v1.2.2
Updated 2 months ago
Last Update on 12 Nov, 2025
Synced 6 hours ago
Last Synced on
Rank
#11,807
-150 this week
Active Installs
200+
-30.1%
KW Avg Position
179
—
No change
Downloads
6.9K
+5 today
Support Resolved
0%
—
No change
Rating
100%
Review 5 out of 5
5
(6 reviews)
Next Milestone 300
200+
300+
323
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 17 more installs to reach 300+
Rank Changes
Current
#11,807
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
6 reviews
Overall
100%
5
6
(100%)
4
0
(0%)
3
0
(0%)
2
0
(0%)
1
0
(0%)
Tracked Keywords
Showing 1 of 1| Keyword | Position | Change | Type | Updated |
|---|---|---|---|---|
| orders | 179 | — | Tag | 10 hours ago |
Unlock Keyword Analytics
Track keyword rankings, search positions, and discover new ranking opportunities with a Pro subscription.
- Full keyword position tracking
- Historical ranking data
- Competitor keyword analysis
Support Threads Overview
Resolved
Unresolved
1
Total Threads
0
Resolved
1
Unresolved
0%
Resolution Rate
Track This Plugin
Get detailed analytics, keyword tracking, and position alerts delivered to your inbox.
Start Tracking FreePlugin Details
- Version
- 1.2.2
- Last Updated
- Nov 12, 2025
- Requires WP
- 5.8+
- Tested Up To
- 6.8
- PHP Version
- 5.6 or higher
- Author
- Ollie Jones
Support & Rating
- Rating
- ★ ★ ★ ★ ★ 5
- Reviews
- 6
- Support Threads
- 1
- Resolved
- 0%
Keywords
Upgrade to Pro
Unlock keyword rankings, search positions, and detailed analytics with a Pro subscription.
Upgrade NowSimilar Plugins
WP Adminify – White Label WordPress, Admin Menu Editor, Login Customizer
7K+ installs
#2,736
Master Addons For Elementor - White Label, Free Widgets, Hover Effects, Conditions, & Animations
40K+ installs
#929
Google Analytics for WooCommerce
200K+ installs
#275
FiboSearch - Ajax Search for WooCommerce
100K+ installs
#285
YITH WooCommerce Compare
100K+ installs
#312
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.