Delete all CVV Numbers At Once?

[IllusionGuy]

Hello Everyone,

Is there a way to delete all of the orders CVV numbers at once?

Not sure if their is an easy way to do this that is built in or if there is a module to do this.

Thanks guys.

[Ajeh]

Backup your database first ...

Then in the Tools ... Install SQL Patches ... you can run the SQL command for:

UPDATE orders SET cc_cvv='';

[IllusionGuy]

Backup your database first ...

Then in the Tools ... Install SQL Patches ... you can run the SQL command for:

Thanks Ajeh,

I will give that a shot.