Getting double entry in razorpay_sales_order table.

[amit-digitsoft]

I am getting double entry in the table razorpay_sales_order for few orders as you can see below query result and because of this I facing issue while sending order to third party. As at the time of order sending the status of order not found proper.

+-----------+----------+--------------+--------------------+---------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+------------------------------+

| entity_id | order_id | rzp_order_id | rzp_payment_id | rzp_webhook_data | rzp_webhook_notified_at | rzp_update_order_cron_status |

+-----------+----------+--------------+--------------------+---------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+------------------------------+

| 2475 | 4922 | NULL | pay_P6TmrWd5dkLaQ0 | a:1:{s:18:"payment.authorized";a:3:{s:23:"webhook_verified_status";b:1;s:10:"payment_id";s:18:"pay_P6TmrWd5dkLaQ0";s:6:"amount";i:313900;}} | 1728376630 | 5 |

| 2476 | 4922 | NULL | pay_P6TmrWd5dkLaQ0 | a:1:{s:10:"order.paid";a:3:{s:23:"webhook_verified_status";b:1;s:10:"payment_id";s:18:"pay_P6TmrWd5dkLaQ0";s:6:"amount";i:313900;}} | NULL | 0 |

+-----------+----------+--------------+--------------------+---------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+------------------------------+

How it can be get resolved. Please suggest.

Magento ver. 2.4.6-p3
Razorpay ver. 4.1.3

Thanks!