Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

lov2flyrc

Archived
  • Posts

    27
  • Joined

  • Last visited

Profile Information

  • Real Name
    Todd Witkoff

lov2flyrc's Achievements

  1. We ship product world wide so I have installed the World Zones SQL contribution. Since I have done this however, all of my existing costomer addresses are processing with state errors. It is matching international countries to the states. New customers entering the database are correct. Here is an example Joe Smith 1111 Donna Ave Endicott, Gramsh 13760 Gramsh should be New York. How do I fix this???
  2. Having an issue with authorize.net when a card is declined. No information is provided on the checkout_payment.php page when a card gets declined, the user is just redirected back with nothing echoed. This confuses the customer as they have no idea why they are back to the page they just left. In the navigation bar you will see the card has been declined as seen below..... "checkout_payment.php?error_message=Your+credit+card+was+declined+%28%29%3A+&osCsid=e2bf5978b270f4241696a629f8c49c86" Most customers will never notice this however. How can I get the card error info to show up on the checkout_payment page to inform the customer of the problem? Thanks! Todd
  3. Hi Guys, Fighting my way through getting QBI to function. I have followed the install and all seems to be working. I have tested the IIF imports with QB2006. Customers and product seem to load in fine but I am getting an error during order import " error on line 18: Can't import invalid transaction" I have read through most of the 50 pages here and cant seem to find anything that relates to this error. I have tried several different configurations, monkied with tax settings ect... Cant seem to find the issue. If I view the IIF with Excel line 18 is "ENDTRNS", not sure if this is truely line 18? Here is a sample IIF with the error (cust info changed to protect the innocent :D ): !CUST NAME BADDR1 BADDR2 BADDR3 BADDR4 BADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE TAXITEM LIMIT RESALENUM REP COMPANYNAME SALUTATION FIRSTNAME LASTNAME CUST Blow-291 Joe Blow 1111 Foxdale Circle Colorado Springs Colorado 80919 Joe Blow 1111 Foxdale Circle Colorado Springs Colorado 80919 (111) 111-1111 [email protected] Joe Blow N Sales Tax Payable Joe Blow !TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM !SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA !ENDTRNS TRNS INVOICE 5/3/2006 Web Sales Blow-291 43.73 1813 N Y Joe Blow 1111 Foxdale Circle Colorado Springs Colorado 80919 Joe Blow 1111 Foxdale Circle Colorado Springs Colorado 80919 N Method not set 1813 SPL INVOICE 5/3/2006 Web Sales -35 Servo Crimp Tool N -1 35 AE-TMC-003 N SPL INVOICE 5/3/2006 N SPL INVOICE 5/3/2006 Sales -8.73 Shipping Charge N -1 8.73 shipping N SPL INVOICE 5/3/2006 N SPL INVOICE 5/3/2006 Thanks, Todd! Transaction ID: 20A44961BX5508327 Payment Type: PayPal Direct Payment Payment Status: Completed AVS Code: Yes Address and five-digit ZIP CVV2 Code: Match CVV2 N SPL INVOICE 5/3/2006 Sales Tax Payable Florida Department of Revenue 0 N 6.50% Sales Tax Payable N AUTOSTAX ENDTRNS Any thoughts as to the source of the error?? TIA Todd
  4. Thanks djmonkey1! I did a search and nothing returned on this error, just assumed it was a new one. >_< I believe I resolved my problem with the hints provided on page 11... Since some of my international orders where processing, I reviewed the state listing for the orders erroring out. One order for example was from Austrailia, with NSW (New South Wales) as the state. Nothing existed in my zone table to resolve this abbreviation. I installed this new zone list into my SQL file and had the customer process the order again. Problem solved..... Thanks for the assistance, hope this helps others. Todd Wondering.... Is it possible to not require a state for international order with this module, any way to bypass this requirement?
  5. Cudos for a great module.... Have been using WPP for about a week now, all seems to be working fine with one exception which I need to get resolved. Internationl orders (not all) are being bounced with the following error MODULE_PAYMENT_PAYPAL_DP_TEXT_STATE_ERROR I assume this is because of some sort of State requirement in the module? Any suggestion on how to reslove this? Thanks! Todd
  6. Well, still no resolve here guys?? Where would I enter the "echo $_GET['error_message'];" to have it display the error listed in the URL? This is what I am seeing.... www.domain.com/catalog/checkout_payment.php?error_message=Your+credit+card+was+declined+%282%29%3A+This+transaction+has+been+declined.&osCsid=0610ef25353997a2373dfda0b1333ab8 There must be a fairly simple solution to get this error to echo on the checkout page??
  7. Thank Heavens..... I thought I was the only one with this problem...although I did not relate the ghosted orders to be from a declined process. Thank you, thank you, thank you :thumbsup:
  8. Good question :blink: Never checked. Realized the problem when a customer called reporting he could not get his card to process. I did recently make a authorize.net module change to a contrib that supported CCV. AuthorizeAIM I think it was? Tried a fresh copy of checkout_payment.php and still does no show the error. Perhaps the problem is in the authorizenetaim.php file?
  9. I am having a problem with my authorize.net payment module, residing in checkout_payment.php I believe. If the payment fails, like AVS error for example, the customer gets redirected back to the payment page but the error is not shown. This is very confusing for the customer as he does not know why the page was redrawn. After the payment error happens, if you look in the browser address bar, the error can be seen... Example: /checkout_payment.php?error_message=There+has+been+an+error+processing+your+credit+card.+Please+try+ag ain.The+transaction+resulted+in+an+AVS+mismatch.+The+address+provided+does+not+ma tch+billing+address+of+cardholder.%3A+27&osCsid=d50f017890bd5599b81109f9f51e3a8d I cant seem to find why the error is not printed to the screen. I am posting a copy of my checkout_payment.php file, hopefully you guys might be able to find my problem... <?php /* $Id: checkout_payment.php,v 1.113 2003/06/29 23:03:27 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); // if the customer is not logged on, redirect them to the login page if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } // if there is nothing in the customers cart, redirect them to the shopping cart page if ($cart->count_contents() < 1) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); } // if no shipping method has been selected, redirect the customer to the shipping method selection page if (!tep_session_is_registered('shipping')) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); } // avoid hack attempts during the checkout procedure by checking the internal cartID if (isset($cart->cartID) && tep_session_is_registered('cartID')) { if ($cart->cartID != $cartID) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); } } // Stock Check if ( (STOCK_CHECK == 'true') && (STOCK_ALLOW_CHECKOUT != 'true') ) { $products = $cart->get_products(); for ($i=0, $n=sizeof($products); $i<$n; $i++) { if (tep_check_stock($products[$i]['id'], $products[$i]['quantity'])) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); break; } } } // if no billing destination address was selected, use the customers own address as default if (!tep_session_is_registered('billto')) { tep_session_register('billto'); $billto = $customer_default_address_id; } else { // verify the selected billing address $check_address_query = tep_db_query("select count(*) as total from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$customer_id . "' and address_book_id = '" . (int)$billto . "'"); $check_address = tep_db_fetch_array($check_address_query); if ($check_address['total'] != '1') { $billto = $customer_default_address_id; if (tep_session_is_registered('payment')) tep_session_unregister('payment'); } } require(DIR_WS_CLASSES . 'order.php'); $order = new order; if (!tep_session_is_registered('comments')) tep_session_register('comments'); $total_weight = $cart->show_weight(); $total_count = $cart->count_contents(); // load all enabled payment modules require(DIR_WS_CLASSES . 'payment.php'); $payment_modules = new payment; require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_PAYMENT); $breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); $breadcrumb->add(NAVBAR_TITLE_2, tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL')); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title>Dreamworks Model Products</title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <script language="javascript"><!-- var selected; function selectRowEffect(object, buttonSelect) { if (!selected) { if (document.getElementById) { selected = document.getElementById('defaultSelected'); } else { selected = document.all['defaultSelected']; } } if (selected) selected.className = 'moduleRow'; object.className = 'moduleRowSelected'; selected = object; // one button is not an array if (document.checkout_payment.payment[0]) { document.checkout_payment.payment[buttonSelect].checked=true; } else { document.checkout_payment.payment.checked=true; } } function rowOverEffect(object) { if (object.className == 'moduleRow') object.className = 'moduleRowOver'; } function rowOutEffect(object) { if (object.className == 'moduleRowOver') object.className = 'moduleRow'; } //--></script> <?php echo $payment_modules->javascript_validation(); ?> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"><center> <!-- header //--> <td width="792"><?php require(DIR_WS_INCLUDES . 'header.php'); ?></td> <!-- header_eof //--> <!-- body //--> <table width="770" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td valign="top" width="155" style="border-right: 1px #ff9900 solid;"> <table width="150" border="0" align="right" cellpadding="0" cellspacing="0"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="423" valign="top"><?php echo tep_draw_form('checkout_payment', tep_href_link(FILENAME_CHECKOUT_CONFIRMATION, '', 'SSL'), 'post', 'onsubmit="return check_form();"'); ?><table border="0" width="100%" cellspacing="0" cellpadding="0"> <BR><tr> <td><table border="0" width="400" cellspacing="0" cellpadding="0" align="center"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_payment.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <?php if (isset($HTTP_GET_VARS['payment_error']) && is_object(${$HTTP_GET_VARS['payment_error']}) && ($error = ${$HTTP_GET_VARS['payment_error']}->get_error())) { ?> <tr> <td><table border="0" width="400" cellspacing="0" cellpadding="2" align="center"> <tr> <td class="main"><b><?php echo tep_output_string_protected($error['title']); ?></b></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="400" cellspacing="1" cellpadding="2" class="infoBoxNotice"> <tr class="infoBoxNoticeContents"> <td><table border="0" width="400" cellspacing="0" cellpadding="2" align="center"> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main" width="100%" valign="top"><?php echo tep_output_string_protected($error['error']); ?></td> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> <tr> <td><table border="0" width="400" cellspacing="0" cellpadding="2" align="center"> <tr> <td class="main"><b><?php echo TABLE_HEADING_BILLING_ADDRESS; ?></b></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="400" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="400" cellspacing="0" cellpadding="2" align="center"> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main" width="50%" valign="top"><?php echo TEXT_SELECTED_BILLING_DESTINATION; ?><br><br><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT_ADDRESS, '', 'SSL') . '">' . tep_image_button('button_change_address.gif', IMAGE_BUTTON_CHANGE_ADDRESS) . '</a>'; ?></td> <td align="right" width="50%" valign="top"><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" align="center" valign="top"><b><?php echo TITLE_BILLING_ADDRESS; ?></b><br><?php echo tep_image(DIR_WS_IMAGES . 'arrow_south_east.gif'); ?></td> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main" valign="top"><?php echo tep_address_label($customer_id, $billto, true, ' ', '<br>'); ?></td> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="400" cellspacing="0" cellpadding="2" align="center"> <tr> <td class="main"><b><?php echo TABLE_HEADING_PAYMENT_METHOD; ?></b><br> <?php echo TEXT_CHECKOUT_CC; ?></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="400" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="400" cellspacing="0" cellpadding="2" align="center"> <?php $selection = $payment_modules->selection(); if (sizeof($selection) > 1) { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main" width="50%" valign="top"><?php echo TEXT_SELECT_PAYMENT_METHOD; ?></td><br> <td class="main" width="50%" valign="top" align="right"><b><?php echo TITLE_PLEASE_SELECT; ?></b><br> <?php echo tep_image(DIR_WS_IMAGES . 'arrow_east_south.gif'); ?></td> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> <?php } else { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main" width="100%" colspan="2"><?php echo TEXT_ENTER_PAYMENT_INFORMATION; ?></td> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <?php } $radio_buttons = 0; for ($i=0, $n=sizeof($selection); $i<$n; $i++) { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?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"; } ?> <td width="10"><span class="main"></span><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main" colspan="3"><b><?php echo $selection[$i]['module']; ?></b></td> <td class="main" align="right"> <b></b> <?php if (sizeof($selection) > 1) { echo tep_draw_radio_field('payment', $selection[$i]['id']); } else { echo tep_draw_hidden_field('payment', $selection[$i]['id']); } ?> </td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> <?php if (isset($selection[$i]['error'])) { ?> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main" colspan="4"><?php echo $selection[$i]['error']; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> <?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"> <?php for ($j=0, $n2=sizeof($selection[$i]['fields']); $j<$n2; $j++) { ?> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo $selection[$i]['fields'][$j]['title']; ?></td> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <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> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?><span class="main"><b></b></span></td> </tr> <?php } ?> </table></td> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> <?php $radio_buttons++; } ?> </table></td> </tr> </table></td> </tr> <tr> <td><span class="main"><b></b></span><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?><span class="main"><b></b></span></td> </tr> <tr> <td><table border="0" width="400" cellspacing="0" cellpadding="2" align="center"> <tr> <td class="main" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="400" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="400" cellspacing="0" cellpadding="2" align="center"> <tr> <td align="center"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="400" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="400" cellspacing="0" cellpadding="2" align="center"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><b><?php echo TITLE_CONTINUE_CHECKOUT_PROCEDURE . '</b><br>' . TEXT_CONTINUE_CHECKOUT_PROCEDURE; ?></td> <td class="main" align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="400" cellspacing="0" cellpadding="0" align="center"> <tr> <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%" align="right"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> </tr> </table></td> <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td><?php echo tep_image(DIR_WS_IMAGES . 'checkout_bullet.gif'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> </tr> </table></td> <td width="25%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td> </tr> </table></td> </tr> <tr> <td align="center" width="25%" class="checkoutBarFrom"><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '" class="checkoutBarFrom">' . CHECKOUT_BAR_DELIVERY . '</a>'; ?></td> <td align="center" width="25%" class="checkoutBarCurrent"><?php echo CHECKOUT_BAR_PAYMENT; ?></td> <td align="center" width="25%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_CONFIRMATION; ?></td> <td align="center" width="25%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_FINISHED; ?></td> </tr> </table></td> </tr> </table></form></td> <!-- body_text_eof //--> <td width="150" valign="top" style="border-left: 1px #ff9900 solid;"><br /><table border="0" width="100%" cellspacing="0" cellpadding="0" align="left"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <td width="792" align="center"> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </td> </center></body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  10. Need to search the contributions for CCV authorize.net and install it... Well... Not much help from this group :huh: Found a way to add this feature, just coded a html link like this CCV (What Is This?), using javascript to make it a small popup.....
  11. Would like to add a "What Is" or "Help" link providing explination for the CCV box for those customers that dont know what this is (typical at shoping cart checkouts). Anyone have a quick solution to adding this? Thanks in advance!
×
×
  • Create New...