Issue with Updating payment_session Table

[dhanasekar13]

I attempted to update the payment_session table using the query below, but the record is not getting updated.

await paymentModuleService.updatePaymentSession({
id: 'pay_sess_example_value',
data: { ...response, payment_method },
});

However, the values from createPaymentSession are still being retained, and the updated data is not reflecting in the table.

Please help with a workaround or suggest an alternative approach to ensure the changes are updated correctly.

[LysCongThanh]

updatePaymentSession doesn't write the data you pass in. In the payment module (payment-module.ts, same code on develop, v2.11.2 and v2.12.5), your data is only handed to the provider as the input of updatePayment, and the session row is then saved with whatever the provider returns:

const providerData = await this.paymentProviderService_.updateSession(
  session.provider_id,
  { data: data.data, amount: data.amount, currency_code: ..., context: data.context }
)
// ...
data: providerData.data,

So the data column ends up as the data returned by your provider's updatePayment(). If that method returns the previous session data, or only the PSP response, that is what stays in the table (the built-in system provider returns { data: {} } on develop).

Fix: make your provider's updatePayment return the data you want stored, for example return { data: { ...input.data, ...pspResponse } }.

Also, UpdatePaymentSessionDTO requires amount and currency_code, which your snippet doesn't pass.

Not verified: I haven't seen your provider code or run this, so I can't tell what your updatePayment currently returns.