Inactive membership...reactivate

I could be wrong, but I think membership status can only be changed by running a query in SSMS. It gets changed via the membership update utility (however often you have that scheduled to run), but other than that I think you have to run a SQL query to change it. It was the only way we could change incorrect initiation dates that came over with our legacy data.

We ran into a similar problem when some of our memberships lapsed during COVID, and then we wanted to extend some. Our Membership Director had to create special new memberships in the meantime, then updated from there (that's my understanding, at least).

I second the request for figuring out how to re-activate memberships!

If you make a list of the folks you want this applied to and have ssms access you can run something like the following (you'll def want to change the dates below, this is just a quick example). 

--UPDATE cm --uncomment to update
--SET cm.expr_dt='2021-08-01 00:00:00' --uncomment to update
SELECT cm.customer_no, cm.memb_level, '2021-08-01 00:00:00' AS new_expr, cm.expr_dt AS old_expr --comment out when updating
FROM dbo.TX_CUST_MEMBERSHIP cm
JOIN dbo.T_LIST_CONTENTS l ON l.customer_no = cm.customer_no
WHERE l.list_no=24887 --insert your list of identified candidates here
AND cm.memb_level IN ('SUP','PAR','FAM','ADV','SPN','AMB') --insert your levels here
AND cm.expr_dt >= '2020-03-01 00:00:00' AND cm.expr_dt <= '2021-04-01 00:00:00' --expirations between march 1 2020 and midnight apr 1 2020
AND cm.current_status IN (1,7) --inactive, lapsed

We actually have the issue with the incorrect initiation, dates as well! If you have time, I would love to hear more about how you fixed it if you have that info readily available!

To run this, we'd need:

the list of candidates,

the dates to which we want the new expiration date changed,

the abbreviations of the membership levels.

Then the query updates the TX_CUST_Membership table with the new expiration dates, is that right? Would that be enough to re-activate? Is activation looking solely at expiration dates?

I'll dig back through my emails and find the table we updated for you first thing tomorrow morning.

And the range of expiration dates you want to update. Probably easiest to run this with fixed dates for each month unless you want to plug in some relative dates. I thiiiink the membership update utility updates the status, but I could be making that up. I'll try to get a chance to test it. We're still waiting to re-open to update our memberships. 

Thanks so much!

Thanks Amanda, this worked brilliantly to get the dates right.  I am still a little stuck on how to get them back to being 'Active'. They now have an expiry date in the future, but with an inactive membership. I tried running the normal update utility, but It seems to look for Active or Pending memberships, and not the reverse. So if you or anyone has any brilliant ideas, that would be awesome.

Could it be as simple as something like this...?

--UPDATE cm --uncomment to update
--SET cm.current_status='2' --uncomment to update
SELECT cm.customer_no, cm.memb_level, cm.current_status, '2' AS new_status, cm.current_status AS old_status --comment out when updating
FROM dbo.TX_CUST_MEMBERSHIP cm
JOIN dbo.T_LIST_CONTENTS l ON l.customer_no = cm.customer_no
WHERE l.list_no=1393 --insert your list of identified candidates here
AND cm.expr_dt >= '2020-07-01 00:00:00' AND cm.expr_dt <= '2020-07-31 00:00:00' --expirations between march 1 2020 and midnight apr 1 2020
AND cm.current_status IN (1,7) --inactive, lapsed