Order - how to delete assigned payment

[cukrovijinak]

Hello,

I need to delete payment assigned to some orders. It looks like it is not possible. I tried to add payment with negative value but it is not allowed.

Thank you in advance

[bnadauld]

is it the same issue im having - where i need to correct a payment (see pic) by deleting it and adding a new one?

[jmauclair]

You must go through your database,  in the table : 

[PREFIX]_order_payment

You just have to delete the payment line concerned, here is a quick query to easily find the payments by order reference :

SELECT * FROM [PREFIX]_order_payment WHERE order_reference=[ORDER_REFERENCE]

Then you just select the lines you want to delete

[[email protected]]

On 1/11/2023 at 2:55 PM, jmauclair said:

You must go through your database,  in the table : 

[PREFIX]_order_payment

You just have to delete the payment line concerned, here is a quick query to easily find the payments by order reference :

SELECT * FROM [PREFIX]_order_payment WHERE order_reference=[ORDER_REFERENCE]

Then you just select the lines you want to delete

Hi thanks! Do you know if exist a module for do it throught backend? 
Thanks!

[Andrei H]

Hello,

I'm leaving this here, for future reference.

I developed a free module that implements this functionality. The module is currently available only for PrestaShop 8. I might look into making it compatible with 1.7 as well in the future.

You can get it from here

Please test it in a staging environment first.

Edited May 6 by Andrei H (see edit history)