search

Adyen / adyen-magento2

Adyen Payment plugin for Magento2
MIT License
155 stars 211 forks source link

Orders Stuck in Pending Status Due to Empty adyenOrderPayments Parameter #2758

Open jvrodriguesgranado opened 1 week ago

jvrodriguesgranado commented 1 week ago

Describe the bug Hello,

I'm encountering an issue where some orders in my Magento 2 e-commerce store remain stuck in the "pending" status. After investigation, I identified the problem within the compareAdyenOrderPaymentsAmount function, located in the adyen/module-payment/Helper/AdyenOrderPayment.php file.

To Reproduce I was unable to reproduce this issue in a local environment, but I added a log in the production environment to gather evidence. I encounter around 5 orders daily with this problem. Even though the payment is approved in the Adyen dashboard, the order status remains "pending" in Magento.

Magento version 2.4.6-p4

Plugin version 9.8.1

Screenshots

image image image

candemiralp commented 5 days ago

Hello @jvrodriguesgranado,

Thank you for raising this issue. The issue that you have described sounds very similar to a known issue due to having synchronous database replication of Adobe Commerce enabled.

Could you please try disabling synchronous database replication and observe the system?

Best Regards, Can

jvrodriguesgranado commented 2 days ago

I spoke with our architecture team at Granado, and we are unable to implement the suggested solution. Since this is a recommendation from Adobe, we cannot risk losing the benefits defined by Adobe for this functionality, particularly scalability:

Provides data backup Enables data analysis without affecting the master database Scalability