We had a developer build a plugin for a new payment gateway, but he did not build in the functionality to import the old data. I wrote a script to update the payment tokens through SQL to add the new token, but I am finding some of the tokens for our current payment gateway are not listed in the payment_tokens table, making most of the queries useless. If I update the _payment_method and _payment_method_title meta_key in the postmeta table with appropriate values for the new payment gateway, and add the token to one that does exist in the payment_tokens table, the subscription will renew with the new payment gateway. Only issue being not all of these tokens are stored in the payment_tokens table. I thought building the queries would be the fastest method for this import, but I’m starting to think building a plugin would be the fastest way. If anyone could point me in the right direction, that would be wonderful.
Read more here:: Updating WooCommerce Subscription Gateway