I've got a manually-unmanageable number accounts created by bot activity I'd like to inactivate (not purge) while we test out improved captcha. Can anyone point me to the code invoked by the constituent menu or possibly already have code written for this. I'm thinking there's probably more to it than updating inactive and inactive_reason in T_CUSTOMER.
Thanks!
Hi John -
Best practice here is to schedule accounts created by bot activity to be purged, as opposed to just inactivating them. However, if you'd like to proceed with inactivating, you can update inactive and inactive_reason in T_CUSTOMER as you surmised. The inactive column should be set to 2 ('Inactive' from TR_CUST_INACTIVE) and the inactive_reason should be a valid id from TR_INACTIVE_REASON. As always please continue to work in Test first as you have been!
You can also schedule accounts to be purged en masse (or we can take care of that for you in Support). I see you have a support ticket open on this so if you'd like to go that route please let us know in the ticket and we can take it from there.
Patrick
Patrick, that's the end game, but meanwhile holding them for review.