i want to turn off all recurring payment as seen a bug in my script i want users to re pay as i have lost 400 ids in a txt file that was linked to my script. i could do it 1 by 1, but will take ages, wonder if some commands i can do?
I am afraid there is not such featcure out of the box but I believe we can find some good solution for you. What is payment system you use?
stripe, i would like my monthly subs to be auto cut off when money due and make them start a new order
Sounds good. In case of stripe aMember trigger re bills so it is simple enough to cancel all recurring invoices at once with simple MySQL query. Here is query that you can use: Code: UPDATE am_invoice SET tm_cancelled = NOW(), rebill_date = NULL, status = 3 WHERE paysys_id = 'stripe' AND status = 2;
ran today said Affected rows: 13 (Query took 0.0016 sec) i see on right the green recring is now, 0 so i guess done? SQL query: UPDATE am_invoice SET tm_cancelled = NOW( ) , rebill_date = NULL , STATUS =3 WHERE paysys_id = 'stripe' AND STATUS =2
I am afraid not. In case of PayPal it is not possible to do from aMember database. PayPal server handle these subscriptions. So you need to cancel it on PayPal side. Best Regards.