MySQL/Woocommerce Expert Needed -- 2

Job ID: 32308441

Budget: $10 – $30 USD

Hello!

I have a woocommerce store and I've been trying to delete orders that are older than 6 months but I've been having a lot of issues. If I try to bulk delete, the backend crashes because of too many requests. I've also tried two other tools to help me with this but there are just too many orders.

I Googled solutions and there seems to be another way, see this: https://stackoverflow.com/questions/49187930/write-an-sql-query-to-remove-old-orders-in-woocommerce

I tried bulk deleting the max amount of orders Woocommerce will allow on the screen which is 999. I get this error: "414 Request-URI Too Large openresty"

I need to delete all orders older than 6 months. There's a TON of orders so even if we were to do this in 999 chunks, it would take forever. I need a solution to delete all woocommerce orders in the backend that are older than 6 months?

Thanks!
Related categories: PHP WordPress MySQL HTML WooCommerce