Migrate to another CC module (from Authorize.net to Quantum)

[Francisco]

I have about 50 customers that I need to migrate to Quantum gateway, currently I can't figure out a way to automatically switch the CC method massively on all of them to start using Quantum gateway

[MACscr]

Its easy to do with a simple sql query.

[ur]

Expanding on MACscr thought:

 

in general:

 

UPDATE table

SET column = expression

WHERE predicates;

 

Now there are a few tables with the payment method you need to update (tbldomains, tblhosting, tblinvoiceitems, tblinvoices, tblorders, and possibly a few more)

 

here's an example how to update table "tbldomains ":

 

UPDATE tbldomains

SET paymentmethod='quantumgateway'

WHERE paymentmethod='authorize';

 

You will also want to do a WHERE paymentmethod='authorize' AND status='pending'; to update only unpaid invoices on certain tables.

[Francisco]

Thanks!