High rate of pending orders

  • Resolved cutu234

    (@cutu234)


    1 year ago

    Hi there,

    some months ago we switched to the V2 API and installed your plugin. Before that, the rate of pending Paypal orders was around 2%. Now, we have an average of around 6% with peaks of up to 10%. This is, of course not acceptable,

    I can see the following errors in the log file:

        [error] => Array
        (
            [name] => UNPROCESSABLE_ENTITY
            [details] => Array
                (
                    [0] => Array
                        (
                            [field] => /purchase_units/@reference_id=='default'/amount/value
                            [value] => 46.67
                            [issue] => AMOUNT_MISMATCH
                            [description] => Should equal item_total + tax_total + shipping + handling + insurance - shipping_discount - discount.
                        )

                )

            [message] => The requested action could not be performed, semantically incorrect, or failed business validation.
            [debug_id] => e6d3f110a419c
            [links] => Array
                (
                    [0] => Array
                        (
                            [href] => https://developer.paypal.com/docs/api/orders/v2/#error-AMOUNT_MISMATCH
                            [rel] => information_link
                            [method] => GET
                        )

                )

        )

)

    I have no idea what that means. All values are 100% correct. What kind of “mismatch” would this be?

    Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Payment Plugins

    (@mrclayton)

    Hi @cutu234

    There should be an entry before that, that shows what data was sent to the PayPal API. The plugin has code in place to ensure the totals always match so that’s a surprising error.

    The PayPal API is not the most robust. That error occurs if the cart’s total sent to PayPal is off by a single cent, when adding together all of the line items like the product total, shipping total, tax total etc. Those values added together can sometimes be different by a single cent $0.01 because of how rounding takes place in WooCommerce.

    It would be helpful to see the entire request if you can find that in the request logs.

    KInd Regards

    Thread Starter cutu234

    (@cutu234)

    Thank you very much for the fast reply. Very much appreciated! We could fix the error. Well, sort of. The problem was a rounding error in Woocommerce that results in problems with our external accounting system. This is super annoying. We changed the settings to 6 digits. Unfortunately, this caused other rounding errors and therefore the amount mismatch. I’m literally pulling my hair out!

    However, even with this problem “fixed”, we still have a very high rate of pending orders, even without any errors in the log. I am absolutely sure that your plugin works just fine. Unfortunately, there is no Paypal support to speak of. So, I desperately posted my question here.

    The only pattern I can see is that the redirection to the thank-you page takes very long (30 seconds and more). This might result in users cancelling the order or purchase again.

    The site clone on the staging server, on the other hand, works much better.

    It is unbelievable. Sorry for bothering you. I know that you guys do a great job!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘High rate of pending orders’ is closed to new replies.