Plugin / Order Search Repair for WooCommerce

Lawrie Malen
Download from WordPress

Frequently Asked Questions (FAQ)

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.

Ratings

5
5 reviews

Rating breakdown

Details Information

Version

0.1.2

First Released

12 May, 2017

Total Downloads

1,179

Wordpress Version

4.7 or higher

Tested up to:

4.8.11

Require PHP Version:

-

Tags

database orders repair search woocommerce

Contributors

indextwo

Languages

The plugin hasn't been transalated in any language other than English.

DIRECTORY DISCLAIMER

The information provided in this THEME/PLUGIN DIRECTORY is made available for information purposes only, and intended to serve as a resource to enable visitors to select a relevant theme or plugin. wpSocket gives no warranty of any kind, express or implied with regard to the information, including without limitation any warranty that the particular theme or plugin that you select is qualified on your situation.

The information in the individual theme or plugin displayed in the Directory is provided by the owners and contributors themselves. wpSocket gives no warranty as to the accuracy of the information and will not be liable to you for any loss or damage suffered by you as a consequence of your reliance on the information.

Links to respective sites are offered to assist in accessing additional information. The links may be outdated or broken. Connect to outside sites at your own risk. The Theme/Plugin Directory does not endorse the content or accuracy of any listing or external website.

While information is made available, no guarantee is given that the details provided are correct, complete or up-to-date.

wpSocket is not related to the theme or plugin, and also not responsible and expressly disclaims all liability for, damages of any kind, arising out of the use, reference to, or reliance on, any information or business listed throughout our site.

Keep Leading Your Followers!
Share it for them.