Updating client status's to inactive if they have no active services

[Ricky]

Hi,

The title pretty much covers what I want to ask!

 

There is a topic on this already at http://forum.whmcs.com/showthread.php?t=11557 which has a command to do this, however the command supplied there didn't work in phpmyadmin.

 

Could anyone correct this code or come up with something that could do this.

 

Just to clarify I am wanting to find a way to set clients status to inactive if they have no active services, domains, addons, invoices etc.

 

Thanks for any help!

[othellotech]

its a fairly basic sql command ...

update tblsclients set field=value where id not in (select clientid from tbldomains) and id not in (select clientid from tblhosting)

 

if you use the affiliates system you might not want to inactive afffiliates

[Ricky]

Hi,

 

Im not using the afffiliates system so thats one less worry!

 

Thanks for the info but I can't code mysql to save my life so I can't do much with the info.

 

Thanks

[othellotech]

then you'll need to contact WHMCS sales and request a quote - at a guess they'll write you a custom report/update to do this for ~$50

[vertigos]

hi there,

What if I want clients to be inactive after 60 days of inactivity?

[Ricky]

You can't do it with WHMCS at the moment, this is the idea I also had in mind, but I thought I would first see if its possible to determine if an account is inactive. Matt says it should be fairly easy to do but he will only impliment this if there is enough interest for the feature.

 

I for one think there should be an option to allow accounts to be automatically marked as inactive after x days if the account has no active services, domains or outstanding invoices etc.

 

I think this feature would be good in terms of keeping account details up to date, but this feature could also be used for marketing, i.e. sending deals to inactive customers and for statistical purposes.

 

I wouldn't say its a critical feature but its one of those simple but handy features that WHMCS could have.

 

What do you guys think?

[merlinpa1969]

I agree with this,

 

and want to stipulate that this would need to close the account not cancel or delete the account.

 

also an API Action hook needs to be added to the account close,

 

this will allow users to then implement third party processes on this action ( example is to remove user from mail list )

[cmo]

In our case, what we just need is an indication of active and inactive clients.

 

We are very much interested to know how many active clients we have, if it has increased or decreased in a certain period of a month or so.

[othellotech]

In our case, what we just need is an indication of active and inactive clients.

 

see post #2, its how we do exactly what you need ...

[Ricky]

Your right, post #2 does show how to do it.

 

But I'm asking for such code to be implimented as a feature so that more can be done, as other people and myself have suggested.

 

I think cmo was hinting at the possibility of having graphs showing trends of how many customers are marked as inactive over a specified period.