How do I add a Free Month to every User?

My site has only one level of access. We currently have about 150 users. I would like to give everyone currently subscribed a free extra month on their subscription. Is there an easy way to do this?

I was thinking one way would be to create a new product, called BONUS MONTH with the same renewal group as the current product and then use the MASS SUBSCRIBE option to give it to ever member. Would that work?

Or go through manually and change everyone's expiration date by a month.

But I'm hoping there's just one way to instantly add a month to everyone's account.

Thanks.

You want something like

Code:

UPDATE amember_payments SET expire_date=DATE_ADD(expire_date, INTERVAL 1 MONTH)

Test before use though, it assume all users have valid dates, no 2037-12-31 expiries (etc).

Larry