Jump to content

Active/Inactive Products & Clients


xlegends

Recommended Posts

Hi guys,

From my understanding clients can be active/inactive and products as well can be considered Active or inactive ..

I have an issue that started with a discovery of inactive clients still showing as active..

My desired settings:

Setup - Automation - Miscellaneous - Client Status Update - Change client status based on active/inactive products

 

After several cron jobs, their status did not change..

I then investigated their expired products and they appear to be labeled Active

 

All our products, expired or not, are all Reoccurring, although at one time some of them did have "one time" product but we have deleted that product from every profile in the past. 

 

What Im trying to do:

When products expire, I would like them to automatically move from Active to Completed or any label defined as inactive because if this is done, then whmcs will consider that client inactive based on the global setting/definition of inactive client. 

I hope this can be accomplished within the stock whmcs

Edited by xlegends
Link to comment
Share on other sites

I think I may know the issue,

https://docs.whmcs.com/Automation_Settings#Automatic_Module_Functions

Automation Settings - Automatic Module Functions - Tick this box to enable automatic termination

I have this box unchecked for the reason I thought it would delete the entire customer profile.

Can someone confirm that it only removes expired products?

Link to comment
Share on other sites

I didnt use hotfix because it was mentioned for v750 assumed it was fixed in 751

I have version 751 and after the cron fails

overdue suspensions and  terminations the module Q is empty

will try to upload fresh copies of v751

/resources and /vendors

Edited by xlegends
Link to comment
Share on other sites

WHMCS Automation Task Utility: all
==================================

 Daily Cron Automation Mode

Queuing Tasks
-------------

 Force run any tasks: ignore "in progress" and "is due"
 Task queues ready

Executing Application Queue
---------------------------

  0/24 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0% < 1 sec/< 1 sec 20.0 MiB
 Currency Exchange Rates
  1/24 [▓░░░░░░░░░░░░░░░░░░░░░░░░░░░]   4% < 1 sec/< 1 sec 20.0 MiB
 Product Pricing Updates
  2/24 [▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░]   8% < 1 sec/< 1 sec 20.0 MiB
 Invoices
  3/24 [▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░░]  12%  1 sec/8 secs 22.0 MiB
 Late Fees
  4/24 [▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░]  16%  1 sec/6 secs 22.0 MiB
 Credit Card Charges
  5/24 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░]  20%  1 sec/5 secs 22.0 MiB
 Invoice & Overdue Reminders
  6/24 [▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░]  25% 2 secs/8 secs 28.0 MiB
 Domain Renewal Notices
  7/24 [▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░]  29% 2 secs/7 secs 28.0 MiB
 Cancellation Requests
  8/24 [▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░]  33% 2 secs/6 secs 28.0 MiB
 Overdue Suspensions
  9/24 [▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░]  37% 6 secs/16 secs 30.0 MiB
 Overdue Terminations
 10/24 [▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░]  41% 10 secs/24 secs 30.0 MiB
 Fixed Term Terminations
 11/24 [▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░]  45% 10 secs/22 secs 30.0 MiB
 Inactive Tickets
 12/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░]  50% 10 secs/20 secs 30.0 MiB
 Delayed Affiliate Commissions
 13/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░]  54% 10 secs/18 secs 30.0 MiB
 Affiliate Reports
 14/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░]  58% 10 secs/17 secs 30.0 MiB
 Email Marketer Rules
 15/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░]  62% 10 secs/16 secs 30.0 MiB
 Credit Card Expiry Notices
 16/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░]  66% 11 secs/17 secs 30.0 MiB
 Server Usage Stats
 17/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░]  70% 11 secs/16 secs 30.0 MiB
 Overage Billing Charges
 18/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░]  75% 11 secs/15 secs 30.0 MiB
 Client Status Update
 19/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░]  79% 11 secs/14 secs 30.0 MiB
 Domain Expiry
 20/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░]  83% 11 secs/13 secs 30.0 MiB
 Ticket Escalation Rules
 21/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░]  87% 11 secs/13 secs 30.0 MiB
 Data Retention Pruning
 22/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░]  91% 11 secs/12 secs 30.0 MiB
 WHMCS Updates
 23/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░]  95% 14 secs/15 secs 40.0 MiB
 Run Jobs Queue
 24/24 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% 14 secs/14 secs 40.0 MiB


 Sending Daily Cron Digest email

Executing System Queue
----------------------

 3/4 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░]  75% < 1 sec/< 1 sec 42.0 MiB

 

On this last step my, my ssh cursor didnt reset, looks like its hanging on Executing System Queue

Link to comment
Share on other sites

Ok it completed

Executing System Queue
----------------------

 3/4 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░]  75% < 1 sec/< 1 sec 42.0 MiB

 4/4 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% 3 mins/3 mins 134.0 MiB


 [OK] Completed

Link to comment
Share on other sites

Ok so in my system activity log I have tons of these, with alternating errors

07/10/2018 05:43    Cron Job: Terminating Service - Service ID: 750 System    
07/10/2018 05:43    ERROR: Manual Terminate Required - No Module - Epic 6 - TeamSpeak - customer name (Service ID: 749 - User ID: 215) System    
07/10/2018 05:43    Cron Job: Terminating Service - Service ID: 749 System    
07/10/2018 05:43    ERROR: Manual Terminate Required - No Module - Epic 5/11 Combo - customer name (Service ID: 493 - User ID: 55)System
 

Edited by xlegends
Link to comment
Share on other sites

07/10/2018 05:43    ERROR: Manual Terminate Required - No Module - Epic 6 - TeamSpeak - customer name (Service ID: 749 - User ID: 215) System   

This error shows there is No Module, so you need to manually terminate the service, this usually occurs when you have services with not modules that you manually setup and do not automate.

On 10/07/2018 at 9:52 PM, xlegends said:

Ok it completed, so what information can we take out of this? I also noticed the failed jobs tasks have doubled now. 

This indicates its running successfully, so one thing I suggest is checking that your server confirming your server cron executes on the same user that you ran your test with

Link to comment
Share on other sites

thanks chris, I read the the docs which I should have last yr

https://docs.whmcs.com/Products_and_Services#Pricing_Tab

I had no modules in use

I never chose a module because I didnt know suspend/terminate automation required one

I used the "Auto Release" default module, worked like a charm and it took off suspending and terminating.

Only issue is, it sent out hundreds of suspend emails :( from customers who expired last yr. 

Thank god I only did it for 1 product as I did a test first. 

Thx for your help again, it should work correctly from here on out. 

Edited by xlegends
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated