Middle Credit Card Numbers

[monkeyman]

How do I get to the middle credit card number info for orders through my sql database? I am using the "Credit Card Module" but am finding that one out of every ten orders-or-so aren't coming through to me in my email as "Extra Order Info" as they should. I need to be able to go into my data and just get these numbers for these spotty incidences. Otherwise I have to phone the customer for their numbers which sometimes creeps them out! Please assist asap!!

[monkeyman]

How do I get to the middle credit card number info for orders through my sql database? I am using the "Credit Card Module" but am finding that one out of every ten orders-or-so aren't coming through to me in my email as "Extra Order Info" as they should. I need to be able to go into my data and just get these numbers for these spotty incidences. Otherwise I have to phone the customer for their numbers which sometimes creeps them out! Please assist asap!!

Does anyone know the answer to this problem?

[Guest]

with the default osc cc module the cc number is available when you click orders. But if you are using something else to strip the cc info for security (like a contribution) it may not be retrievable from the database. In this later case it is only the email that you can rely on.

[monkeyman]

with the default osc cc module the cc number is available when you click orders. But if you are using something else to strip the cc info for security (like a contribution) it may not be retrievable from the database. In this later case it is only the email that you can rely on.

When I go into the "Orders" section of osc, it shows (on each individual order) the credit card number, but with the middle six or eight digits as "XXXXXXX", since the credit card module forwards them to me in email automatically. It is this action that appears to be spotty...how can I retrieve these numbers within the database that are normally separated out for email?

[Guest]

you cannot. If it shows xxxxx in the osc admin order, most likely you use a module that strips the middle numbers for security purposes. So these numbers aren't stored.

[monkeyman]

you cannot. If it shows xxxxx in the osc admin order, most likely you use a module that strips the middle numbers for security purposes. So these numbers aren't stored.

Thanks for the help.

[Guest]

ok, forgot to mention I've seen at least one module in the contributions that strips the middle digits and is controlled by the store owner. You should check if you have an option with the existing modules in your store (just in case) that changes this mode of operation.

[monkeyman]

ok, forgot to mention I've seen at least one module in the contributions that strips the middle digits and is controlled by the store owner. You should check if you have an option with the existing modules in your store (just in case) that changes this mode of operation.

I tried something different which I will relate, if it will help anyone else out with this problem. I approached it through the mailbox settings of the server that hosts my site (the mailbox which relays the middle digits to me in my regular email) and removed the level of spam-guard that was on it. It seems that the "extra order info" messages with the middle numbers were sometimes being called spam. So far...there have been some orders coming through and I have not had a repeat of the problem. Knock on wood!