如何从Magento中删除已完成订单的已保存信用卡号？

Question

We are using saved cc for our website.We want to flush saved credit card information of completed orders.Can anyone help to accomplish this?

Answer 1

Finally I created a custom extension to do this.Magento stores CC information in sales_flat_order_payment and sales_flat_quote_payment.I extended order grid class and added a custom action and controller.

`$updatefirsttable = "UPDATE `sales_flat_order_payment` SET `cc_number_enc` = NULL,`cc_exp_month`=NULL,`cc_exp_year`=NULL,`cc_type`=NULL WHERE `entity_id` =$transactions->entity_id";
$updatesecondtable = "UPDATE `sales_flat_quote_payment` SET `cc_number_enc` = NULL,`cc_exp_month`=NULL,`cc_exp_year`=NULL,`cc_type`=NULL WHERE `quote_id` =$transactions->quote_id";`