Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do I wipe out Credit card info.


peego

Recommended Posts

Posted

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

Posted

In phpMyAdmin run this statement

 

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

while (!succeed) {try()};

 

GMT -6:00

Posted

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

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...