Order List Search not working

Hi there!

High-Performance Order Storage (HPOS) introduces a custom table for storing order data, which can improve performance significantly, especially for sites with a large number of orders, like yours. However, you may need to rebuild or sync the data to ensure the new table system is fully in sync with your WooCommerce orders. For more details on how to sync all orders you can use this article https://woocommerce.com/document/high-performance-order-storage/#synchronization

Once you snyc your all orders,i would suggest you enable the HPOS Full text search indexes” feature:

1. Navigate to?WooCommerce?>?Settings?>?Advanced?>?Features.
2. Make sure?Order data storage is set to HPOS.
3. Under the?Experimental features?section, enable the?HPOS Full-text search indexes?option

Note: This feature only works when Order data storage is set to HPOS.

Let me know how that goes.

Hello,

the Full text search indexers for orders is selected. We do not have any plugins that are incompatible currently. I also can not switch back to legacy because, since the Woocommerce 9 upgrade the order list was only showing a limited number of orders.

Once we were able to switch to HPOS and we turned on the HPOS Full text search indexers. Everything seemed to be ok and working. We can see order listed if we page through the orders.

But when you search it will not find any of the older orders.

How can I rebuild the search index? as that is what seems to be the problem.

please advise.

Hello lucein,

Thank you for your reply.

I understand that you’re experiencing issues with order search not finding older orders despite enabling HPOS Full text search indexers.

Could you share a screenshot of the Order Data Storage settings?

To troubleshoot, I suggest enabling compatibility mode temporarily to allow orders to sync fully, then try searching for an order again to see if it resolves the issue.

Finally, check WooCommerce > Status > Scheduled Actions for any failed or pending actions.
Share a screenshot if you find any failed or pending actions.

Looking forward to your response. ??

Hello @doublezed2

I enabled compatibility mode as you suggested, but orders are still not searchable. Below shows the new settings. I allowed the orders to sync, I even waited a few hours and checked again. the orders are still not searchable in the Orders List.

Below is the screenshot that you requested for the Order Data Storage settings

There are 62 Failed Actions. 90% of which show:

1. action_scheduler/migration_hook. – action failed via WP Cron: Scheduled action for action_scheduler/migration_hook will not be executed as no callbacks are registered.

The rest are:

1. wp_mail_smtp_send_usage_data – action failed via WP Cron: Scheduled action for wp_mail_smtp_send_usage_data will not be executed as no callbacks are registered.
2. MailChimp_WooCommerce_Single_Order – action failed via WP Cron: Call to a member function setTimezone() on null
   These show as Failed back on October 2nd & 3rd, 2024. See below:

Pending – below is as screenshot of the the Pending tasks.

Please let me know if you need additional info

Hi @lucein

Thank you for providing the detailed breakdown and screenshot—it’s incredibly helpful for us as we look into this further.

I noticed several pending and canceled migration hooks. Have you tried running these actions manually to see if they complete successfully and resolve the issue? For better control over cron events on your WordPress site, I recommend using the WP Crontrol plugin, which can make managing these tasks easier.

Additionally, while WooCommerce doesn’t offer a direct option to rebuild the order search index from the admin interface, you can perform this task via the CLI. The following command should help synchronize the order search index:

wp wc cot sync

You can find more information about manual synchronization here.

Please give this a try and let us know if it helps!

Hello @jonayedhosen

I tired the CLI, but command did nothing. it shows 0 synced. the command is depreciated, so I tried the suggested command and got the same response. that there are 0 orders to be synced.

bitnami@ip-172-31-53-163:/opt/bitnami/wordpress$ sudo wp wc cot sync

Warning: Command wc cot sync is deprecated since 8.9.0. Please use wc hpos sync instead.
There are 0 orders to be synced.
Warning: There are no orders to sync, aborting.
bitnami@ip-172-31-53-163:/opt/bitnami/wordpress$ sudo wp wc hpos sync

Deprecated: Optional parameter $transaction_type declared before required parameter $args is implicitly treated as a required parameter in /opt/bitnami/wordpress/wp-content/plugins/woocommerce-avatax/src/logger/class-wc-avatax-logger.php on line 192
There are 0 orders to be synced.
Warning: There are no orders to sync, aborting.

let me know what else we can do. As finding orders is a pain in the butt because the search does not work at all.

please advise.

Hello lucein,

Thank you for your reply.

I appreciate your effort in trying the solution we suggested.
It appears that did not have any effect on the order search.

At this point, it would be best to perform a Conflict Test.
This test will confirm whether this problem is happening at the core WooCommerce or some other factor is causing this issue.

You may set up a Staging site to perform a conflict test.
This way you can keep the live site functioning while troubleshooting the issue.

Lastly, please send me a copy of your site’s System Status Report.
You can find it via WooCommerce > Status.
Select Get system report and then Copy for support.

Best regards.