This plugin is for store administrators who need to locate customer orders quickly within their WooCommerce admin panel. It addresses the slow, often timeout-prone native search by implementing a more efficient database lookup method, making order management faster and more reliable for busy shops.

Trigram-based search indexing: Creates a separate database table that breaks down order text (like names, addresses, product titles) into three-character chunks. This structure allows the database to find matching orders using fast index lookups instead of slow, full-table scans.

Automatic table maintenance: The trigram table is built automatically when you activate the plugin and is updated in the background whenever orders are created, modified, or deleted. This ensures search performance remains consistent as your store grows.

Custom field cache: Improves the loading speed of the order editing page by caching the list of custom field names. This prevents a performance-intensive database query from running repeatedly, especially on sites with a large number of orders.

Query interception: The plugin hooks into the database layer to modify slow search queries. It adds a fast pre-filter using the trigram table, drastically reducing the number of orders the system must examine with slower methods.

Free and open-source: Released under the GPL license, this tool is free to use, modify, and distribute. It is designed to be a practical solution for performance issues without adding licensing costs.