For some reason I ignore, a few contacts - that have been merged by our client - have 2 identical memberships when they should only have one.
I want to merge these memberships but can't find if it's possible without accessing the DB.
I can search for memberships but then the 'action menu' provides no way to merge
Is this possible?
Our approach is to merge the duplicate contact that retains the contribution records, then apply a "transferred" status to make one membership dormant, then move the duplicate into the primary membership. This happens to us when a member renews using "Bob Jones" instead of "Robert Jones" and a duplicate record/membership is created. We then just add the membership term to the original and "orphan" the renewal membership by applying the "transferred" status.
I can see only mysql or php script way to do that because of the complexity because it will need to
Update the line item reference i.e civicrm_line_item.entity_id, incase the membership doesn't have payment best to delete to avoid duplicate mysql error.
Merge civicrm_membership_payment
Merge custom groups data
Merge membership logs
