WHMCS Deletion.

[netnow]

I need to be clear about:

When I use the 'Delete client" link in the WHMCS Client Summary page, does it ONLY delete WHMCS data ? i.e. does abssolutely nothing to the hosting account on the WHMCS - > WHM server?

As a side note, if anyone uses the Quickbooks plugin, does "Deleting' a client from WHMCS also so anything to the connected quickbooks account?

-H

[Kian]

"Delete Client" deletes WHMCS data leaving all products/services, domains and addons intact.

[netnow]

Under the maintenance section, I found these SQL commands. It appears to be exactly what I want to do - reset, (empty), the client database in WHMCS only, leaving all the clients in tact on the WHM servers,  maintaining all the WMHCS config settings and products.

Should be as simple as creating an sql file and running it against the WHMCS database. Has anyone tried this?

Any further tips?

"

TRUNCATE `mod_invoicedata` ;
TRUNCATE `tblaccounts` ;
TRUNCATE `tblactivitylog` ;
TRUNCATE `tblaffiliates` ;
TRUNCATE `tblaffiliatesaccounts` ;
TRUNCATE `tblaffiliateshistory` ;
TRUNCATE `tblaffiliatespending` ;
TRUNCATE `tblaffiliateswithdrawals` ;
TRUNCATE `tblbillableitems` ;
TRUNCATE `tblcancelrequests` ;
TRUNCATE `tblclients` ;
TRUNCATE `tblclientsfiles` ;
TRUNCATE `tblcontacts` ;
TRUNCATE `tblcredit` ;
TRUNCATE `tblcustomfieldsvalues` ;
TRUNCATE `tbldomains` ;
TRUNCATE `tbldomainsadditionalfields` ;
TRUNCATE `tblemails` ;
TRUNCATE `tblhosting` ;
TRUNCATE `tblhostingaddons` ;
TRUNCATE `tblhostingconfigoptions` ;
TRUNCATE `tblinvoiceitems` ;
TRUNCATE `tblinvoices` ;
TRUNCATE `tblnotes` ;
TRUNCATE `tblorders` ;
TRUNCATE `tblquotes` ;
TRUNCATE `tblquoteitems` ;
TRUNCATE `tblsslorders` ;
TRUNCATE `tblticketlog` ;
TRUNCATE `tblticketnotes` ;
TRUNCATE `tblticketreplies` ;
TRUNCATE `tbltickets` ;
TRUNCATE `tblupgrades` ;"

 

 

[Kian]

Wait. I thought you wanted to "Delete Clients". Are you sure you want to empty all the tables that contain clients data (all clients)? If so, you can run that query.

Edited July 11, 2019 by Kian

[netnow]

Yes, I want to keep WHMCS config, connections etc, but want to remove all client data, including test invoices/transactions, then, start re importing them a few at a time.

 

[WHMCS ChrisD]

Hey @netnow Deleting a client won't touch the hosting accounts on the server or domains with your registrar.

To do this en-mass please check out resetting your database at https://docs.whmcs.com/Maintenance

[netnow]

Thanks for taking the time to reply Chris ... please review my 3rd post up. I am going to give it a try. I am assuming that if I remove the connection to the WHM servers the SQL commands will still be able to complete correctly. 
The only other question I can think of is: Is the list of tables to truncated complete? (i.e. up to date with the current version of WHMCS)?