I do have a website for training foreign-based dental graduates for 2 day, 4 and 6 day bench test programs. I did receive a lot of failed orders in my system due to allowing direct debit and credit cards in the Paypal as an “advanced processing option”. (I did turn it off now and no new spams).
To delete the Orders, what I did was to install a plugin called AdminerEvo. I then exported all data from the table wp_orders in a csv file using the tool.
I then ran a SQL command to delete all “wc-failed” orders and boom, it is fixed.
DELETE
FROM eHoRa_wc_orders where status = 'wc-failed'
LIMIT 2000
-
This reply was modified 3 days, 2 hours ago by rthasma. Reason: Make the link to open in a new tab
