Paypal to AlertPay

[imtom]

Mods, first let me apologize if I posted this in the wrong forum

 

The question I have is, if everything you setup was via payment gateway as paypal and I no longer wish to accept paypal how can I deactivate it without going through every single client and every single service and modify, is there a simple way of switching from paypal to alertpay within WHMCS?

 

Thanks

[WHMCS John]

Navigate to Setup > Payment Gateways and untick the "Show on Order Form" option for PayPal. Then edit your product groups (Setup > Product/Services > Edit) an untick the PayPal option. This will prevent new clients from selecting PayPal.

 

Then run the following from the SQL tab in phpmyadmin:

 

UPDATE tblhosting SET paymentmethod='quantumgateway' WHERE paymentmethod='authorize';

UPDATE tblhostingaddons SET paymentmethod='quantumgateway' WHERE paymentmethod='authorize';

UPDATE tbldomains SET paymentmethod='quantumgateway' WHERE paymentmethod='authorize';

UPDATE tblinvoices SET paymentmethod='quantumgateway' WHERE paymentmethod='authorize' AND status='Unpaid';

 

Replace quantumgateway with the new gateway and authorize with the old gateway. You can find the exact names to use in tblpaymentgateways.

 

As always, before making any changes to the database please backup.