Fast Woo Order Lookup vs Search & Replace Everything by WPCode – Find and Replace Media, Text, Links, and More

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 LIKE '%OllieJones%' using the leading wildcard %. 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. If you have problems 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. Credits 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 PhpStorm. 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. How can I learn more about making my WordPress site more efficient? We offer several plugins to help with your site’s database efficiency. You can read about them here.

Powerful Search & Replace for WordPress Search & Replace Everything by WPCode enables you to efficiently manage your website’s content directly from the WordPress admin. This tool is essential for site migrations, content updates, or any situation where batch find and replace text and image replacements are needed. With an intuitive interface, you can perform detailed find and replace operations across your entire database. Select specific tables, toggle case sensitivity, and preview changes before committing. Serialized data is fully supported. Designed to handle large websites, this plugin operates smoothly without the need for external tools. Features Include Text Replacement – Find and replace text across multiple database tables with support for serialized data and options for case-sensitive search. Replace Image – Directly replace images from the media library, automatically regenerating thumbnails to ensure visual consistency. Replace Media – Manage and replace media files of various formats across your entire site. Preview Changes – Always see a “dry-run” preview of the changes to ensure accuracy before applying them. Large Sites Supported – Optimized for performance, capable of handling large databases efficiently. Table Selection – Choose specific tables to search and replace text, ensuring that only the necessary data is affected. Introducing Search & Replace Everything Pro While Search & Replace Everything offers many powerful features for free, we have also created a Pro version that includes advanced features to further improve your workflows like the ability to undo Search & Replace operations and replacing images directly from the Gutenberg editor. Click here to purchase Search & Replace Everything Pro now! Use Cases Site Migrations – Quickly update URLs or any site data when moving your site. Content Updates – Easily replace outdated information or bulk update content across posts, pages, and custom post types. Image Management – Replace outdated images and avoid duplicate uploads. Media Updates – Replace media files in any format across your site. Tips for Using Search & Replace Backup Your Database – While the plugin is safe to use, it’s always a good idea to make a backup before making changes. Common mistakes to avoid when replacing text: Partial Matches – Ensure that you’re not replacing partial matches that could affect unintended content. For example, replacing “cat” could affect “category” or “concatenate”. Case Sensitivity – Be mindful of case sensitivity when replacing text. If you’re looking to replace “Cat” with “Dog”, ensure that you’re not affecting “cat” or “CAT”. URL Replacements – Always use the same format for both the search and replace values. For example if your search term has a trailing slash, ensure that the replacement term also has a trailing slash. E.g., “example.com/” to “example.net/” instead of “example.com/” to “example.net”. Getting Started After installing Search & Replace Everything by WPCode, look for the new menu item under WP Admin > Tools > WP Search & Replace. From there, you can start managing your content and perform find and replace operations for text or images across your entire website.