can I delete credit card numbers from orders without deleting the order itself??

[mohawk]

Hi guys,

Since our online orders are all processed by realex payments and we dont store cc numbers now I need to do a bit of housekeeping by deleting cc numbers for hundreds of orders over 2007-2008 period

Does anyone reading this know how I might approach this task

Thank you

[michael_s]

Use phpmyadmin to navigate your database, and go to the field in the orders table (I think) that stores the credit card numbers and simply empty it of all records.

Before doing any database level operations like this, it is always prudent to first make a complete backup.