Zen Cart Logo
Forums / General Questions / Delete all CVV Numbers At Once?

Delete all CVV Numbers At Once?

Locked

Views: 1,056

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
29 Jun 2009, 8:05 PM
#1
illusionguy avatar

illusionguy

Zen Follower

Join Date:
May 2007
Posts:
136
Plugin Contributions:
0

Delete all CVV Numbers At Once?

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.

30 Jun 2009, 4:14 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Delete all CVV Numbers At Once?

Backup your database first ...

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

UPDATE orders SET cc_cvv='';

30 Jun 2009, 6:46 PM
#3
illusionguy avatar

illusionguy

Zen Follower

Join Date:
May 2007
Posts:
136
Plugin Contributions:
0

Re: Delete all CVV Numbers At Once?

Ajeh:

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.