Phil
(@fullysupportedphil)
Automattic Happiness Engineer
@ericdow – it sounds like you have two issues happening here.
First,
a customer complete the payment ,But the money tatus is pending, then Paypal release the money .
That sounds like either your site is only authorizing charges, or that your site is having trouble receiving the IPN from PayPal which is needed to complete the order.
First, please go to WooCommerce > Settings > Payments > PayPal. Once there, make sure the Payment Action is set to Capture, not “Authorize”.
Image Link: http://cld.wthms.co/Gp8MTi
If that is set to capture, then I recommend having a look at our IPN Debug guide here:
https://docs.woocommerce.com/document/paypal-standard/#section-21
The second part is the errors you are seeing when trying to open or edit an order. For this, I would recommend first checking for conflicts.
We have a guide on how to test for conflicts here:
https://docs.woocommerce.com/document/woocommerce-self-service-guide/#section-4
Since those tests will impact the look and functionality of your site, I recommend doing them on a staging site. If you don’t already have a staging site set up, check with your hosting company as many offer this as part of their packages. Otherwise, you can use a free plugin such as [WP Staging](https://en-ca.wordpress.org/plugins/wp-staging/) to set one up.
Thanks for your reply . I have checked the conflicts at the begin , just left woocommerce and wordpress , the issue is still there.
My webstie is working well now , just can not open “All”, “processing” , especially “Processing “order list , I need open them one by one, it is troublesome .
So, How to delete the wrong order in database ?
To delete orders from a site’s database you would have to be familiar with the WooCommerce/WordPress database structure so you could find the order data within the database tables and rows.
The best approach would be to set up a staging site using this plugin https://wordpress.org/plugins/wp-staging/ as this will replicate your site and database and you can then look at the database of the staging site and test any deletions you perform.
This document below gives an overview of the WooCommerce database structure and may help.
https://github.com/woocommerce/woocommerce/wiki/Database-Description
Hi @ericdow,
We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.
