OllieJones

WooCommerce’s 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’s astonishingly slow on sites with many orders.
Upon activation this plugin uses ActionScheduler to run 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.
The downside: the trigram table takes database space and takes time to generate.
The orders page itself contains a slow query to look up meta_keys. This fixes that query’s performance too, using a cache of available values.
<h4>If you have problems</h4>
The WordPress and WooCommerce ecosystems offer many optional features enabled by plugins. And, WooCommerce sites run on many different versions of database server. It is not possible to test this plugin on every imaginable combination. So, you may have problems getting it to work.
Sometimes the process of creating the index table does not complete correctly. And, sometimes you cannot find some orders after the index is created.
If you tell the author about these problems, he will attempt to fix them. Please create a support topic, then visit Site Health, view the Info tab, click the Copy Site Info to Clipboard button, and paste that information into the support topic. And, of course, please describe what is going wrong.
<h4>Credits</h4>
Thanks to Leho Kraav for bringing this problem to my attention.
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.
Thanks to Jetbrains for the use of their software development tools, especially <a href="https://www.jetbrains.com/phpstorm/" rel="nofollow ugc">PhpStorm</a>. It’s hard to imagine how a plugin like this one could be developed without PhpStorm’s tools for exploring epic code bases like WordPress’s.
<h4>How can I learn more about making my WordPress site more efficient?</h4>
We offer several plugins to help with your site’s database efficiency. You can <a href="https://www.plumislandmedia.net/wordpress/performance/optimizing-wordpress-database-servers/" rel="nofollow ugc">read about them here</a>.

Fast Woo Order Lookup


this is, by far, the "must have" 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!


holy grail of shop managers

Searches for orders faster on WooCommerce stores with many orders.

Smackcoders Inc.,

Prema Iruthayarajan

riswanasmack

<h4>Secure, Fast, and Flexible WordPress Data Export</h4>
Looking for a reliable way to back up, migrate, or store your WordPress content? WP Ultimate Exporter is the ultimate solution! This feature-rich export plugin enables you to extract posts, pages, WooCommerce products, orders, users, and more in easily accessible file formats.
Important Note: WP Ultimate Exporter is an add-on that requires the <a href="https://wordpress.org/plugins/wp-ultimate-csv-importer/" rel="ugc">WP Ultimate CSV Importer</a> to function. 
With this plugin, you can export all your WordPress content—including posts, pages, custom fields, users, and WooCommerce data—ensuring secure backups and effortless migrations.
Top Features & Benefits
<ul>
<li>User-Friendly Export Process – Export data in just a few clicks, no coding required.</li>
<li>Comprehensive Content Export – Export posts, pages, custom post types, custom fields, users, WooCommerce products, orders, reviews, and more.</li>
<li>Versatile Media Export – Export WordPress media separately or along with posts and pages.</li>
<li>Customizable Export Options – Choose specific data for export, including post types, authors, date range, and more.</li>
<li>Metadata & Custom Fields Support – Preserve all custom fields and metadata associated with your content.</li>
<li>Error-Free CSV & XML Files – The plugin automatically formats data to prevent errors.</li>
<li>Time-Based Data Export – Export posts, orders, or records from a specific time frame.</li>
<li>Post Status Filtering – Export data based on post status (Published, Draft, Pending, etc.).</li>
<li>Author-Specific Export – Extract content created by specific authors.</li>
<li>Quick Migration Zip Export – Export any post type as a bundled ZIP with default template info for easy migration using the One-Click Import option in the Importer.</li>
<li>Query-Based Export – Use post type query, user query, and comment query to export exactly the data you need.</li>
<li>Iteration-Based Export – Export large volumes of data in smaller batches to prevent timeouts and improve stability.</li>
</ul>
Unlock advanced filtering options and seamless Google Sheets export with <a href="https://www.smackcoders.com/wp-ultimate-exporter.html?utm_source=wordpress&utm_medium=readme&utm_campaign=free_exporter" rel="nofollow ugc">Ultimate Exporter Pro</a>.
<h4>Multilingual Data Export</h4>
Effortlessly export multilingual content from WordPress sites powered by WPML or Polylang. Ensure smooth migration of language-based data in CSV/XML formats while preserving translations accurately.
<h4>WordPress Users Export with WP Ultimate Exporter Add-On</h4>
Enhance your user data management by integrating the <a href="https://wordpress.org/plugins/import-users/" rel="ugc">Import User Add-On</a> to: 
– Generate Complete User Lists – Export usernames, emails, roles, and more. 
– Filter and Export Targeted User Data – Select user records based on specific criteria. 
– Capture User Metadata & Custom Fields – Export additional user profile details securely.
Note: Exported passwords are encrypted (MD format) and cannot be used for direct login.
<h4>WooCommerce Export: Enhance Your Store Management</h4>
Combine the <a href="https://wordpress.org/plugins/import-woocommerce/" rel="ugc">Import WooCommerce Add-On</a> to unlock additional WooCommerce export features: 
– Export Products & Variations – Extract complete product details for seamless migration. 
– Export Product Images & Categories – Maintain product organization and visuals during transfers. 
– Manage WooCommerce Orders – Export orders in CSV/XLS format for analysis and fulfillment. 
– Export WooCommerce Reviews & Coupons – Store and analyze customer feedback and promotional data.
<h4>Why Export Your WordPress Data?</h4>
Exporting your WordPress content offers multiple benefits:
<ul>
<li>Data Security & Backup – Prevent data loss from hosting issues, plugin conflicts, or accidental deletions.</li>
<li>Seamless Website Migration – Easily move your website between hosting providers or domains.</li>
<li>Streamlined Collaboration – Share specific content with team members effortlessly.</li>
<li>Safe Testing Environment – Test new themes or plugins using a backup version of your site.</li>
</ul>
<h4>Exporting Made Simple</h4>
The WP Ultimate Exporter plugin follows a streamlined two-step process: 
1. Select Content – Choose posts, pages, custom fields, users, WooCommerce products, or orders. 
2. Customize & Export – Apply filters like file format, author, post status, or date range, then download the file.
Protect your WordPress content today with WP Ultimate Exporter. Download it now from the WordPress Plugin Directory.
<h4>Migration Made Easy</h4>
The latest release introduces a feature that allows you to download a migration ZIP file, which can then be imported into the target site using the importer plugin. Here’s how to export the migration file:
<ol>
<li>Select Content Type – Go to the export page and choose a content or module type from the list.</li>
<li>Configure Migrate Option – On the next page, provide a name for the file, select the file type, and configure any advanced export settings like filters. Once done, click the Migrate button to generate a ZIP file with all the data and default mapping info. After export is complete, click the Bundle button to download the ZIP file, ready for migration.</li>
</ol>
For more details on this migration feature, refer to our documentation on <a href="https://www.smackcoders.com/documentation/wp-ultimate-csv-importer-pro/migrate-wordpress-and-woocommerce-data?utm_source=wordpress&utm_medium=readme&utm_campaign=free_exporter" rel="nofollow ugc">How to Migrate WordPress Site Data Using One-Click Import & Migrate Feature</a>.
<h4>Unlock WP Ultimate Exporter Pro</h4>
Upgrade to <a href="https://www.smackcoders.com/wp-ultimate-exporter.html?utm_source=wordpress&utm_medium=readme&utm_campaign=free_exporter" rel="nofollow ugc">Ultimate Exporter Pro</a> for premium features: 
– Scheduled & Automated Exports – Set up recurring exports with ease. 
– Advanced Filtering by Category, Status, Column Selection, Post IDs, Title, and Custom Fields 
– Google Sheets Integration – Export data directly to Google Sheets for real-time access. 
– Support for ACF, Toolset Types, JetEngine, and Meta Box Fields
<h4>Try WP Ultimate Exporter in Action</h4>
Explore the plugin features through our live demos:
<ul>
<li><a href="https://demo.smackcoders.com/ultimatecsvimporter/wp-admin/admin.php?page=com.smackcoders.csvimporternew.menu&utm_source=WpOrg&utm_medium=Readme&utm_campaign=free_exporter" rel="nofollow ugc">Ultimate Exporter Free Demo</a></li>
<li><a href="https://demo.smackcoders.com/wordpress/wp-admin?utm_source=WpOrg&utm_medium=Readme&utm_campaign=free_exporter" rel="nofollow ugc">Ultimate Exporter Pro Demo</a></li>
</ul>
<h4>Support & Resources</h4>
Need help? Visit our <a href="https://www.smackcoders.com/support.html?utm_source=wordpress&utm_medium=readme&utm_campaign=free_exporter" rel="nofollow ugc">Support Page</a> for assistance.
Learn more with our <a href="https://www.smackcoders.com/blog.html?utm_source=wordpress&utm_medium=readme&utm_campaign=free_exporter" rel="nofollow ugc">WordPress Export & Import Tutorials</a>.
If you find WP Ultimate Exporter helpful, please <a href="https://wordpress.org/support/view/plugin-reviews/wp-ultimate-exporter?rate=5#postform" rel="ugc">rate us</a>. Thank you for your support!

Export All Posts, Products, Orders, Refunds & Users

Export any WordPress website including WooCommerce data seamlessly with our powerful export plugin. Save records as CSV, XML, or Excel file for secure …

Fast Woo Order Lookup vs Export All Posts, Products, Orders, Refunds & Users