How Do I Access The Customer's Credit Card Info?

[Guest]

Previous orders placed in my store would show the customer's full information and credit card number in the admin page so that we could charge it manually. but the most recent orders show only part of the number - e.g. 1234xxxxxx4321. where can i view the full number? and why is it doing this all of a sudden?

[dropdeadred]

Likely you are not logged in or are somehow not viewing the admin pages through the secure method.

 

The full number should still be in your database, which you can access through your host and phpmyadmin or similar.

[Guest]

Likely you are not logged in or are somehow not viewing the admin pages through the secure method.

 

The full number should still be in your database, which you can access through your host and phpmyadmin or similar.

 

 

I am logged in to my admin page.. when i view old orders, i can view the full credit card number. those were all from january and earlier. but 3 new orders have been placed in the past couple weeks, and only those have the number blocked with x's.

is there anywhere else this info is stored??

[Guest]

Likely you are not logged in or are somehow not viewing the admin pages through the secure method.

 

The full number should still be in your database, which you can access through your host and phpmyadmin or similar.

 

 

and if i were to look in phpmyAdmin, where would I find this info? I have never used this before - previously I had only gotten this information through my host's admin panel.

[Guest]

Likely you are not logged in or are somehow not viewing the admin pages through the secure method.

 

The full number should still be in your database, which you can access through your host and phpmyadmin or similar.

 

 

(i don't know if I am looking in the right place but) in phpmyAdmin, those same credit card numbers are still not visible - they displaying as x's here as well....

 

please help!!!

[rrrhythm]

Previous orders placed in my store would show the customer's full information and credit card number in the admin page so that we could charge it manually. but the most recent orders show only part of the number - e.g. 1234xxxxxx4321. where can i view the full number? and why is it doing this all of a sudden?

 

i don't think the previous posts are correct, and i don't think you'll find the full numbers in the database.

 

osC has a thing where instead of storing the full number (which is a bad idea, see numerous thread on the topic), it takes out the middle 8 digits, stores the first/last four, and e-mails you the middle 8 digits the idea being that you can combine what's in the DB/Admin order with what's in the email, to have the full CC number to run it manually, but you're not storing customers CC numbers, which is something you want to avoid.

 

this feature is set in the admin.

 

go to: Admin->Modules->Payment->Visa or Mastercard. when you click on that you should see a spot for "Split Credit Card E-Mail Address" in the side bar, and that is where it is emailing the middle 8 digits.

 

to turn that off (and store the full card # in your database, which is a bad idea), click "edit" and make sure that email address is blank. i believe it will then store the full number in your db.

 

but you really shouldn't do that. you should instead make sure that the email address is set to your address, then you can put the whole CC number together without storing it in your DB. again, do a search on the forums and you'll find many threads on the topic of "storing credit card numbers".

 

cheers,

rj

[Guest]

Ooookay that would explain a lot, thank you.

problem with that is, there was a problem with the contact address so i did not receive those orders in an email. so if i do the database method temporarily, will the database then display those numbers from orders already placed?

or is it too late for that?

if not i would assume i'd just have to cancel the orders and ask them to put it in again? but i'd rather it not come to that...

 

 

 

i don't think the previous posts are correct, and i don't think you'll find the full numbers in the database.

 

osC has a thing where instead of storing the full number (which is a bad idea, see numerous thread on the topic), it takes out the middle 8 digits, stores the first/last four, and e-mails you the middle 8 digits the idea being that you can combine what's in the DB/Admin order with what's in the email, to have the full CC number to run it manually, but you're not storing customers CC numbers, which is something you want to avoid.

 

this feature is set in the admin.

 

go to: Admin->Modules->Payment->Visa or Mastercard. when you click on that you should see a spot for "Split Credit Card E-Mail Address" in the side bar, and that is where it is emailing the middle 8 digits.

 

to turn that off (and store the full card # in your database, which is a bad idea), click "edit" and make sure that email address is blank. i believe it will then store the full number in your db.

 

but you really shouldn't do that. you should instead make sure that the email address is set to your address, then you can put the whole CC number together without storing it in your DB. again, do a search on the forums and you'll find many threads on the topic of "storing credit card numbers".

 

cheers,

rj

[rrrhythm]

Ooookay that would explain a lot, thank you.

problem with that is, there was a problem with the contact address so i did not receive those orders in an email. so if i do the database method temporarily, will the database then display those numbers from orders already placed?

or is it too late for that?

if not i would assume i'd just have to cancel the orders and ask them to put it in again? but i'd rather it not come to that...

 

sorry, but i think it's too late, and those numbers from any orders already placed are gone, as you've probably figured out by now. they'll be stored in the DB with xxxx-xxxx in the middle, and no way to recover them.

 

you could email/call the customers and explain that there was a problem with their order and you didn't get their correct CC number and ask them to call you with the number again, or if they prefer they could just re-order via the website.

 

good luck,

rj

[Guest]

Or you can just call them and say that you called to verify there order and the credit card number for fraud prevention purposes.

[rekluse]

i don't think the previous posts are correct, and i don't think you'll find the full numbers in the database.

 

osC has a thing where instead of storing the full number (which is a bad idea, see numerous thread on the topic), it takes out the middle 8 digits, stores the first/last four, and e-mails you the middle 8 digits the idea being that you can combine what's in the DB/Admin order with what's in the email, to have the full CC number to run it manually, but you're not storing customers CC numbers, which is something you want to avoid.

 

this feature is set in the admin.

 

go to: Admin->Modules->Payment->Visa or Mastercard. when you click on that you should see a spot for "Split Credit Card E-Mail Address" in the side bar, and that is where it is emailing the middle 8 digits.

 

to turn that off (and store the full card # in your database, which is a bad idea), click "edit" and make sure that email address is blank. i believe it will then store the full number in your db.

 

but you really shouldn't do that. you should instead make sure that the email address is set to your address, then you can put the whole CC number together without storing it in your DB. again, do a search on the forums and you'll find many threads on the topic of "storing credit card numbers".

 

cheers,

rj

 

Excellent explanation.

 

Just so I'm understanding correctly. The scenario is this:

1. customer enters order w/ cc info
   
2. cc number is split; half goes to the e-mail I specify in Split Credit Card E-Mail Address and the other half is accessible through my admin control panel
   
3. I combine these two numbers to process order
   

Is the expiration date and CVV code included in the e-mail or accessible via the admin control panel?