Changing payment method for mutilple services and invoices

[joedogs]

Does anyone know how to change the default payment method for all clients (services) and invoices without doing it individually?

 

Is there a way to do it through phpMyAdmin?

[othellotech]

update tblinvoices set paymentmethod="paypal" where status="Unpaid" and userid=n;

update tblhosting set paymentmethod="paypal" where id=n;

etc

[WHMCS John]

This would all clients using Authorize to Quantum. Substitute with your gateways as appropriate:

 

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';

[joedogs]

Thank you!!