itvietnam Posted September 13, 2019 Share Posted September 13, 2019 Hi, May i know how to do bulk update multiple clients account to inactive or closed status direct from mysql? I can see 3 status from mysql view. For example, their email failed into domain expired, domain is not exist, their account is nolonger exists... These list will be check and save as .txt format, each address listed per line. 0 Quote Link to comment Share on other sites More sharing options...
DennisHermannsen Posted September 13, 2019 Share Posted September 13, 2019 WHMCS can automatically set the client as inactive when they no longer have any active products/domains with you. See this: https://docs.whmcs.com/Automation_Settings#Client_Status_Update 0 Quote Link to comment Share on other sites More sharing options...
itvietnam Posted September 13, 2019 Author Share Posted September 13, 2019 Sorry, i mean set to closed. Inactive may become active if you try to recover them back via marketing email. Closed mean: no sending any further email. Because this is not real client. You can not contact them anymore. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted September 14, 2019 Share Posted September 14, 2019 23 hours ago, itvietnam said: May i know how to do bulk update multiple clients account to inactive or closed status direct from mysql? to close all accounts, you could use the SQL query.. UPDATE tblclients SET tblclients.status = 'Closed' to add conditions to that, you would use WHERE statement(s). alternatively, there's the CloseClient API function or there are commercial solutions available in Marketplace. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.