by indextwo
5 (5 reviews)
Order Search Repair for WooCommerce
Order Search Repair for WooCommerce scans all of the orders in your WooCommerce store and updates them to make your orders fully searchable again.
Tested up to WP 4.8.27 (Current: 6.9)
v0.1.2
Current Version v0.1.2
Updated 7 years ago
Last Update on 12 Dec, 2018
Synced 6 hours ago
Last Synced on
Rank
#19,660
—
No change
Active Installs
60+
-6.3%
KW Avg Position
63
—
No change
Downloads
3K
+2 today
Support Resolved
0%
—
No change
Rating
100%
Review 5 out of 5
5
(5 reviews)
Next Milestone 70
60+
70+
543
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 6 more installs to reach 70+
Rank Changes
Current
#19,660
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
5 reviews
Overall
100%
5
5
(100%)
4
0
(0%)
3
0
(0%)
2
0
(0%)
1
0
(0%)
Tracked Keywords
Showing 1 of 1| Keyword | Position | Change | Type | Updated |
|---|---|---|---|---|
| repair | 63 | — | Tag | 18 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
Track This Plugin
Get detailed analytics, keyword tracking, and position alerts delivered to your inbox.
Start Tracking FreePlugin Details
- Version
- 0.1.2
- Last Updated
- Dec 12, 2018
- Requires WP
- 4.7+
- Tested Up To
- 4.8.27
- PHP Version
- N/A
- Author
- indextwo
Support & Rating
- Rating
- ★ ★ ★ ★ ★ 5
- Reviews
- 5
- Support Threads
- 0
- 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,738
Master Addons For Elementor – White Label, Free Widgets, Hover Effects, Conditions, & Animations
40K+ installs
#930
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 Order Search Repair for WooCommerce
Order Search Repair runs its operations in manageable chunks which it will process automatically, one after the other. rather than trying to process all orders in one go. The recommended maximum limit is 500 orders per chunk.
That entirely depends on the number of orders in your store. Order Search Repair has been tested with on stores ranging from 400 orders (which took about 10 seconds); to over 50,000 orders (which took about 25 minutes). On average, each batch request (varying from 100 to 500 orders per chunk) can take between 15 and 30 seconds.
You can absolutely leave it running and go make yourself a coffee, as long as you don't exit the page. Doing so will effectively cancel the update process, and you won't know how many orders have been processed.
Depending on the specification of your server and installation, you may find the process takes a lot longer than anticipated. In that event, there is a 60-second timeout when waiting for the server to respond, after which it will show an alert. If this is happening to you, try lowering the limit for the number of requests.
As of version 0.1.2, you sure can. Click on the Get total number of unindexed orders button and it will retrieve the total number of orders that either have their search index missing, or the value is empty. Note that nothing will be done at this point - it's just to give you an idea of how many orders need updating.
Selecting Update all order indexes will instantly modify the meta for every processed order in that chunk, updating your site as it goes. Output as SQL does not make any changes to your site; it simply outputs the raw SQL queries so that you can run the update directly on the database yourself.
Order Search Repair was originally coded for a large-scale site with several thousand orders. Running the process on the live site would have meant potentially eating up resources and writing to the database while live transactions were going on. So, the option to simply output the SQL was added so that it didn't do anything except read from the database while it was running. Then, the database could be updated later, and it would only take a few seconds to parse even several thousand SQL queries.
Absolutely 100% definitely yes. There is virtually no risk of anything drastically bad going wrong, as even in the worst case, the tool will only affect the wp_postmeta table. However, as with any plugin that makes significant changes to your database, you should always back up as a precaution before doing anything.
When updating live orders (rather than exporting SQL queries), the plugin is updating the post's meta on the fly; as such, the query that searches for older orders in the first place doesn't pick up orders that have been updated. So, if you were to include an offset, it would actually skip over orders that need to be updated. Hence, no offset.