desynced Posted June 5, 2012 Share Posted June 5, 2012 We're no longer keeping credit card details on WHMCS. So we set the option not to store it. But the credit card info is still there. Is there an easy way to remove all CC details from all customers at once instead of going one by one and removing it? 0 Quote Link to comment Share on other sites More sharing options...
laszlof Posted June 5, 2012 Share Posted June 5, 2012 run the following SQL query: UPDATE tblclients SET cardtype='', cardlastfour='', cardnum='', startdate='', expdate='', issuenumber=''; If you're using a tokenized gateway, you may want to leave cardlastfour in there. 0 Quote Link to comment Share on other sites More sharing options...
desynced Posted June 6, 2012 Author Share Posted June 6, 2012 run the following SQL query: UPDATE tblclients SET cardtype='', cardlastfour='', cardnum='', startdate='', expdate='', issuenumber=''; If you're using a tokenized gateway, you may want to leave cardlastfour in there. I was thinking nulling out the tables would do it, but was making sure it didnt screw up WHMCS or I was missing a button/setting somewhere. Thanx 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.