Custom module needed: Project Cleanup

[stumblrmonk3]

Hello developers,

 

Our company uses WHMCS as a CRM and after 2 years in production (and about 5,000 services sold), we've run into a problem where we have customers who haven't stopped using our services (i.e. never paid their invoices) but those customers are still active. We need to know how many of them are inactive so one way to do that is to have a module that runs through the database to cleanup and corrects customer statuses.

 

This is pseudo-code of what this module would do, while looping customer database:

 

 

1. Check how many services customer has
   
2. For every recurring product/service, check to see if there is an unpaid invoice over X months old.
   
3. Set this invoice status to CANCELLED and set the related product/service status to "Cancelled"
   
4. If no active products/services left for current customer in the loop, then set the customer's status to "Inactive".
   

 

I am aware that there is a script that does something similar but I tried it and it doesn't seem to do anything.

 

I am willing to pay $100 for this module. Price is negotiable.

 

Thank you!

[wsa]

Pls email whmcs developer dept at whmcs (at) hostthebest.com

[othellotech]

[*]For every recurring product/service, check to see if there is an unpaid invoice over X months old.

[*]Set this invoice status to CANCELLED and set the related product/service status to "Cancelled"

You dont want to do that, you want to call the actual termination first ...

[stumblrmonk3]

htb -- I sent in a ticket via your website.

 

othellotech -- these are not hosting-related products/services, so no need to terminate anything. I use WHMCS strictly as a customer service portal.

 

Any other takers?

 

Thanks!

[wsa]

htb -- I sent in a ticket via your website.

 

ok thank you