dbl07 Posted December 30, 2003 Share Posted December 30, 2003 I've installed MS2 and it works pretty good now. there are two things I'm having trouble with. 1. Orders are flagged as being "processed" but I have "pending" set as the default 2. I don't know where to find the credit card number when I recieve an order I've looked through the forums and docs. Perhaps I'm not looking in the correct places. Any help would be appreciated. Shaken! ... not stirred! Link to comment Share on other sites More sharing options...
strced Posted December 30, 2003 Share Posted December 30, 2003 The full credit card number is not stored in the DataBase. You can see the 4 digits on either end by using the Admin Tool, select an order and then click Edit, this will show you that the transaction was a credit card and show you 8 of the credit card numbers with the middle 8 X'd out....for example 1234 xxxx xxxx 5678 . The middle 4 are e-mailed to the address you have set up and have a subject line of "extra order info". Link to comment Share on other sites More sharing options...
dbl07 Posted December 30, 2003 Author Share Posted December 30, 2003 I have looked all over the admin tool and in particular the orders pages but I see no xxxxx I go to orders and click on edit and all it says that the method of payment is credit card but that is it. Was this taken out? There are also no numbers sent in the e-mail. It just says that the method of payment is credit card. Shaken! ... not stirred! Link to comment Share on other sites More sharing options...
tbell45219 Posted December 31, 2003 Share Posted December 31, 2003 Strange, my CC numbers are in my admin orders and I'm trying to block them out. I see the full CC in the database even though its sending me the middle digits. How can you make it not store the entire number? Link to comment Share on other sites More sharing options...
Noobish-n-stuff Posted December 31, 2003 Share Posted December 31, 2003 easiest solution?? tbell and dbl07 switch sites! am i good or what! (sorry no really help, i just had to post that for the humor) Link to comment Share on other sites More sharing options...
dbl07 Posted January 5, 2004 Author Share Posted January 5, 2004 I have no way to view credit card numbers right now. can I get this info from the database somehow? Shaken! ... not stirred! Link to comment Share on other sites More sharing options...
dbl07 Posted January 6, 2004 Author Share Posted January 6, 2004 what kind of query could I form to retreive the credit card number? Shaken! ... not stirred! Link to comment Share on other sites More sharing options...
bloodshoteyes Posted January 6, 2004 Share Posted January 6, 2004 From Admin/Customers/Orders, you'll see a list of the orders. Don't click on Edit.. Click on the logo on the left side of the line, for the order you want the CC number for..... Link to comment Share on other sites More sharing options...
dbl07 Posted January 6, 2004 Author Share Posted January 6, 2004 This just gives me the same page as if I clicked on edit. The icon that I'm clicking on is the white, paper-looking, icon directly to the left of the name of the customer. Is this correct? I still don't see a credit card number. Shaken! ... not stirred! Link to comment Share on other sites More sharing options...
gambu Posted January 7, 2004 Share Posted January 7, 2004 i can see the whole numbers of their CC too.. Link to comment Share on other sites More sharing options...
bloodshoteyes Posted January 7, 2004 Share Posted January 7, 2004 Have you loaded any contributions onto your site ?? I am running 2.2 ms2 and see them fine.... in fact short of looking into the data base it is the only way.. Link to comment Share on other sites More sharing options...
gambu Posted January 7, 2004 Share Posted January 7, 2004 i can see them completely in the admin/customers/edit (customer) how can i hide them? Link to comment Share on other sites More sharing options...
dbl07 Posted January 7, 2004 Author Share Posted January 7, 2004 I have added the featured products contribution but that should have little to do with seeing credit card numbers. I downloaded the MS2 tarball again and replaced the cc.php in /catalog/includes/modules/payment/ .... still doesn't work. It looks by the code that it sends the confirmation out with XXXXXX array('title' => MODULE_PAYMENT_CC_TEXT_CREDIT_CARD_NUMBER, 'field' => substr($this->cc_card_number, 0, 4) . str_repeat('X', (strlen($this->cc_card_number) - 8)) . substr($this->cc_card_number, -4)), Should I be able to see the text for the credit card number in the database? All of the fields for cc_number, etc are blank in the database. This leads me to believe there is something that is malfunctioning when the number get input (...not the admin side). Comments? Shaken! ... not stirred! Link to comment Share on other sites More sharing options...
♥Vger Posted January 7, 2004 Share Posted January 7, 2004 Strange, my CC numbers are in my admin orders and I'm trying to block them out. I see the full CC in the database even though its sending me the middle digits. How can you make it not store the entire number? This applies to both postings, with and without credit card numbers showing. When you set up the module for the method of payment, in this case credit cards, when you click on Edit you are given the option of 'Splits'. If you input your e-mail address into here then only the first and last sections of the credit card numbers appear in the order confirmation to you, the middle section is e-mailed to the e-mail address you've specified. Hope this helps - Vger Link to comment Share on other sites More sharing options...
dbl07 Posted January 7, 2004 Author Share Posted January 7, 2004 I have tried both of these methods (split and not split) and neither of them work. Should I be able to see something in the database (i.e. cc_number, etc)? Shaken! ... not stirred! Link to comment Share on other sites More sharing options...
bloodshoteyes Posted January 8, 2004 Share Posted January 8, 2004 Are you using a particular gateway??? When you look at your orders in your data base are the cc numbers present? Check your database to make sure you do not have multiple entries listed for CCnumber and CCexpire date. Link to comment Share on other sites More sharing options...
jdfitch Posted January 8, 2004 Share Posted January 8, 2004 I am using linkpoint gateway. None of the credit card info is being saved in the database at all. I had not paid attention to that before now. I get an email with the middle 8 and the extra order info (avs return codes and what not) but no cc_number, or cc_type or cc_owner info is being saved at all. Never has. Hmmmm OH BTW, all info is handed off and processed by linkpoint. My credit card transactions get processed fine. If you choose not to decide you still have made a choice, I will choose a purpose clear, I will choose Free Will. --Neal Peart - Rush Link to comment Share on other sites More sharing options...
dbl07 Posted January 9, 2004 Author Share Posted January 9, 2004 I don't quite understand what a gateway is in this scenario... could you explain further what you mean? When I use phpMyadmin to look at the orders table I can see columns for cc_type, cc_owner, cc_number, and cc_expires. none of these columns have values for any of the orders in my database. This is a problem, no? Shaken! ... not stirred! Link to comment Share on other sites More sharing options...
Guest Posted January 9, 2004 Share Posted January 9, 2004 If you are using authorize net that module doesnt not enter the CC Info into the database Link to comment Share on other sites More sharing options...
Guest Posted January 9, 2004 Share Posted January 9, 2004 ooops on the double negative ^^ sorry Also if you are using authorize net make sure to check their terms of use, I believe it is now against their terms to store cc #s anywhere whether it be a filling cabinet or a database... that is just what I have been told. Link to comment Share on other sites More sharing options...
jdfitch Posted January 10, 2004 Share Posted January 10, 2004 Visa, MC, Disc, & Amex all require you to keep a sales draft showing atleast the last four digits of a card number, card holders name. You are supposed to keep this on record for 3 years. That being the limit of dispute time allowed by law. If you don't keep a record of card holder and card. You can be liable in the event of a dispute and charge back. If you choose not to decide you still have made a choice, I will choose a purpose clear, I will choose Free Will. --Neal Peart - Rush Link to comment Share on other sites More sharing options...
dbl07 Posted January 18, 2004 Author Share Posted January 18, 2004 I am using the CC module. Not Authorize.net Is this module supposed to put the CC number in the DB? Shaken! ... not stirred! Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2004 Share Posted January 18, 2004 yea,,, you should have something in the database,,, I cant answer why it is not there. I may have missed this but do you have any information in the email you recive for the order?. Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2004 Share Posted January 18, 2004 In the My Sql database you will see the numbers, also in the email of the order confirmation you will see the numbers. Link to comment Share on other sites More sharing options...
dbl07 Posted January 22, 2004 Author Share Posted January 22, 2004 Hmmmmm...strange. I don't see information in the e-mail or in the database. Does anybody have an explanation for this? - I am using MS2.2. - I have tried re-installing the cc module to no avail Shaken! ... not stirred! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.