Need Credit Card info to show up in Admin

I am trying to process payments manually (meaning customer enters in information on website, we can look it up in the Admin, and then punch in the numbers on our merchant machine here at our business- we are not using any payment gateway online)
My question is this:
How do I get the credit card information to be saved in MySQL and then show it in the Admin?
I noticed in MySQL there is no place for that information to be stored.
On one of our other sites we have once we get the information we are able to mark it processed and the credit info is deleted.
We also have other security measures in place.

You should never store credit card info from your customers in your database, unless you have gone through the pci compliance with your database. If you do not have this compliance, it is unlawful to store credit card information in your database. Even if it weren't, its advised that you shouldn't do this.

Well aware of that, and we are PCI compliant...even have a friend who works for the FBI...so very well aware of what the law is.
The one we had set up previously stored it until we got it the next day, it then would delete the info after we got it.
Thats all I need. What other ways would you recommend I get the payment info from customer to business? Without using ANY payment gateway.
Our rate right now is untouchable by all payment gateways and we CONSTANTLY have people using stolen credit cards so we have to verify with bank etc.

The simplest way to accomplish this is to Use the Checkout wizard to create the pages. When using the checkout wizard, you will have to chose a payment gateway. Select Paypal Payments Pro US as the payment gateway. After the pages have been created, remove the PayPal Express Checkout button from the Checkout page, and remove the local Checkout server behavior from the Confirm page.

You will also have to reset the redirect to the success page. If you selected to have the order Information stored in the database, double click the Store order Details server behavior and set the redirect. If not double click the Universal Email server behavior and set the redirect to the success page.

To store the credit card information, you will need to use the session variables that are stored to send these to the payment gateway. You will have to add columns to your MySQL table to store the credit card information and then you can insert the values into the database before the redirect.

Jimmy,

Advice, please. My customer uses multiple distributors to drop-ship product. He also wants to process these cards manually because he won't know if a product is on back-order from a distributor.

Do you have any other thoughts about how to do this? If not, where do I start the Checkout Wizard from?

Thanks

You can manually get the credit card number from the user over the phone if that would work for you.

Cute...
Then where do I start creating the Checkout Wizard from?

HI Paul,

It possible to save the credit card info by making some code changes to the cart. Let me say upfront that the liability issues and laws pertaining to saving cc info outside a payment gateway make doing so the worst possible idea.

If you want to give me a call I'll be happy to talk with you about it.

Hey Les...

Good to hear from you.

I have been doing research about it all morning...and I'm going to recommend to my client that we use Authoirze.net to be their gateway to their Merchant account. I don't want them to put themselves in any precarious situations.

So all the advise has been good, and listened to.

Thanks!

To start out, running eCart, you would have to create an eCart object. Then you would have to add a cart display to your page. And then you can run the checkout wizard. There are also getting started guides in the support section of our site. Hope that helps.