We recently migrated our site from one server to another and in the process we lost all Credit Card information from transactions made previous to the migration.
Technical Support suggested to check that the encryption keys matched, which we have done and verified they are matching. I’ve wrote back to technical support and 5 days later am still waiting to hear back from them, so I come to you community; any ideas of how we can retrieve the information to make it appear like it previously was?
Thanks for your help & time in advance!
Do you have a backup of the DB or sql?
If not, there is no going back.
On a security level, I hope you aren’t keeping all CC’s from every transaction even after they are processed.
Thats a huge security risk and actually violates Visa’s rules. but thats a different topic. 
Well, we do have a backup of the database but when we sifted through it, the cc info wasn’t in there.
It at first seems like there was something missing but as you point out, it isn’t a good idea to store those anyway.
Next question: Does cs cart automatically delete them? How often?
Well through admin backend you can have the CC info removed in the order status page.
just have Remove CC info checked and it should be removed after an order has been processed.
Make sure you have remove cc info checked on all order statuses then click the update button
By default it saves them encrypted, unless you check the option to remove the CC for processed orders.
This is a manual process though.
so assuming noone here accidentally deleted those cc #'s, where does CS cart store them? I checked the user DB table and found a cc# column, but they were all blank.
They wont be blank, they should look like users password field.
a bunch of random characters.
well, they’re blank. How could that have happened?
I would install the backup of the old database and check that table to see if their blank.
If they are, then it wasnt the conversion process or anyone after, it was done prior.
Yes. I’m talking about the original table before the move. It’s empty.
Is there any other explanation aside from user boneheadedness that could explain why the original table is blank?
[quote name=‘EmeraldForest’]Yes. I’m talking about the original table before the move. It’s empty.
Is there any other explanation aside from [COLOR=“Red”]user boneheadedness[/COLOR] that could explain why the original table is blank?[/QUOTE]
…too funny (at least someone is honest enough to “own up” to possible human error)
[quote name=‘EmeraldForest’]Yes. I’m talking about the original table before the move. It’s empty.
Is there any other explanation aside from user boneheadedness that could explain why the original table is blank?[/QUOTE]
There are two possibilities that I can think of:
- In Admin->View orders, you checked off some/all orders and hit the “Remove CC Info” button below;
- in Admin->Order statuses, the “Remove CC info” checkbox is checked for Open and Processed statuses. This will remove the CC information before you manually process the order.
Bob