I have a list of some 700 email addresses that currently have a membership status of Current. I'd like to change to a new Membership status I've created in Membership Status Rules called Bouncing Cancelled.

I've tried exporting doing it via an import:

"Email","Membership ID","Membership Start Date","Membership Type","Status Override","Status Override End Date","Membership Status"
"[email protected]","19201","2018-10-01","Member","1",,"Bouncing Cancelled"

And variations of that (like setting the just the status to just Cancelled), but regardless of what I do the import always fails with: Invalid value for field(s) : Membership Status.

Can suggest a different way?

  • 1
    I've done it now, using a convoluted semi manual processes. I created a new field, set that field y1, y2 and so on so I could use search to locate them and then use "Update multiple memberships" to manually set the status for each contact. Given this must be a common issue it seems like there must be a better way. Jan 13, 2019 at 9:33

1 Answer 1


Invalid value for field(s) : Membership Status means that the csv file had invalid options for Membership status. The import file should use machine name rather label (or hopefully membership status ID).

Here is the similar post that might help to find solution for your question.



  • I knew that error meant it didn't like the field contents. However I didn't put some random value in there. Instead I set membership to the status I wanted, exported it, then copied what it was set to the 700 members I wanted to cancel. Jan 14, 2019 at 7:47
  • Agreed while exporting it export with membership status label so you will need to and replace it with name or id Jan 14, 2019 at 9:32

Your Answer

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

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