Woocommerce Order Search is too slow

Hi there!

Thanks for reaching out! Slow order searches in WooCommerce can have multiple causes. To better understand the issue, could you share:

• Approximately how many orders are in your store?
• Which payment gateways or order-related plugins you are using?
• If you notice slow performance only when searching for orders or in other areas of the admin dashboard as well?

In the meantime, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:

• System Status Report?which you can find via WooCommerce > Status
• Fatal error logs?(if any) under WooCommerce > Status > Logs.

Please use https://pastebin.com/ or https://gist.github.com/ and share a link to that paste in reply here. Once we have more information, we’ll be able to assist you further.

Hi There,

• Approximately how many orders are in your store? _ I have arond 57.000 orders with failed and canceld orders
• Which payment gateways or order-related plugins you are using? I am using pay-payments-for-woocommerce plugin a dutch payment
• If you notice slow performance only when searching for orders or in other areas of the admin dashboard as well? The most is back panel with orders … thew wesbite is also not very fast

I am using PAY plugin

• System Status Report which you can find via WooCommerce > Status

I mark the wesbite XXXX because i dont want it online know, i am happy to sent the website on PM ?

WooCommerce version:9.7.1WooCommerce Legacy REST API package: 1.0.5 /home/u81469p85973/domains/XXXXXXX.nl/public_html/wp-content/plugins/woocommerce-legacy-rest-api/includesAction Scheduler package: 3.9.0 /home/u81469p85973/domains/XXXXXXX.nl/public_html/wp-content/plugins/woocommerce/packages/action-schedulerLog directory writable: /home/u81469p85973/domains/XXXXXXX.nl/public_html/wp-content/uploads/wc-logs/WordPress version:6.7.2WordPress multisite:–WordPress memory limit:2 GBWordPress debug mode:–WordPress cron:Language:nl_NLExternal object cache:–

• Fatal error logs (if any) under WooCommerce > Status > Logs.

• This reply was modified 1 week, 1 day ago by turkijefm.

Hello turkijefm,

Thank you for your reply.

I understand your site has around 57,000 orders and uses the “pay-payments-for-woocommerce” plugin for payments.

May I ask when did you first notice this slow performance?

To investigate the issue further, I need to review your System Status Report. Please generate the report and paste it into Pastebin, then share the link here. We do not have a private channel for communication. If you prefer to redact details like the site URL and database tables, use the Copy for GitHub button.

Once I have more information, I will be in a better position to assist you further.

Best regards.

Hi There,

The issue is about 3 years now but it get slower

https://pastebin.com/FrknBqj6

I hope you can help me

greetings

Hi @turkijefm ,

Thanks for sharing the system status report! I noticed that HPOS is not enabled on your site.

Could you try enabling HPOS and see if it improves the search speed? You can follow this guide for more details: https://woocommerce.com/document/high-performance-order-storage/

Let us know how it goes!

Hi,

iam getting an error when i turn it on

There has been a critical error on this website. Please check your site admin email inbox for instructions. If you continue to have problems, please try the support forums.

Learn more about troubleshooting WordPress.

Hi there!

The following error indicates that there is a plugin or code on your site conflicting with the HPOS features.

Here is an article to guide you on how to find the plugin causing this issue:
How to Fix WordPress Critical Error.

Alternatively, I would suggest running a conflict test by deactivating all plugins except WooCommerce and checking if you still encounter the same error when activating that setting.

For more details on how to run a conflict test, you can refer to this article:
How to Test for Conflicts.

Let me know how that goes!

Hi,

i disabled all plugin and i added the feature, only the problem still exicst after caching all items

Also is this correct ? i see an error

https://ibb.co/21Hw4QfS

Please help me.

greetings

• This reply was modified 6 hours, 23 minutes ago by turkijefm.