peego Posted December 20, 2004 Share 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 Link to comment Share on other sites More sharing options...
TomThumb Posted December 20, 2004 Share Posted December 20, 2004 In phpMyAdmin run this statement update orders set `cc_number` = '' where `cc_number` != '' while (!succeed) {try()}; GMT -6:00 Link to comment Share on other sites More sharing options...
iwik Posted December 21, 2004 Share Posted December 21, 2004 There is also a contribution for it which can be found here. Link to comment Share on other sites More sharing options...
Rob123 Posted December 21, 2004 Share 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 Link to comment Share on other sites More sharing options...
peego Posted December 21, 2004 Author Share 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.... Link to comment Share on other sites More sharing options...
TomThumb Posted December 21, 2004 Share Posted December 21, 2004 orders while (!succeed) {try()}; GMT -6:00 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.