Where is credit card number

Credit card number has a field in the orders table. Where is it actually stored? For some reason it is not writing the cc number here. It used to write it with 8 X's in the middle. What do I need to change to get it to write the CCnumber here?

Do you have admin > modules > payment > Credit Card - Offline Processing > installed and setup?

It is not installed or even listed. Do I need to obtain it?

Why do you want to store the Card number?

Might want to look in the PCI security that became a requirement 1.1.2008...

Use a gateway.... Every merchant account provider offers access to a gateway of some type...

That's the way our internal system does it. As soon as the credit card is run, it is deleted as far as I know.

Please tell me what I need to do to get the credit card number saved in the orders table.

Thank you!

It is not installed or even listed. Do I need to obtain it?
What version of Zen Cart are you using as far back as I can recall this is built in and it splits the CC# with part being sent via email.
There is no automated way to save the complete # and if you re-code to do so you will have many hoops to jump through to be able to accept cards as the majors will shut you down if you are not compliant

benn600:

That's the way our internal system does it. As soon as the credit card is run, it is deleted as far as I know.

Please tell me what I need to do to get the credit card number saved in the orders table.

Thank you!

I does not matter how you internal system Does it, you have to be PCI compliant to store the data in any form, even if it is on your zen shopping cart.

The offline CC mod is NOT PCI Compliant, You should be using a Gateway like Authorize.net or some other Gateway to process the payments in real time from the Shopping Cart, this way your not storing the data in any form

FYI I am not going to gtell you how to store the data, because it sounds like you would do it in a unsecure manner, ID theft and CC Fraud are major problems I will not help promte that..

Okay but at least I need to restore what I had before. Now my orders table doesn't have anything in the cc_number field! Any idea what I changed? I accidentally make changes from time to time that destroy what we had...cause then I can get the middle digits from email like you suggest.

If you've made changes that have broken things, then your best solution is to look at your backups and compare things to identify what you've changed and may need to fix.

I haven't really made changes other than maybe in the admin area. Aren't there a lot of settings to control if the cc_number is stored in the database?... even just the outer 4 digits (xxxxxxxx)

So does anyone know why the cc_number might have stopped getting stored in the database? I'm not sure how it could have and have looked through the admin pages to look for an option but can't seem to find one.

Thanks!

So does anyone know why the cc_number might have stopped getting stored in the database?

It is not installed or even listed. Do I need to obtain it?
The module that is part of an install must be there and enabled.

benn600:

That's the way our internal system does it. As soon as the credit card is run, it is deleted as far as I know.

Please tell me what I need to do to get the credit card number saved in the orders table.I'm going to re-iterate what others have said as a response to your questions:

Sorry, no, we will not help you shoot yourself in the foot by storing complete credit card numbers in clear text on a database of a webserver connected to the internet.
It's foolish practice, and one could construe any assistance to help you do such a thing could be considered an accomplice in liability suits.

If you want to figure out doing coding changes on your own, feel free. Do not post any such code on this forum though.
If you don't feel comfortable doing that sort of coding yourself, you may certainly attempt to hire someone who might dare to take the risks you are requesting.

There are other ways of handling credit card details. Perhaps you should explore other ways of collecting payment, which are more secure and acceptable within the terms of merchant account agreements.

If your accounting software or accounting staff are inflexible on this issue, perhaps it's time to change something.

Do an internet search for PCI DSS standards, or telephone your merchant account bank/company and tell them what you're wanting to do, and ask their opinion. Chances are they'll shut you down in a hurry. http://www.pcicomplianceguide.org

I understand and will absolutely look at using a payment gateway. What you're saying makes perfect sense.

Now all I want to do is restore original zencart functionality that somehow I broke, likely in the admin panel. the orders table used to get populated with 1111xxxxxxxx1111 in the cc_number field. Now, I am seeing nothing get added to this field. Under payment, I have the cc item enabled and am using it. Any idea why nothing gets put here anymore?

Thanks!

If your accounting software or accounting staff are inflexible on this issue, perhaps it's time to change something.

We did. We found a way and are going to use Authorize.net. Thanks for potentially saving us from future problems.