peego Posted December 20, 2004 Posted December 20, 2004 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 Posted December 20, 2004 Posted December 20, 2004 In phpMyAdmin run this statement update orders set `cc_number` = '' where `cc_number` != '' while (!succeed) {try()}; GMT -6:00
iwik Posted December 21, 2004 Posted December 21, 2004 There is also a contribution for it which can be found here.
Rob123 Posted December 21, 2004 Posted December 21, 2004 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 Posted December 21, 2004 Author Posted December 21, 2004 just wondering, which table in the db stores the cc information? i browsed all of them and didn't seem to find it....
TomThumb Posted December 21, 2004 Posted December 21, 2004 orders while (!succeed) {try()}; GMT -6:00
Recommended Posts
Archived
This topic is now archived and is closed to further replies.