Disable payment gateway

[bear]

I know the process to disable a gateway, but it doesn't let me do it for one of them. I had a bit of an issue last night, and it's convinced me that I don't want to store any credit cards at all. I tried to deactivate the offline CC option, but it's grayed out and complains that it's being used.

 

I went through all accounts manually and altered the ones that used it, and there are none left I can locate (a sort by payment gateway search would be very helpful for this). I tried hiding it from product groups (unchecking the box) as well, but nothing I've done allows me to remove it. With no easy way I can find to search out what it still thinks is using this gateway, I'm getting a bit frustrated.

Anyone have an idea where or how to look for this? I'd simply like to fully remove that ability/gateway from the script...and it won't let me.

[PPH]

I know the process to disable a gateway, but it doesn't let me do it for one of them. I had a bit of an issue last night, and it's convinced me that I don't want to store any credit cards at all. I tried to deactivate the offline CC option, but it's grayed out and complains that it's being used.

 

I went through all accounts manually and altered the ones that used it, and there are none left I can locate (a sort by payment gateway search would be very helpful for this). I tried hiding it from product groups (unchecking the box) as well, but nothing I've done allows me to remove it. With no easy way I can find to search out what it still thinks is using this gateway, I'm getting a bit frustrated.

Anyone have an idea where or how to look for this? I'd simply like to fully remove that ability/gateway from the script...and it won't let me.

Yes, I had the same problem when we used it last year 1 time. When I questioned about removal, I believe it also has to be removed by deleting any transaction that used it?

[bear]

Yes, I had the same problem when we used it last year 1 time. When I questioned about removal, I believe it also has to be removed by deleting any transaction that used it?

 

I started poking through those, since I'd had that same thought. Don't suppose you know a query or method to find them all at once, do you?

[PPH]

I started poking through those, since I'd had that same thought. Don't suppose you know a query or method to find them all at once, do you?

Nope, I just removed it from being shown and it just clutters the payment processor list. I can live with it being there but rarely gets in the way.... But if you get it figured out

[bear]

Just did.

Find View all invoices, sort by payment method. One by one right click to open in a new window, change pay gateway (I used mail in payment). That was the last thing keeping me from being able to remove them, now done. Thank you for that insight.

[PPH]

Great and thanks for bringing it up and posting your solution. It would be nice to get it removed for this year since we no longer use it.

 

Did you have any transactions that had used it though?

[bear]

A few transactions, a few invoices. It was the invoices it was stuck on.

For transactions, simply "view transaction list" and then filter by payment gateway.

[PPH]

A few transactions, a few invoices. It was the invoices it was stuck on.

For transactions, simply "view transaction list" and then filter by payment gateway.

Well that's great to know, and after looking closer with the sorted invoices and transactions, I forgot we use the offline CC when users call in their CC and may still need it occasionally. So actually we need to leave ours enabled.

[Blueberry3.14]

I know the process to disable a gateway, but it doesn't let me do it for one of them. I had a bit of an issue last night, and it's convinced me that I don't want to store any credit cards at all. I tried to deactivate the offline CC option, but it's grayed out and complains that it's being used.

 

I went through all accounts manually and altered the ones that used it, and there are none left I can locate (a sort by payment gateway search would be very helpful for this). I tried hiding it from product groups (unchecking the box) as well, but nothing I've done allows me to remove it. With no easy way I can find to search out what it still thinks is using this gateway, I'm getting a bit frustrated.

Anyone have an idea where or how to look for this? I'd simply like to fully remove that ability/gateway from the script...and it won't let me.

 

This may or may not be related, and may or may not help (being as it sounds like you didn't want "offline CC" to display and not an actual payment gateway). I had problems disabling Authorize.net as a payment gateway when I switched to another gateway 6 months ago. I could set it to not display on the order form, but that didn't stop "authorize" from working it's way to new invoices.

 

I asked Matt how to completely delete a gateway, and he said it wasn't possible if there were any items/invoices in the database with authorize.

 

I found a solution that works in my case: I replaced all instances of "authorize" in the database with the name of the new gateway.

[PPH]

This may or may not be related, and may or may not help (being as it sounds like you didn't want "offline CC" to display and not an actual payment gateway). I had problems disabling Authorize.net as a payment gateway when I switched to another gateway 6 months ago. I could set it to not display on the order form, but that didn't stop "authorize" from working it's way to new invoices.

 

I asked Matt how to completely delete a gateway, and he said it wasn't possible if there were any items/invoices in the database with authorize.

 

I found a solution that works in my case: I replaced all instances of "authorize" in the database with the name of the new gateway.

That sounds like what Bear did using the admin panel for whmcs to runthe query and changed

[ldobson]

Yes. basically had the same issue, you need to change the database field "paymentmethod" to the name of the gateway you want to move too for example:

 

update tblorders set paymentmethod='quantumgateway' where paymentmethod='payflowpro';

 

update tblhostingaddons set paymentmethod='quantumgateway' where paymentmethod='payflowpro';

 

update tblhosting set paymentmethod='quantumgateway' where paymentmethod='payflowpro';

 

update tblinvoiceitems set paymentmethod='quantumgateway' where paymentmethod='payflowpro';

 

update tblaccounts set gateway='quantumgateway' where gateway='payflowpro';

 

Those to name of few of the tables in MySQL. Of course make a backup of your database first!

[cmcp]

I had this problem - thanks for the solution.

[othellotech]

Yes. basically had the same issue, you need to change the database field "paymentmethod" to the name of the gateway you want to move too

 

You shouldnt be changing tblaccounts or tblinvoiceitems on existing invoices/receipts.

To turn the gateway off just untick it

 

But yes, your sql is the quickest method to make ongoing paymenst by teh clients use the new choice for their domain and hosting payments.

[ecohosting]

Like a few others I am also experiencing the situation where new manually generated invoices are selecting a gateway I no longer use. I have over 300 transactions to change the gateway for so I can effectively 'delete' the gateway from the system. I'm not about to do that manually.

 

I'm not very SQL capable but can someone propose an SQL query that would effectively replace all table entries from one payment method to another? say from "offlinecc" to "mailin"?

[ecohosting]

I finally had a friend help me with this. In case someone else is like me and not that familiar with SQL queries here is a quick reference.

 

The query below will replace 'offlinecc' with the 'mailin' gateway in the table called 'tblinvoiceitems' in the database called 'ecocom_whmcs'. Adjust accordingly. There were about 6 or 8 tables that required the changes. To find which tables you will need to perform the updates in just run a search in PHPMyAdmin. The result will identify which tables need working on.

 

NOTE: I did not use this method on 'tblpaymentgateways'. I did this through WHMCS once all the other tables were cleared.

 

 

update ecocom_whmcs.tblinvoiceitems SET paymentmethod='mailin' WHERE paymentmethod='offlinecc'

 

I hope it helps others.

 

Cheers,

[WisTex]

You can easily hide it from customers, which is what is most important. Keeping it in the back office allows you to do reports on all previous payments made using that payment method, which may be useful to know.

 

To delete the credit card information in the database, you may want to do a replace on that particular field perhaps changing all the cards to all zeros or a test card number.