How to delete a wrong order?

  • Resolved ericdow

    (@ericdow)


    6 years, 2 months ago

    issue : can not open “all” and “processing” in woocommerce back-end, when I click “all” and “processing” ,it display [an error occurred while processing this directive].
    I can open “on-hold” order list in wordpress dashboard, open an order , eg .com/wp-admin/post.php?post=36992&action=edit, then change the order number , I open the other processing orders one by one. At last I find the issue order, it display [an error occurred while processing this directive] too.
    what happen before the issue: a customer complete the payment ,But the money tatus is pending, then Paypal release the money .
    I can not delete that order because I not open in in back-end .
    How can I delete this wrong order via database ? Or what should I do ?

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • 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: https://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.www.ads-software.com/plugins/wp-staging/) to set one up.

    Thread Starter ericdow

    (@ericdow)

    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 ?

    Plugin Support Stuart Duff – a11n

    (@stuartduff)

    Automattic Happiness Engineer

    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://www.ads-software.com/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

    Luminus Alabi

    (@luminus)

    Automattic Happiness Engineer

    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.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘How to delete a wrong order?’ is closed to new replies.