How do I wipe out Credit card info.

[peego]

Hi,

 

OScommerce stores the credit card number and expiry date for all the customers.

 

I would like to do periodic wipeouts of these credit card numbers for saftey reasons (i am using https) but i prefer not to store customer billing info for too long.

 

How do I go about clearing out the credit card information for my customers?

 

thanks,

 

Jim

[TomThumb]

In phpMyAdmin run this statement

 

update orders set `cc_number` = '' where `cc_number` != ''

[iwik]

There is also a contribution for it which can be found here.

[Rob123]

I would run the following to delete the cc_numbers for orders that have been shipped...

update orders set `cc_number` = '', `cc_expires` = '' where `cc_number` != '' and orders_status = '3';

HTH,

Robert

[peego]

just wondering, which table in the db stores the cc information? i browsed all of them and didn't seem to find it....

[TomThumb]

orders