delete all credit information

[sgrayban]

Is there a way to delete all credit card information that is stored ?

[sentq]

delete it from WHMCS Database? if so you can run one SQL query to delete all that information from specific client account, or all

[sgrayban]

What is the SQL line ?

[sentq]

UPDATE `tblclients` SET `cardtype` = '', `cardlastfour` = '', `cardnum` = '', `startdate` = '', `expdate` = '', `issuenumber` = '' WHERE `id` = '{Client-ID-Here}';

this will delete the CC information from specific client account (replace {Client-ID-Here} with your client ID), use the one below to delete these information from all accounts

 

UPDATE `tblclients` SET `cardtype` = '', `cardlastfour` = '', `cardnum` = '', `startdate` = '', `expdate` = '', `issuenumber` = '';

 

please take database backup before run any of these queries in case you changed your mind later

[sgrayban]

Cool thank you !!!

[WHMCS ChrisD]

You can also tick the Disable Local Storage box under Setup -> General Settings -> Security -> Disable Credit Card Storage

[sgrayban]

I was wondering if that would work.