nipunjoshi

Try this: http://www.oscommerce.com/forums/topic/327300-usps-module-is-forcing-express-mail-option/ I have the same issue with no response from friends here, still struggling. Rates still stuck with Express Rate

NO ONE, NEED HELP

I have been looking/reading and search for a solution but not able to get to correct this. NEED HELP!!! USPS is in Production mode: I am using OSCommerce v2.2 and am using Methods version 4.3 new install I have Flat Rate, UPS and USPS installed: Problem with USPS international rate when using Google Checkout. Administration-->Configuration-->Shipping/Packaging Country of Origin United States Postal Code 11208 Enter the Maximum Package Weight you will ship 50 Package Tare weight. 0.10 Larger packages - percentage increase. 1 Dimensions Support No Unit Weight LBS Unit Length IN Shipping Module --> United States Postal Services (when all selected googlecheckout shows $0.98 on all available shipping methods and when I remove ENV methods it shows $28.70 i.e Express Mail International (EMS) Flat-Rate Envelope , see below regular checkout rate) GLBL EX GLBL EX NONDOC RECT GLBL EX NONDOC NON-RECT EXPRESS INT EXPRESS INT FLAT RATE ENV PRIORITY INT PRIORITY INT FLAT RATE ENV PRIORITY INT FLAT RATE BOX FIRST-CLASS INT Regular checkout only six (6) shows up: Express Mail International (EMS) Flat-Rate Envelope $28.70 Priority Mail International $65.75 Express Mail International (EMS) $72.00 Global Express Guaranteed $134.50 Global Express Guaranteed Non-Document Non-Rectangular $135.50 Global Express Guaranteed Non-Document Rectangular $135.50 Google Checkout: Shipping_methods.php (this is what I have in Shipping_methods.php file) 'international_types' => array( 'GXG Document' => 'Global Express Guaranteed', 'GXG Non-Document' => 'Global Express Guaranteed Non-Document Service', 'Express' => 'Express Mail International (EMS)', 'Priority Lg' => 'Global Priority Mail - Flat-rate Envelope (large)', 'Priority Sm' => 'Global Priority Mail - Flat-rate Envelope (small)', 'Priority Var' => 'Global Priority Mail - Variable Weight Envelope (single)', 'Airmail Letter' => 'Airmail Letter Post', 'Airmail Parcel' => 'Airmail Parcel Post', 'Surface Letter' => 'Economy (Surface) Letter Post', 'Surface Post' => 'Economy (Surface) Parcel Post' ) usps.php (this is what I have in usps.php file) ******************************************************************* */ //Added by Greg Deeth on May 12th, 2008 //INTERNATIONAL MAIL OPTIONS //Change the values to the option you would like //FIRST CLASS MAIL INTERNATIONAL OPTION: $this->FirstClassIntType = 'Letters'; //OPTIONS: 'Letters', 'Large Envelope', 'Package' //PRIORITY FLAT-RATE BOX INTERNATIONAL OPTION: $this->PriorityFlatRateBoxType = 'Flat-Rate Box'; //OPTIONS: 'Flat-Rate Box', 'Large Flat-Rate Box' /****************************************************************** */ $this->intl_types = array( 'GLBL EX' => 'Global Express Guaranteed', 'GLBL EX NONDOC RECT' => 'Global Express Guaranteed Non-Document Rectangular', 'GLBL EX NONDOC NON-RECT' => 'Global Express Guaranteed Non-Document Non-Rectangular', 'EXPRESS INT' => 'Express Mail International (EMS)', 'EXPRESS INT FLAT RATE ENV' => 'Express Mail International (EMS) Flat-Rate Envelope', 'PRIORITY INT' => 'Priority Mail International', 'PRIORITY INT FLAT RATE ENV' => 'Priority Mail International Flat-Rate Envelope', 'PRIORITY INT FLAT RATE BOX' => 'Priority Mail International ' . $this->PriorityFlatRateBoxType, 'FIRST-CLASS INT' => 'First Class Mail International ' . $this->FirstClassIntType); I am new still new to PHP Thanks in advance.

I have been looking/reading and search for a solution but not able to get to correct this. NEED HELP!!! USPS is in Production mode: I am using OSCommerce v2.2 and am using Methods version 4.3 new install I have Flat Rate, UPS and USPS installed: Problem with USPS international rate when using Google Checkout. Administration-->Configuration-->Shipping/Packaging Country of Origin United States Postal Code 11208 Enter the Maximum Package Weight you will ship 50 Package Tare weight. 0.10 Larger packages - percentage increase. 1 Dimensions Support No Unit Weight LBS Unit Length IN Shipping Module --> United States Postal Services (when all selected googlecheckout shows $0.98 on all available shipping methods and when I remove ENV methods it shows $28.70 i.e Express Mail International (EMS) Flat-Rate Envelope , see below regular checkout rate) GLBL EX GLBL EX NONDOC RECT GLBL EX NONDOC NON-RECT EXPRESS INT EXPRESS INT FLAT RATE ENV PRIORITY INT PRIORITY INT FLAT RATE ENV PRIORITY INT FLAT RATE BOX FIRST-CLASS INT Regular checkout only six (6) shows up: Express Mail International (EMS) Flat-Rate Envelope $28.70 Priority Mail International $65.75 Express Mail International (EMS) $72.00 Global Express Guaranteed $134.50 Global Express Guaranteed Non-Document Non-Rectangular $135.50 Global Express Guaranteed Non-Document Rectangular $135.50 Google Checkout: Shipping_methods.php (this is what I have in Shipping_methods.php file) 'international_types' => array( 'GXG Document' => 'Global Express Guaranteed', 'GXG Non-Document' => 'Global Express Guaranteed Non-Document Service', 'Express' => 'Express Mail International (EMS)', 'Priority Lg' => 'Global Priority Mail - Flat-rate Envelope (large)', 'Priority Sm' => 'Global Priority Mail - Flat-rate Envelope (small)', 'Priority Var' => 'Global Priority Mail - Variable Weight Envelope (single)', 'Airmail Letter' => 'Airmail Letter Post', 'Airmail Parcel' => 'Airmail Parcel Post', 'Surface Letter' => 'Economy (Surface) Letter Post', 'Surface Post' => 'Economy (Surface) Parcel Post' ) usps.php (this is what I have in usps.php file) ******************************************************************* */ //Added by Greg Deeth on May 12th, 2008 //INTERNATIONAL MAIL OPTIONS //Change the values to the option you would like //FIRST CLASS MAIL INTERNATIONAL OPTION: $this->FirstClassIntType = 'Letters'; //OPTIONS: 'Letters', 'Large Envelope', 'Package' //PRIORITY FLAT-RATE BOX INTERNATIONAL OPTION: $this->PriorityFlatRateBoxType = 'Flat-Rate Box'; //OPTIONS: 'Flat-Rate Box', 'Large Flat-Rate Box' /****************************************************************** */ $this->intl_types = array( 'GLBL EX' => 'Global Express Guaranteed', 'GLBL EX NONDOC RECT' => 'Global Express Guaranteed Non-Document Rectangular', 'GLBL EX NONDOC NON-RECT' => 'Global Express Guaranteed Non-Document Non-Rectangular', 'EXPRESS INT' => 'Express Mail International (EMS)', 'EXPRESS INT FLAT RATE ENV' => 'Express Mail International (EMS) Flat-Rate Envelope', 'PRIORITY INT' => 'Priority Mail International', 'PRIORITY INT FLAT RATE ENV' => 'Priority Mail International Flat-Rate Envelope', 'PRIORITY INT FLAT RATE BOX' => 'Priority Mail International ' . $this->PriorityFlatRateBoxType, 'FIRST-CLASS INT' => 'First Class Mail International ' . $this->FirstClassIntType); I am new still new to PHP Thanks in advance.

even i am looking for a solution, has anyone figured. did went to catalog/include/modules/shipping/table.php commented out $shipping = $shipping * $shipping_num_box; on line 72 and give me an amount; first default table amount if i add more products and increase weight, shipping rate does not increase. Has any one found a solution to this problem. Thank you in advance

NEVER MIND GO IT WORKING.. HAD FOLDER IN WRONG LOCATION AND OSC WAS GETTING CONFUSED IN TWO CSS FILES.. COPIED ALL LIGHTBOX.CSS INTO STYLESHEET.CSS IT WORKS JUST GREAT. THANK YOU NICE CONTRIB..

NEVER MIND GO IT WORKING.. HAD FOLDER IN WRONG LOCATION AND OSC WAS GETTING CONFUSED IN TWO CSS FILES.. COPIED ALL LIGHTBOX.CSS INTO STYLESHEET.CSS IT WORKS JUST GREAT. THANK YOU NICE CONTRIB..

IMAGE KEEPS OPENING IN NEW WINDOW, NEED SERIOUS HELP, NEW TO PHP... I AM NOT SURE WHAT MAY BE WRONG!! CAN SOMEONE HELP ME OUT BELOW IS THE CODE FROM product_info.php <?php /* $Id: product_info.php 1739 2007-12-20 00:52:16Z hpdl $ 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'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <?php /*** Begin Header Tags SEO ***/ if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { ob_start(); require(DIR_WS_INCLUDES . 'header_tags.php'); $preventDuplicates->checkTarget(ob_get_clean()); echo $preventDuplicates->finalMeta . "\n"; } else { ?> <title><?php echo TITLE; ?></title> <?php } /*** End Header Tags SEO ***/ ?> <meta name="verify-v1" content="Cq+CFzlxoZ85MzFDzofNIxVFw62krccQ5DPWTEbRXGQ=" /> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <script type="text/javascript" src="lightbox/prototype.js"></script> <script type="text/javascript" src="lightbox/scriptaculous.js?load=effects"></script> <script type="text/javascript" src="lightbox/builder.js"></script> <script type="text/javascript" src="lightbox/lightbox.js"></script> <link href="lightbox/lightbox.css" rel="stylesheet" type="text/css" media="screen" /> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" onLoad="MM_preloadImages(‘/images/menu_on.gif’);initLightbox()"> <?php /*** Begin Header Tags SEO ***/ ?> <a name="<?php echo $header_tags_array['title']; ?>"></a> <?php /*** End Header Tags SEO ***/ ?> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table class="shopouter" border="0" width="956" cellspacing="4" cellpadding="4" align="center"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0"> <?php if ($product_check['total'] < 1) { ?> <tr> <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <?php } else { $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> <?php // START: Extra Fields Contribution v2.0b - mintpeel display fix $extra_fields_query = tep_db_query("SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=". (int)$HTTP_GET_VARS['products_id'] ." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."') ORDER BY products_extra_fields_order"); echo '<tr> <td> <table border="0" width="50%" cellspacing="0" cellpadding="2px">'; while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { if (! $extra_fields['status']) // show only enabled extra field continue; echo'<tr><td class="main" align="left" valign="middle"><font size="1" color="#666666"><b>'.$extra_fields['name'].': </b>' . stripslashes($extra_fields['value']).'</font></td></tr>'; } echo' </table> </td> </tr>'; // END: Extra Fields Contribution - mintpeel display fix ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <?php /*** Begin Header Tags SEO ***/ ?> <td class="pageHeading" valign="top"><?php echo $products_name; ?></td> <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td> <?php /*** End Header Tags SEO ***/ ?> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"> <?php if (tep_not_null($product_info['products_image'])) { ?> <table border="0" cellspacing="0" cellpadding="2" align="right"> <tr> <td align="center" class="smallText"> <script language="javascript"><!-- document.write('<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank" rel="lightbox" title="'.$product_info['products_name'].'" >' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></script> <noscript> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank" rel="lightbox" title="'.$product_info['products_name'].'" >' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); </noscript> <br><br> <?php //affiliate build a link begin if (tep_session_is_registered('affiliate_id')) { ?> <?php echo '<a href="' . tep_href_link(FILENAME_AFFILIATE_BANNERS_BUILD, 'individual_banner_id=' . $product_info['products_id']) .'" target="_self">' . tep_image('includes/languages/english/images/buttons/button_affiliate_build_a_link.gif', 'Make a link') . ' </a>'; ?><?php } //affiliate build a link begin ?> </td> </tr> </table> <?php } ?> <p><?php echo stripslashes($product_info['products_description']); ?></p> <?php $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td> </tr> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> <tr> <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td> <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td> </tr> <?php } ?> </table> <?php } ?> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); if ($reviews['count'] > 0) { ?> <tr> <td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if (tep_not_null($product_info['products_url'])) { ?> <tr> <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td> </tr> <?php } else { ?> <tr> <td align="center" class="smallText"><?php //echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td> </tr> <?php } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT, tep_get_path($current_category_id = '')) . '">' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>'; ?></td> <td class="main" align="center"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td> <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></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> <!--- BEGIN Header Tags SEO Social Bookmarks --> <?php if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true') include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php'); ?> <!--- END Header Tags SEO Social Bookmarks --> <tr> <td> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } } ?> </td> </tr> <?php /*** Begin Header Tags SEO ***/ ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main" align="center"><?php echo TEXT_VIEWING; ?> <?php echo '<a title="' . $header_tags_array['title'] . '" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id'], 'NONSSL') . '"/# ' . $header_tags_array['title'] . '">' . $header_tags_array['title']; ?></a></td> </tr> <?php /*** End Header Tags SEO ***/ ?> </table></form></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> <!-- Kontera ContentLink;--> <script type='text/javascript'> var dc_AdLinkColor = '#666600' ; var dc_PublisherID = 79880 ; </script> <script type='text/javascript' src='http://kona.kontera.com/javascript/lib/KonaLibInline.js'> </script> <!-- Google Analytics --> <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> try { var pageTracker = _gat._getTracker("UA-8304209-1"); pageTracker._trackPageview(); } catch(err) {}</script> <!-- End Google Analytics --> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

IT KEEPS ON IPENING IN NEW WINDOW :( NEED HELP

HEY NICE WORK ON YOUR WEB DESIGN.. THIS COULD BE USED FOR NEW 3.0V ALPHA IF YOU CAN SHARE IT ALL: WOULD BE OF GREAT CONTRIBUTION TO COMMUNITY.

open your .htaccess file that is under catalog directory and follow as prompted below: i guess you missed out on this instruction. If you don't have an .htaccess file in your catalog directory create one. If your store is located in a DIRECTORY add this to the /*directory*/.htaccess file: NOTE: you will have to edit the "directory" to match your directory name! SO IF YOU HAVE YOUR STORE IN CATALOG DIRECTORY FIND # Ultimate SEO URLs BEGIN Options +FollowSymLinks RewriteEngine On RewriteBase / RewriteCond %{QUERY_STRING} ^options\=(.*)$ AND REPLACE IT WITH # Ultimate SEO URLs BEGIN Options +FollowSymLinks RewriteEngine On RewriteBase /catalog/ RewriteCond %{QUERY_STRING} ^options\=(.*)$ IF YOUR STORE IS IN ROOT DIRECTORY FOLLOWING IS WHAT IT SHOULD HAVE/SHOW: # Ultimate SEO URLs BEGIN Options +FollowSymLinks RewriteEngine On RewriteBase / RewriteCond %{QUERY_STRING} ^options\=(.*)$ HOPE THIS HELPS, I WAS HAVING SAME PROBLEM BUT GOT IT FIXED... GOOD LUCK. ---------------------------------------------------------------------------------------------------

I know.. I technicall did not reinstall the database.. but it got overwritten when i created a dummy test site with same database name and userid. (Have not lost anything though) as i had few test products of my own store.. which i will upload it again at later state.. if you want i can email you the files... let me know which one do you want me to email it to you. Again Thanks.. ChilliNr1

i have been working to find what am i doing wrong.. got everything just the way it is defined..but cannot still make this work.. any clue... below is what i guess the problem may be... in checkoutprocess.php //kgt - discount coupons if( tep_session_is_registered( 'coupon' ) && is_object( $order->coupon ) ) { $sql_data_array = array( 'coupons_id' => $order->coupon->coupon['coupons_id'], 'orders_id' => $insert_id ); tep_db_perform( TABLE_DISCOUNT_COUPONS_TO_ORDERS, $sql_data_array ); } //end kgt - discount coupons Another weird issue: does not populate anything in TABLE_DISCOUNT_COUPONS_TO_ORDERS when i try to work from home... any idea. Any help to make this work would help...

Hello KGT, I have gone through most of yours and others post but i cannot seem to find an answer for above error. In my case table discount_coupons_to_orders field order_id never gets populated with customer order_id and stays at 0 (Zero) that has been defined while creating a table. Following are few things that i was concern with and wanted to see if you can help me and others here: 1. what should i do to get order_id field in table discount_coupons_to_orders populated with current customer order id. 2. if a new customer pays with paypal and does not have an account with paypal and say they do not return back to our site after payment, this is what happens: in my case discount_coupons_to_orders does not increment i do not know about others and if say if this was second order using a coupon code it throws 1062 error as what insert query finds is a duplicate record with 0 already in order_id. Am i going wrong somewere i have osCommerce Online Merchant v2.2 RC 2a with latest ot_discount_coupon_codes_3_32 modue. Need help... Thanks

HAVE YOU FIXED THIS.. I GUESS IT IS SHOWS UP BECAUSE OF 0 THAT GETS INSERTED EVERYTIME TO ORDER_ID. IF YOU HAVE A SOLUTION, PLEASE LET ME KNOW AS I HAVE SAME ISSUE... FIRST COUPON NOT POPULATING THE discount_coupons_to_orders TABLE AND AFTER ADDING FEW PROVIDED CODE TO PAYPAL_STANDARD.PHP I GET THIS ERROR. When using Paypal IPN, coupons can get reused. You must edit one additional file to get discount coupon codes working with the latest versions of PayPal IPN. The following instructions are for version 2.2 of this contribution: http://www.oscommerce.com/community/contributions,2679. The exact instructions below may not work for other versions, but the changes needed are similar. OPEN includes/modules/payment/paypal_ipn.php FIND around line 195: //+1.4 $sql_data_array = array('orders_id' => $insert_id, 'orders_status_id' => $order->info['order_status'], 'date_added' => 'now()', 'customer_notified' => '0', 'comments' => $order->info['comments']); tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array); //-1.4 ADD this code after: //kgt - discount coupons if( tep_session_is_registered( 'coupon' ) && is_object( $order->coupon ) ) { $sql_data_array = array( 'coupons_id' => $order->coupon->coupon['coupons_id'], 'orders_id' => $insert_id ); tep_db_perform( TABLE_DISCOUNT_COUPONS_TO_ORDERS, $sql_data_array ); } //end kgt - discount couponsFIND around line 493: // unregister session variables used during checkout tep_session_unregister('sendto'); tep_session_unregister('billto'); tep_session_unregister('shipping'); tep_session_unregister('payment'); tep_session_unregister('comments');ADD this code after: //kgt - discount coupons tep_session_unregister('coupon'); //end kgt - discount coupons