Answers.Body: <p>If a membership is auto-renew than it should be linked to recurring contribution(See under contribution tab &gt;&gt; recurring tab).</p>
  <p>To turn off auto-renew for a membership, you can either</p>
  <ol>
  <li>Cancel the recurring, that should cancel ongoing recurring payment and also membership renewal</li>
  <li>Run Below query to only turn off membership renewal</li>
  </ol>
  <p>Sql:</p>
  <pre><code>UPDATE civicrm_membership SET contribution_recur_id = NULL WHERE id = 123;
  </code></pre>
  <p>HTH</p>
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-07-19T06:02:16.900Z
Answers.LastActivityDate: 2021-07-19T06:02:16.900Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>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.</p>
  <p>I know it is on for the member because I see this:
  <a href="https://i.sstatic.net/QsrKE.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/QsrKE.png" alt="enter image description here" /></a></p>
  <p>This is what I see if I edit the member:
  <a href="https://i.sstatic.net/9lfM6.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/9lfM6.png" alt="enter image description here" /></a></p>
  <p>Any help with this is greatly appreciated.</p>
  <p>Thanks!</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-19T02:47:28.870Z
Comments.Text: have you had a look on the contribution tab rather than the membership tab.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-19T02:47:45.967Z
Comments.Text: there should be a sub-tab relating to recurring payments
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-19T02:48:11.600Z
Comments.Text: whether you can disable from there such that it also stops at the payment processor end may depend on the payment processor
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-19T02:56:51.317Z
Comments.Text: 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)"
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-19T02:57:41.777Z
Comments.Text: currently here but won't be once the site gets its daily rebuild: https://dmaster.demo.civicrm.org/civicrm/contact/view/membership?action=update&reset=1&cid=203&id=31&context=membership&selectedChild=member
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-20T05:06:31.103Z
Comments.Text: @petednz-fuzion, turns thank you! I was testing on a pay latter contribution. It makes sense that even if auto-renewal is on it would only work (and therefore be able to cancel it) if it is a credit card transaction.
Comments.UserDisplayName: Josh
Tags: <civimember><auto-renew>
Title: Turn Off Auto-Renewal For a Specific Member
ThreadText: # Turn Off Auto-Renewal For a Specific Member
  
  (Asked by: username_0 on 2021-07-18)
  
  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](https://i.sstatic.net/QsrKE.png)](https://i.sstatic.net/QsrKE.png)
  
  This is what I see if I edit the member:
  [![enter image description here](https://i.sstatic.net/9lfM6.png)](https://i.sstatic.net/9lfM6.png)
  
  Any help with this is greatly appreciated.
  
  Thanks!
  
  **Tags:** civimember, auto-renew
  
  > **Comments:**
  > **username_1**: have you had a look on the contribution tab rather than the membership tab.  
  > **username_1**: there should be a sub-tab relating to recurring payments  
  > **username_1**: whether you can disable from there such that it also stops at the payment processor end may depend on the payment processor  
  > **username_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)"  
  > **username_1**: currently here but won't be once the site gets its daily rebuild: https://dmaster.demo.civicrm.org/civicrm/contact/view/membership?action=update&reset=1&cid=203&id=31&context=membership&selectedChild=member  
  > **username_0**: @petednz-fuzion, turns thank you! I was testing on a pay latter contribution. It makes sense that even if auto-renewal is on it would only work (and therefore be able to cancel it) if it is a credit card transaction.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2021-07-19. Score: 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
  
  Cancel the recurring, that should cancel ongoing recurring payment and also membership renewal
  Run Below query to only turn off membership renewal
  
  Sql:
  UPDATE civicrm_membership SET contribution_recur_id = NULL WHERE id = 123;
  
  HTH
  Pradeep
  
  
  ---
  
  