Payment issues - how to delete or change payment method

[GrinGEO]

Hi have a few orders where the customer did not pay the order by digital payment, like stripe or paypal.

Probably their bank refused the payment.

I have the issue that I need to change the customer to bank wire, but I cant delete or modify the original payment, even not in PresTool.

Is there any other workaround? becouse any modification I try the original payment is set again.

 

[Daresh]

It's not easy because in general, payment modules may have their own tables in the database, storing additional data related to orders. So changing a payment method to another one would require knowing it precisely and what it requires. Maybe that's why there is no such functionality in PrestaShop.

Even if you change the payment related columns in the database (prefix_orders table), the Stripe module that you have may keep some data related to that order. So to change the payment method in a clean way, it would be recommended to also remove everything related to that order from Stripe's tables.

[GrinGEO]

Hi Daresh

Yes you are right. If I use order manager module and change the payment type, effectively Stripe overwrites it.

The problem is now that the customer did not pay by Stripe, becouse his bank refused the payment. The easiest would be to modify the payment type to bank, or just be able to disable stripe on that order for example. Or I need to cancel the order and make a new one.

[Daresh]

Exactly! So the question is does this order got sent to Stripe and it will overwrite it all the time, or can it be removed on the store level (from some Stripe database tables).

Probably some custom module would be required here, one that knows what Stripe does and is able to remove some information from it.

[alex_developer]

Most likely, the Stripe module has its own table in the database, such as ps_stripe_orders. Search for a similar table in the database and delete this order from it. Then change the payment method. After that, requests from Stripe for this order will simply be ignored by this module.

 

 

[ErnestQ]

Yeah, the Stripe module usually stores its payment data in a separate database table — most often something like ps_stripe_payment or ps_stripe_orders. If you remove the record related to that specific order, Stripe will stop overwriting the changes. Just make sure to back up your database before doing anything, since one wrong query could break the link between the order and its payment data. It’s a quick fix, but worth doing carefully.

[El Patron]

would it not be simpler to just cancel the order?  

Edited October 30 by El Patron (see edit history)

[GrinGEO]

Yes Stripe is overwriting it all time. So there is no way to delete this payment, even if it failed. In my opinion this is a PS major issue. Becouse payments can always fail. In this case you should be able to assign a new payment.

@El Patron: Yes would be simpler. In this special case we already shipped the parcels and we have tracking synched with this order over Packlink.

But probably is better to cancel the order and make new one instead of losing time.

[Daresh]

Did you delete the payment data from Stripe module's database tables?

[GrinGEO]

I prefer not to mess up directly in the DB. Im wondering there is no solution provided by PS where I can disable one payment and activated another one. Very strange behavior.