skip to Main Content

I am running a magento store and getting issues with PayPal. Payments are being taken but no order is created.

I am getting this error in the log:

main.CRITICAL: Exception: Wrong order ID: "000002353". in /domains/domain.co.uk/http/vendor/magento/module-paypal/Model/Ipn.php:140

The order with that number does not exist. (Skipped)

I found this: https://magento.stackexchange.com/questions/214182/wrong-order-id-paypal-ipn-exception-magento-2 but it doesn’t really provide a solution to the problem. I am running on Magento ver. 2.1.8

Anyone else had a similar problem?

2

Answers


  1. Chosen as BEST ANSWER

    I had an issue where the Payment was captured but the order was not created.

    I had to refund a lot of customers and the exception here is from the PayPal IPN that is trying to add a IPN number to an order that does not exist.

    To fix the problem, I followed the following article to set up the IPN on the PayPal account: https://developer.paypal.com/docs/api-basics/notifications/ipn/IPNSetup/


  2. In my case, I found the issue is

    Numeric value out of range: 167 Out of range value for column 'sequence_value' at row 1, query was: INSERT INTO `sequence_invoice_1` () VALUES ()
    

    Then I go to table sequence_invoice_1 and have changed type of "sequence_value" from int(10) to bigint(20). Now, it works fine.

    Our customer have a lot order migration from Magento 1 to Magento 2. That is an issue.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search