Hi,
I understand that you're facing an issue with your WooCommerce store where orders are automatically changing to "Order Failed," leading to unnecessary entries in the wp_comments table. I specialize in WooCommerce troubleshooting and am confident I can help you resolve this.
Here's how I can assist:
-Investigating the Cause: I will thoroughly examine your WooCommerce setup, including payment gateways, server configurations, and logs, to pinpoint why orders are failing and identify any hidden errors that may be causing this issue.
-Database Cleanup: I'll address the excessive entries in the wp_comments table by cleaning up old or unnecessary order notes and optimizing your database for better performance.
-Preventative Measures: After resolving the issue, I will recommend best practices for preventing similar issues in the future, including monitoring tools and error log setups.
With my extensive experience in WooCommerce and WordPress, I am well-equipped to handle this issue quickly and efficiently.
Looking forward to resolving this for you!
Best regards,