2

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?

Improve this question
1
  • 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.
    – Russell Stuart
    Commented Jan 13, 2019 at 9:33

1 Answer 1

Reset to default
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.

Cheers

Pradeep

Improve this answer
2
  • 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.
    – Russell Stuart
    Commented 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
    – Pradeep Nayak
    Commented Jan 14, 2019 at 9:32

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.