Delete CVV from database

[lynbor]

zv 1.3.8a

I was wondering if there is a way to remove CVV numbers from the database in a more global fashion. I recently took over managing a zen store and there are hundreds of sales that still have the CVV number stored. I'd like to delete all those whos status is "delivered (4)" or something like that.

Right now it looks like the only option I have is to open each and every order individually to click on the delete CVV link.

If no other way, can someone direct me in using phpmyadmin perhaps? I just have to believe there is a way that would be faster than editing every order.

Any help or suggestions would be welcomed.

Thanks.

[Ajeh]

You could run the SQL command:

UPDATE orders SET cc_cvv ='';

NOTE: Always first backup your database before making changes like this ...

[Merlinpa1969]

will that only update orders that are set to delivered or will that delete them all

[Ajeh]

Good point that is for ALL orders ... to restrict them for those that are delivered us:

UPDATE orders SET cc_cvv ='' WHERE orders_status = 4;

where the Delivered orders_status is 4 ...

NOTE: be sure to check the orders_status value to be removed ...

[lynbor]

Thanks Ajeh!

As always, your answer to my question has saved me from arduous and tedious work. You're the best!

[Ajeh]

Thanks for the update that this was able to help you ...