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
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/
In my case, I found the issue is
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.