Our organization currently has several membership levels and has since 2014. We are moving to a single membership level and sustaining contributions instead. Is there a way, short of an Update SQL Script to move anybody with Membership A to Membership B?

1 Answer 1


A 'way' would be to export all Membership data together with Internal ID, then manipulate the data as you want, and then delete all existing member data and then doing an Import. It may feel 'safer' than in mysql since you will be able to make whatever tweaks might be required for those 'odd case' members.

  • You'll lose user activity that way won't you? Mar 28, 2017 at 17:18
  • Which user Activity are you thinking of? Membership Renewal Activities etc? Not certain. Best to test.
    – petednz - fuzion
    Mar 28, 2017 at 19:31
  • The entire activity log Mar 28, 2017 at 22:51
  • sorry i don't follow. why would deleting membership records (not the Contacts) affect Activities - unless you mean just membership related Activities? is this a terminology question. in Civi a contact is a contact. and a contact can have membership records.
    – petednz - fuzion
    Mar 29, 2017 at 3:57
  • Oh yes I guess I misunderstood, but I supposed anything membership related might stick around. Mar 29, 2017 at 15:35

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.