Switching processors

Discussion in 'Payments processing' started by johnww, Oct 17, 2015.

  1. johnww

    johnww aMember Pro Customer

    Joined:
    Oct 18, 2005
    Messages:
    50
    We are using amember 4.6.3

    We are currently using a certain payment gateway (gateway A) and we are considering switching to another gateway (gateway B).

    Both gateways are the insecure type where amember stores card data in the database.

    What we want is the following: For all the existing recurring payments in the database, the next time the recurring payment date arrives, the next new payment is processed with gateway B.

    Can we simply manually edit the database table and switch the processor from "gateway A" to "gateway B"?
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Yes you can do this. You need to update all recurring active invoices and change paysys_id for all invoices from gateway A to gatewaty B
  3. johnww

    johnww aMember Pro Customer

    Joined:
    Oct 18, 2005
    Messages:
    50
    Thank you Alexander.
    2 more questions:

    1. Can you give me the mysql query to make this change.

    2. If gateway B was Stripe (tokenized), would this simple switchover method still work?
  4. caesar

    caesar aMember Pro Developer Staff Member

    Joined:
    Oct 16, 2009
    Messages:
    2,295
    The query is
    UPDATE am_invoice SET paysys_id = 'new paysys id' WHERE status=2 AND paysys_id = 'old paysys id';

    2 - means recurring active

    Unfortunately such simple approach does not work for Stripe because of Stripe uses tokens. We can implement batch script that will convert all your CC info to Stripe tokens and change payment systems in existing recurring invoices. Please contact us in helpdesk ( https://www.amember.com/support ) for quote.

Share This Page