Answers.Body: <p>If you have access to the civicrm database and, using PHPMyAdmin, find the table "civicrm_membership" and the column "is_overide", you could carefully change the relevant values to "NULL".  You would be advised to first take a backup of the database in case anything goes wrong.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-22T19:42:10.733Z
Answers.LastActivityDate: 2016-12-22T19:42:10.733Z
Answers.UserDisplayName: peterb
Answers.Body: <p>It sounds like you are wanting to have Memberships auto-renew based on  Direct Debit - this could be possible if there is an integration for the Direct Debit </p>
  
  <p>Otherwise there may be a work around such as making Direct Debit memberships a type that is set to Lifetime, and you would then need to pick up on when a Direct Debit payment does not happen and put in an End Date.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-20T23:17:07.743Z
Answers.LastActivityDate: 2017-02-20T23:17:07.743Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>Is there anyway of turning off status override for all memberships rather than individually going into each one.</p>
  
  <p>Thanks,</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-21T19:00:11.957Z
Comments.Text: Do you want to clarify why you have so many with Status override? I know it isn't part of the 'answer' but I for one am curious.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-02-17T13:01:27.037Z
Comments.Text: Actually what I would like to do is status override everyone who pays by direct debit, so there membership stays current.
  
  In relation to this question. We were using status override, not thinking that it stays that way constantly. We have now manually turned them off.
Comments.UserDisplayName: A Davidson
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-02-17T20:36:00.580Z
Comments.Text: sounds like a simple extension would be able to deliver this but don't have a recipe to offer off-hand
Comments.UserDisplayName: petednz - fuzion
Tags: <civimember>
Title: Status override bulk update
ThreadText: # Status override bulk update
  
  (Asked by: username_0 on 2016-12-21)
  
  Is there anyway of turning off status override for all memberships rather than individually going into each one.
  
  Thanks,
  
  **Tags:** civimember
  
  > **Comments:**
  > **username_1**: Do you want to clarify why you have so many with Status override? I know it isn't part of the 'answer' but I for one am curious.  
  > **username_0**: Actually what I would like to do is status override everyone who pays by direct debit, so there membership stays current.  In relation to this question. We were using status override, not thinking that it stays that way constantly. We have now manually turned them off.  
  > **username_1**: sounds like a simple extension would be able to deliver this but don't have a recipe to offer off-hand  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-12-22. Score: 1
  
  If you have access to the civicrm database and, using PHPMyAdmin, find the table "civicrm\_membership" and the column "is\_overide", you could carefully change the relevant values to "NULL". You would be advised to first take a backup of the database in case anything goes wrong.
  
  
  ---
  
  ### Answer by username_1 on 2017-02-20. Score: 0
  
  It sounds like you are wanting to have Memberships auto-renew based on Direct Debit - this could be possible if there is an integration for the Direct Debit
  
  Otherwise there may be a work around such as making Direct Debit memberships a type that is set to Lifetime, and you would then need to pick up on when a Direct Debit payment does not happen and put in an End Date.
  
  
  ---
  
  