PopTheTop Posted November 2, 2004 Share Posted November 2, 2004 ----------------------------------------------------- ONLINE ECHECK PAYMENT MODULE Accept eCheck Payments v2.0 Require: MS1 or osC v2.2 MS2 Download from: http://www.oscommerce.com/community/contributions,2557 ----------------------------------------------------- SCREENSHOT INCLUDED! This will allow you to be able to accept online eCheck payments by phone, fax or e-mail. Using software like eChex 2000 (available from http://www.cardhost.com/files/eChex2000.zip), you simply input your customers banking account info into eChex 2000 and print a check draft ready for deposit. No signature is ever required on any bank draft. You deposit them just like any other check and ALL US banks accept them. NOTE: This payment module is for US Bank Account Holders only. Backup your files and database! EASY installation, just copy 2 files to your server and modify the files as instructed below. Then activate it in Admin / Modules / Payment. Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
helply1 Posted November 9, 2004 Share Posted November 9, 2004 Anyone using this? I keep getting a database error. Feedback please Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted November 10, 2004 Author Share Posted November 10, 2004 No one can help unless you explain what your problem is. A database error tells us nothing. When and where does the error show and what is the exact database error you are getting? Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted November 10, 2004 Author Share Posted November 10, 2004 1) Did you follow through on ALL installation steps in the README.TXT file? 2) Did you activate that payment module in your Admin? 3) Did you set ALL the settings in that payment modukle through your Admin after you installed it? 4) Did you upload both files to the correct folders on your server? 5) What version of osC are you running? 6) What is the error you are getting? 7) When does the error show up? It was built for version 2.2 MS2 but it may work just fine on other versions. Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted November 10, 2004 Author Share Posted November 10, 2004 Accept eCheck Payments Module Version: 2.1 - FULL Package Just Released! NO BUG FIXES (as far as I know, their are no bugs), just updated... UPDATED: Nov 9, 2004 Added into the moc check on the Admin Order Details page the store name as the "Pay to the Order of" Added into the moc check on the Admin Order Details page the order grand total just like you see on a real check - Thanks to CatDadRick! Moved some of the hard coded wording into the orders.php language file. Supplied the Advmicr.ttf MICR font file for you to install into your Windows/Font folder so that the numbers and symbols on the moc check in the Admin Order Details page would resemble a true check. Updated the screen shot, now it's a full-screen PDF file. You must use Adobe Acrobat Reader to view it. The original JPG screen shot only showed part of the Admin Order Details page. Click HERE to get the new update Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted November 10, 2004 Author Share Posted November 10, 2004 Accept eCheck Payments v2.1 PLEASE NOTE: The new font file that I have included with the v2.1 package is not to be added to your server online. I am giving you a copy so that you may be able to install it into your Windows/Fonts folder on YOUR OWN computer. With this new font, you will be able to view the mock check on the Order Details page correctly. Without this font, the check symbols at the bottom will not be displayed. All you will see is the letter A and C in place of the cool symbols. Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
helply1 Posted November 11, 2004 Share Posted November 11, 2004 My error comes at the end of the checkout procedure the error is a sql error 1054 - Unknown column 'accountholder' in 'field list' . The code is asking to store information about the check in the database but I dont have the fields it is asking to use. That was the reason for my question about database config. Ill go back through everything with a fine tooth comb and see where i screwed it up upon install, but until I get those fields, accountholder, bank, routing number, etc added to my database, it would seem reasonable to assume that it will never work as those fields being requested dont exist. Are these fields being added through the code somehow and thus a formal sql update file is not needed? Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted November 11, 2004 Author Share Posted November 11, 2004 (edited) My error comes at the end of the checkout procedure the error is a SQL error 1054 - Unknown column 'accountholder' in 'field list'. The code is asking to store information about the check in the database but I don't have the fields it is asking to use. That was the reason for my question about database config. Ill go back through everything with a fine tooth comb and see where i screwed it up upon install, but until I get those fields, accountholder, bank, routing number, etc added to my database, it would seem reasonable to assume that it will never work as those fields being requested don't exist. Are these fields being added through the code somehow and thus a formal SQL update file is not needed? The SQL entries are added automatically when you install the payment module. If you open up echeck.php and look at line 217, you will see the following... ? ?function install() { ? ? ?tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Online eChecks', 'MODULE_PAYMENT_ECHECK_STATUS', 'True', 'Do you want to accept online eChecks?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"); ? ? ?tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('E-Mail Address', 'MODULE_PAYMENT_ECHECK_EMAIL', '', 'Enter your e-mail address where you want to receive eCheck Payment information', '6', '0', now())"); ? ? ?tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort order of display.', 'MODULE_PAYMENT_ECHECK_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0' , now())"); ? ? ?tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Payment Zone', 'MODULE_PAYMENT_ECHECK_ZONE', '0', 'Enable this payment method for a particular zone. Please note, this payment module does not work with zones so do not choose one at this time.', '6', '2', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())"); ? ? ?tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) values ('Set Order Status', 'MODULE_PAYMENT_ECHECK_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', '6', '0', 'tep_cfg_pull_down_order_statuses(', 'tep_get_order_status_name', now())"); ? ? ?tep_db_query("ALTER TABLE " . TABLE_ORDERS . " ADD (accountholder VARCHAR(64), address VARCHAR(64), address2 VARCHAR(64), phone VARCHAR(32), bank VARCHAR(64), bankcity VARCHAR(64), bankphone VARCHAR(64), checknumber VARCHAR(10), accountnumber VARCHAR(32), routingnumber VARCHAR(15))"); ? ?} The tep_db_query("ALTER TABLE " . TABLE_ORDERS . " ADD... line is where the fields get added into the database. It seems that for some reason, they are not getting added. Try uninstalling it through Admin and then installing it again. If that does not work, then try uninstalling it again and then re-upload echeck.php and installing it once more. Be certain you have the latest version from HERE. Also, take look at your database through phpMyAdmin. Once loaded up... 1) Choose your database in the pull-down menu on the top left of phpMyAdmin. 2) Click on orders on the left in the list of tables. 3) On the right side, scroll down to the bottom of the list. You should see all the eCheck field data there. If not, then there is something else wrong, not with the contribution, but something else either in your cart or database that is keeping the SQL entries from being entered into your cart. You can also try inserting the SQL entries into your database manually by... 1) Choose your database in the pull-down menu on the top left of phpMyAdmin. 2) Click on the database name on the left just above the list of tables. 3) Click on the SQL tab on the right side of the screen. 4) Enter the following into the form text area: ALTER TABLE orders ADD (accountholder VARCHAR(64), address VARCHAR(64), address2 VARCHAR(64), phone VARCHAR(32), bank VARCHAR(64), bankcity VARCHAR(64), bankphone VARCHAR(64), checknumber VARCHAR(10), accountnumber VARCHAR(32), routingnumber VARCHAR(15)); 5) Click on the Go button and you are done. Let me know if this helps you... Edited November 11, 2004 by PopTheTop Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
helply1 Posted November 12, 2004 Share Posted November 12, 2004 Works great now, must have been my issue somewhere in the install. thanks for your support keep up the good work. Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted November 24, 2004 Author Share Posted November 24, 2004 I am looking into adding a new feature, hopefully this week. I want to hide the eCheck fields (will work for credit card payment fields too) so the customer will not see them unless they click on that payment option. When they do click on it, it will then drop down all the payment fill-in fields for that payment option. It will work similar to this forum. When you click on the FAST REPLY button, it drops down the hidden form to enter your reply. Same goes for the OPTIONS button here as well. Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted November 24, 2004 Author Share Posted November 24, 2004 UPDATE... Ok, I got the JavaScript code and most of the HTML code. I will begin working on this later tonight to integrate it into osC for the credit card and eCheck payment modules. Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted November 24, 2004 Author Share Posted November 24, 2004 Well, the way the shopping cart is made, I find it very hard to do because I am still learning as I go. If someone who knows a bit more can help, it would be greatly appreciated. This is what I have so far... Add this to checkout_payment.php just under <link rel="stylesheet" type="text/css" href="stylesheet.css"> <!-- START Paymeny Field Popup MOD --> <script type="text/javascript" src='payment_field_popup.js'></script> <!-- END Paymeny Field Popup MOD --> That will call on the java script to do what we want to do. Now, here is where I am stuck... I can not figure out how to get it into the cart in order for it to call the java script functions for it to work when you click on the payment radio buttons. I am guessing it should be added to checkout_payment.php somewhere around the lines below... <?php if ( ($selection[$i]['id'] == $payment) || ($n == 1) ) { echo ' <tr id="defaultSelected" class="moduleRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, ' . $radio_buttons . ')">' . "\n"; } else { echo ' <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, ' . $radio_buttons . ')">' . "\n"; } ?> But as you can see, there is currently a onclick=... already there so maybe somehow changing the onClick command or adding something like the onSelect command IF payment option = eCheck or Credit Card. The actual java script command that needs to be called is this: javascript:ShowHide('fields_open','fields_closed'); like this: onclick="javascript:ShowHide('fields_open','fields_closed');" or like this: onselect="javascript:ShowHide('fields_open','fields_closed');" Then you need to add a bit of HTML code so that it knows what to popup like this: <div id="fields_open" style="display: none; position: relative;"> <table border="0" cellspacing="0" cellpadding="2"> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main">Account Holder: </td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main"><input type="text" name="accountholder" value="Ginny Moore"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> </tr> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main">Account Address: </td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main"><input type="text" name="address" value="13 Algonquin Circle"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> </tr> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main">City, State & Zip: </td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main"><input type="text" name="address2" value="Hillsboro, Missouri 63050"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> </tr> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main">Phone Number: </td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main"><input type="text" name="phone"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> </tr> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main">Bank Name: </td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main"><input type="text" name="bank"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> </tr> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main">Bank's City & State: </td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main"><input type="text" name="bankcity"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> </tr> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main">Bank's Phone Number: </td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main"><input type="text" name="bankphone"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> </tr> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main">Check Number: </td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main"><input type="text" name="checknumber"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> </tr> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main">Account Number: </td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main"><input type="text" name="accountnumber"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> </tr> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main">9 Digit Routing Number: </td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> <td class="main"><input type="text" name="routingnumber"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="1"></td> </tr> </table> </div> Ok, I think that I have explained it well enough. If you can help with this great addition, please... OH PLEASE DO. You can get a copy of the java script file from HERE (you may need to right-click and choose save) Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted November 26, 2004 Author Share Posted November 26, 2004 I got bored sitting around waiting and since no one has tried to help, I decided to tackle this on my own. It still does not work correctly unless the only payment option you have installed is Credit Card or eCheck, but it is a great start. As of now, when you click on the radio button of ANY payment option, the form fields are displayed. I need to somehow set the <DIV... tag to call the correct payment chosen. This is what I came up with so far... 1) Get a copy of the Java script file from HERE (you may need to right-click and choose save) 2) Upload payment_field_popup.js to catalog/payment_field_popup.js 3) OPEN catalog/checkout_payment.php Look for: <link rel="stylesheet" type="text/css" href="stylesheet.css"> ADD this line just below that: <script type="text/javascript" src='payment_field_popup.js'></script> 4) Look for: <?php if ( ($selection[$i]['id'] == $payment) || ($n == 1) ) { echo ' <tr id="defaultSelected" class="moduleRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, ' . $radio_buttons . ')">' . "\n"; } else { echo ' <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, ' . $radio_buttons . ')">' . "\n"; } ?> REPLACE it with this: <?php if ( ($selection[$i]['id'] == $payment) || ($n == 1) ) { echo ' <tr id="defaultSelected" class="moduleRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, ' . $radio_buttons . ')">' . "\n"; } else { // echo ' <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, ' . $radio_buttons . ')">' . "\n"; echo ' <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">' . "\n"; } ?> With that change, the radio button is no longer checked when you click on the highlighted payment row. Now you have to manually click on the actual radio button yourself. The payment row is still highlighted though. 5) Look for: <?php if (sizeof($selection) > 1) { echo tep_draw_radio_field('payment', $selection[$i]['id']); } else { echo tep_draw_hidden_field('payment', $selection[$i]['id']); } ?> REPLACE it with this: <?php if (sizeof($selection) > 1) { echo tep_draw_radio_field('payment', $selection[$i]['id'], '', 'onClick="javascript:ShowHide(\'fields_open\',\'fields_closed\');"'); } else { echo tep_draw_hidden_field('payment', $selection[$i]['id']); } ?> That will call the script when you click on the radio button - no form fields will be displayed on the page until the radio button is clicked. When clicked, the payment form fields will be displayed instantly WITHOUT reloading the page. 6) Look for: <?php } elseif (isset($selection[$i]['fields']) && is_array($selection[$i]['fields'])) { ?> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td colspan="4"><table border="0" cellspacing="0" cellpadding="2"> REPLACE with: <?php } elseif (isset($selection[$i]['fields']) && is_array($selection[$i]['fields'])) { ?> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td colspan="4"><div id="fields_open" style="display: none; position: relative;"><table border="0" cellspacing="0" cellpadding="2"> Look for: <td class="main"><?php echo $selection[$i]['fields'][$j]['field']; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> <?php } ?> </table></td> REPLACE with: <td class="main"><?php echo $selection[$i]['fields'][$j]['field']; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> <?php } ?> </table></div></td> As you can see, I added <div id="fields_open" style="display: none; position: relative;">. This will cause the form fields to hide until the radio button is clicked. At that time, the form fields will be displayed without reloading your page. Ok... That is what I came up with so far. The <DIV> tag has an ID that is called from the radio button itself. This way, you can have multiple hidden <DIV> sections and they only get displayed when called. As of now, the ID is id="fields_open" and that is the problem. I need to somehow have checkout_payment.php add in the ID (for every <DIV> tag) the payment option. Example: id="fields_open_echeck" (for eCheck) id="fields_open_cc" (for Credit Card) id="fields_open_pm2checkout" (for 2CheckOut) id="fields_open_authorizenet" (for AuthorizeNet) ...and so on. I will post any more updates as I con't to work on this. In the meantime... If anyone can help, please add your input. When finished, I will add this to the eCheck Payment Module contribution AND post a new contribution just for this new addition because it will work for ALL payment modules you have installed that has their own form fields to fill in. Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted November 26, 2004 Author Share Posted November 26, 2004 I think that I have it now!!!!!!!! So far it is working great!!!!!!!! i will post it as soon as I test it further... YIPEEEEEEEEEEEEE! Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted November 26, 2004 Author Share Posted November 26, 2004 Whew, done! You asked for it and it shall be delivered! I just uploaded the new update to the eCheck Payment Module contribution. You may get it HERE If you are updating from v2.1, you only need to do Step 8 Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
ChrisW123 Posted November 27, 2004 Share Posted November 27, 2004 Do you get many customers using this payment method? Why wouldn't they just use a credit card? I don't know if I would want to send my bank info to an online store. What prevents the store owner from printing out 100 checks and cashing them all once they have your bank info? Do banks really accept a check printed on your printer? Seems like you'd get some raised eyebrows from the teller. :) Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted November 27, 2004 Author Share Posted November 27, 2004 Yes, we really do. I can also offer to our customers call-in order, paid by check or faxed orders paid by check with this. There are still a lot of people who pay using their checking accounts and love the instant check payment without having to send it in the mail and wait for it to arrive before you can ship. Yes, a dishonest store owner can print 100 checks off the customer's checking account, but without prior authorization like their actual online order, the deposited checks will be no good and bounce if the customer reports them to their bank. The online order form that you get from your customer IS their authorization and that protects you from them coming back later stating they never authorized you to print the check for their order. Yes, banks do accept them because they are not really checks, they are deposit drafts - same thing as a check but no signature is allowed. Billing companies like your utilities and bank loans can also be paid the same way when you call them by phone, they draw a checking deposit draft from your bank account in the very same manner. I will admit that new tellers sometimes question them, but after having it looked over by a manager, there is NEVER a problem at all. Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
ChrisW123 Posted November 27, 2004 Share Posted November 27, 2004 Hmm, maybe I'll add this to my website then. Sounds like it's a good payment option to have. Thanks for the info! Quote Link to comment Share on other sites More sharing options...
dsatchell Posted November 28, 2004 Share Posted November 28, 2004 I found that I had to run a command on the database to get this to work correctly. I think you have the HTTP_REFERER contribution installed and that added some code to one of the queries so I had to run ALTER table orders add customers_referer_url varchar(255). It seems to run but in the PDF file that you included in the zip, you have a simulation of the check. You mentioned in a PM to me that No, that is what you will see when a customer chooses eCheck as their payment option AND you clicked on PREVIEW in Admin to open the Order Preview screen. but I don't see a preview button. I can click on Edit, click on Invoice, click on Packing Slip, and click on the line. When I click on the line or on Edit I get a screen like yours but without the check showing and no Referer Line. Since I'm not getting an error I'm not sure where to start. I you want I can upload all of the files I edited to a site of mine? Thanx, Dave. Quote Link to comment Share on other sites More sharing options...
dsatchell Posted November 28, 2004 Share Posted November 28, 2004 PLEASE IGNORE THE PREVIOUS POST, I CLICKED ON SEND BEFORE I WAS READY. I found that I had to run a command on the database to get this to work correctly. I think you have the HTTP_REFERER contribution installed and that added some code to one of the queries so I had to run ALTER table orders add customers_referer_url varchar(255). In the INSTALL.TXT file under step 5 you have Open catalog\admin\includes\classes\order.php Look for: function query($order_id) { $order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified, customers_referer_url from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); $order = tep_db_fetch_array($order_query); REPLACE with: function query($order_id) { $order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, accountholder, address, address2, phone, bank, bankcity, bankphone, checknumber, accountnumber, routingnumber, currency, currency_value, date_purchased, orders_status, last_modified, customers_referer_url from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); $order = tep_db_fetch_array($order_query); and in both cases you have have near the end customers_referer_url but in the original file it doesn't have that part. I was going to install that contribution anyways. Now for my other issue: It seems to run but in the PDF file that you included in the zip, you have a simulation of the check. You mentioned in a PM to me that No, that is what you will see when a customer chooses eCheck as their payment option AND you clicked on PREVIEW in Admin to open the Order Preview screen. but I don't see a preview button. I can click on Edit, click on Invoice, click on Packing Slip, and click on the line. When I click on the line or on Edit I get a screen like yours but without the check showing and no Referer Line. Since I'm not getting an error I'm not sure where to start. I you want I can upload all of the files I edited to a site of mine? Thanx, Dave. Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted November 28, 2004 Author Share Posted November 28, 2004 (edited) I found that I had to run a command on the database to get this to work correctly. I think you have the HTTP_REFERER contribution installed and that added some code to one of the queries so I had to run ALTER table orders add customers_referer_url varchar(255). In the INSTALL.TXT file under step 5 you have and in both cases you have have near the end customers_referer_url but in the original file it doesn't have that part. I was going to install that contribution anyways. This has been updated (in your honor) and you may download version 3.1 in the contributions area HERE The query for customers_referer_url in both places under STEP 5 has been removed. Now for my other issue:It seems to run but in the PDF screen shot file that you included in the zip, you have a simulation of the check. You mentioned in a PM to me that? but I don't see a preview button. I can click on Edit, click on Invoice, click on Packing Slip, and click on the line. When I click on the line or on Edit I get a screen like yours but without the check showing and no Referrer Line. That is correct, the button will either be EDIT, DETAILS or PREVIEW. All I can say is that you must not have updated the catalog/admin/orders.php correctly. If you mean that this error comes up AFTER you uninstall the eCheck payment module, that is because the payment module deletes all the fields added in the ORDERS table. I have also fixed that one as well! Edited November 28, 2004 by PopTheTop Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
dsatchell Posted November 28, 2004 Share Posted November 28, 2004 I copied the font file to the windows/font directory but I'm still getting the A and C letters instead of the special symbols. Is there anything else I should check or do? Thanx, Dave. Quote Link to comment Share on other sites More sharing options...
dsatchell Posted November 28, 2004 Share Posted November 28, 2004 OK, turns out that the special symbols work fine under IE but show as A and C under Netscape and probably Firefox. Dave. Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted November 29, 2004 Author Share Posted November 29, 2004 I copied the font file to the windows/font directory but I'm still getting the A and C letters instead of the special symbols. Is there anything else I should check or do? Thanx, Dave. <{POST_SNAPBACK}> In most cases, that is it. You may need to right-click on the file and choose install. Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
Guest Posted December 1, 2004 Share Posted December 1, 2004 Do you get many customers using this payment method? Why wouldn't they just use a credit card? I don't know if I would want to send my bank info to an online store. What prevents the store owner from printing out 100 checks and cashing them all once they have your bank info? Do banks really accept a check printed on your printer? Seems like you'd get some raised eyebrows from the teller. :) <{POST_SNAPBACK}> We just started using the echeck payment option, and we've already had people using it. I think some customers would rather pay by check than give an online retailer their credit card information, and this option doesn't hold up thier order until their check is received. As for customers being uneasy about providing that information, you might put a note on your site which explains that the information they provide for an echeck is no different from the information that is on their paper checks...and just think of how many people we write checks to!! As for banks accepting them, I had a little trouble the first time because the MICR font didn't print correctly, but the bank STILL deposited the check. So if they'll deposit one that has an error like the one we deposited, you really shouldn't have any trouble. It's a great contribution...I highly recommend it. :) - Dani Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.