I was sure I knew how to do this but now I am not finding the solution so I apologize if this is right in front of me. We have memberships that we want people to have auto-renewal for but sometimes we need to turn it off for a specific member. I do not see a way to turn off auto-renew from the admin interface for a single member.

I know it is on for the member because I see this: enter image description here

This is what I see if I edit the member: enter image description here

Any help with this is greatly appreciated.


  • have you had a look on the contribution tab rather than the membership tab.
    – petednz - fuzion
    Jul 19, 2021 at 2:47
  • there should be a sub-tab relating to recurring payments
    – petednz - fuzion
    Jul 19, 2021 at 2:47
  • whether you can disable from there such that it also stops at the payment processor end may depend on the payment processor
    – petednz - fuzion
    Jul 19, 2021 at 2:48
  • 1
    actually i just set one up on dmaster and on the 'edit membership' i see this at the top "This membership is set to renew automatically . Please be aware that any changes that you make here may not be reflected in the payment processor. Please ensure that you alter the related subscription at the payment processor. To stop the automatic renewal: Cancel auto-renew (link)"
    – petednz - fuzion
    Jul 19, 2021 at 2:56
  • currently here but won't be once the site gets its daily rebuild: dmaster.demo.civicrm.org/civicrm/contact/view/…
    – petednz - fuzion
    Jul 19, 2021 at 2:57

1 Answer 1


If a membership is auto-renew than it should be linked to recurring contribution(See under contribution tab >> recurring tab).

To turn off auto-renew for a membership, you can either

  1. Cancel the recurring, that should cancel ongoing recurring payment and also membership renewal
  2. Run Below query to only turn off membership renewal


UPDATE civicrm_membership SET contribution_recur_id = NULL WHERE id = 123;



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.