Psytanium

In Google Webmaster Tools I have many duplicates e.g. /product_info.php/targus-bag-tss588us-156-black-p-6437 /product_info.php?products_id=6437 is it because Google XML Sitemap is not compatible with SEO URLs 5 ??

@Gergely already enabled, I checked the view-source, I can see the <link rel="canonical" href="https://macrotronics.net/product_info.php/samsung-850-evo-500gb-ssd-mz-75e500b-p-12045" /> in the header could be the htaccess ?

in Google Webmaster Tools, HTML Improvements. I have almost all my web pages duplicate titles. e.g. /index.php/pos-system-signature-capture-c-155_185_2093_0_45_252_474 /index.php/pos-system-signature-capture-c-155_45_252_474 another e.g. /product_info.php/targus-bag-tss588us-156-black-p-6437 /product_info.php?products_id=6437 Why ? and what should I do ? thanks

Sorry for posting again but i really have to repair this problem, duplicate URLs in Google Webmaster Tools e.g. /product_info.php/targus-bag-tss588us-156-black-p-6437 /product_info.php?products_id=6437

in Google Webmaster Tools, HTML Improvements. I have almost all my web pages duplicate titles. e.g. /index.php/pos-system-signature-capture-c-155_185_2093_0_45_252_474 /index.php/pos-system-signature-capture-c-155_45_252_474 another e.g. /product_info.php/targus-bag-tss588us-156-black-p-6437 /product_info.php?products_id=6437 Why ? and what should I do ? thanks

Hi, I receive a mail from cron job every day saying CONGRATULATIONS! All files generated successfully ... should I click the link to submit the sitemap every time i receive this email ? thanks

its not for oscommerce, woocommerce and other platforms. in case i fond a solution ill post it.

@@Moxamint thank you, its working as you said. but is there a way to make it work per 0.5 kg ?

Hi @@Jack_mcs, I replaced the old file with the new release Jan 2017, i got the Fatal error: Call to undefined function tep_db_query() error. I did what you proposed, I move require('includes/application_top.php'); out of if statement. I run the script directly from https://www.domain.com/admin/auto_update_currencies.php Now the error is gone, but should i leave it like this ? Thanks

My website have EU as default currency, but the shipping agents charge us in USD. How to set the shipping fees currency ? Any ideas what to do ? thanks

Recently our store started selling online fireplaces and its accessories, products are really heavy, starting from 50Kg to 500kg and maybe more. The shipping company DHL charges us 5$ for each 0.5Kg Using the zone rates, i have to write a string of incremental weight and price, starting from 0 to reach 500kg+, I have to write 1000 piece of mordor code for every geozone, e.g. 3:8.50,7:10.50,99:20.00 ............................... is there a way to write only something like : 5$ per 0.5Kg ?

Hi, When i open my website on any browser and search for anything, the page load then redirect me to the home page. This is happening only for the 1st search, a second search work fine. This problem was solved by removing tep_hide_session_id() from the cm_search.php module. I don't know what's the job of tep_hide_session_id(), what's the side effect of removing it ? Thank you

Exactly.. Thank you bro

if I don't modify splitPageResults class, the products count is 1 if I capitalizing GROUP BY in splitPageResults class, the products count is 45, while it must be 36. whether I change it or not, its output is wrong.

@@Gergely I set everything to lower cases, except for tables. I get this sql error : 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) as total from products p, products_to_categories p2c, products_description p' at line 1 select count(distinct *) as total from products p, products_to_categories p2c, products_description pd, categories c where p.products_status = '1' and p.products_promotion != '0' and p.products_id = pd.products_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id != 31 and c.parent_id != 39 and pd.language_id = '1' This error is fixed by capitalizing only GROUP BY. This is the php page : <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2010 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_OFFER_FIREPLACES); $current_page = FILENAME_OFFER_FIREPLACES; $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_OFFER_FIREPLACES)); require(DIR_WS_INCLUDES . 'template_top.php'); ?> <?php echo tep_draw_content_top();?> <?php $clearance_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_model, p.products_availability_status, p.products_tax_class_id, p.products_image, p.products_promotion, p.fr_currencies_id, c.parent_id, p2c.products_id, p2c.categories_id, c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_promotion != '0' and p.products_id = pd.products_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id != 31 and c.parent_id != 39 and pd.language_id = '" . (int)$languages_id . "' GROUP BY p.products_id order by p.products_price asc"; $clearance_split = new splitPageResults($clearance_query_raw, MAX_DISPLAY_SPECIAL_PRODUCTS); if (($clearance_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?> <?php echo tep_draw_result1_top(); ?> <div class="cl_both result_top_padd ofh"> <div class="fl_left result_left"><?php echo $clearance_split->display_count(TEXT_DISPLAY_NUMBER_OF_WAREHOUSE_CLEARANCE); ?></div> <div class="fl_right result_right"><?php echo $clearance_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></div> </div> <?php echo tep_draw_result1_bottom(); ?> <?php } ?> <div class="contentContainer page_specials prod-list-wide"> <div class="contentPadd t_view prod-list-wide"> <?php $col_special_wide = 0; $row_special_wide = 0; $col_items = (MAX_DISPLAY_SPECIAL_PER_ROW_WIDE -1); $colspan = ((MAX_DISPLAY_SPECIAL_PER_ROW_WIDE * 2) - 1); $col_width = (int)(100 / ($col_items + 1)).'%'; ?> <?php $clearance_prods_content_wide .= '<div class="prods_content">'; $clearance_query = tep_db_query($clearance_split->sql_query); while ($clearance = tep_db_fetch_array($clearance_query)) { if (($col_special_wide === 0) && ($row_special_wide != 0)) { $clearance_prods_content_wide .= '<ul class="row_separator"><li class="prods_hseparator">'.tep_draw_separator('spacer.gif', '1', '1').'</li></ul>'; } if ($col_special_wide === 0) { $clearance_prods_content_wide .= '<ul class="row row3" id="row-'.$row_special_wide.'">'; }else { $clearance_prods_content_wide .= '<li class="prods_vseparator equal-height3">'.tep_draw_separator('spacer.gif', '1', '1').''; } // ************************************* if (IMG_HOVER_EFFECT == 'style-1') { $img_effect = 'first'; $img_effect_width = PRODS_BLOCK_SPECIALS_WIDTH - PIC_MARG_W; } if (IMG_HOVER_EFFECT == 'style-2') { $img_effect = 'tenth'; $img_effect_width = PRODS_BLOCK_SPECIALS_WIDTH - PIC_MARG_W; } if (IMG_HOVER_EFFECT == 'style-3') { $img_effect = 'fifth'; $img_effect_width = PRODS_BLOCK_SPECIALS_WIDTH - PIC_MARG_W; } // START - check if product is promoted // END - check if product is promoted // ************************************* // ************************************* $product_query = tep_db_query("select products_description, products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$clearance['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); $p_id = $product['products_id']; $row_special_wide++; // ************************************* // ************************************* $p_pic = '<a class="prods_pic_bg" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $clearance['products_id']) . '" style="width:'.(SPECIAL_IMAGE_WIDTH + PIC_MARG_W).'px;height:'.(SPECIAL_IMAGE_HEIGHT + PIC_MARG_H).'px;"><div class="cat-pic-zoom"></div>' . tep_image(DIR_WS_IMAGES . $clearance['products_image'], $clearance['products_name'], (SPECIAL_IMAGE_WIDTH), (SPECIAL_IMAGE_HEIGHT), ' style="width:'.(SPECIAL_IMAGE_WIDTH + PIC_MARG_W2).'px;height:'.(SPECIAL_IMAGE_HEIGHT + PIC_MARG_H2).'px;margin:'.PIC_MARG_T.'px '.PIC_MARG_R.'px '.PIC_MARG_B.'px '.PIC_MARG_L.'px;"') . ''; if (tep_not_null($clearance['products_model'])) { $p_name = $lc_text = '<span><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $clearance['products_id']) . '">' . $clearance['products_name'] . '<span style="color:#999; font-size: 11px;"> [' . $clearance['products_model'] . ']</a></span>'; } else { $p_name = $lc_text = '<span><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $clearance['products_id']) . '">' . $clearance['products_name'] . '</a></span>'; } $p_price = $lc_text = '<div class="price price_padd '.$extra.'"><span class="productSpecialPrice">' . $currencies->display_price($clearance['products_price'], tep_get_tax_rate($clearance['products_tax_class_id']), $clearance['fr_currencies_id']) . '</span></div>'; if($cPath != 102){ if($clearance['products_availability_status'] ==0) { $p_availability = '<div class="status-availability"><i style="color:#94ff54" class="fa fa-check"></i> Available</div><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $clearance['products_id']) . '"><div class="have-look">More Details <i class="fa fa-angle-double-right more-details-icon"></i></div></a><div style="clear:both;"></div>'; }elseif($clearance['products_availability_status'] ==1) { $p_availability = '<div class="status-availability"><i style="color:#54d1ff" class="fa fa-pencil"></i> On order</div><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $clearance['products_id']) . '"><div class="have-look">More Details <i class="fa fa-angle-double-right more-details-icon"></i></div></a><div style="clear:both;"></div>'; }elseif($clearance['products_availability_status'] ==2){ $p_availability = '<div class="status-availability"><i style="color:#ffc154" class="fa fa-exclamation"></i> Last piece</div><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $clearance['products_id']) . '"><div class="have-look">More Details <i class="fa fa-angle-double-right more-details-icon"></i></div></a><div style="clear:both;"></div>'; }elseif($clearance['products_availability_status'] ==3){ $p_availability = '<div class="status-availability"><i style="color:#fff554" class="fa fa-hourglass-half"></i> Coming soon</div><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $clearance['products_id']) . '"><div class="have-look">More Details <i class="fa fa-angle-double-right more-details-icon"></i></div></a><div style="clear:both;"></div>'; }else{ $p_availability = ''; } } // if Discounted if ($clearance['products_promotion'] == 1) { $clearance_offer ='<div class="offer-ribbon"></div>'; } else if ($clearance['products_promotion'] == 2) { $clearance_offer ='<div class="warehouse-clearance-ribbon"></div>'; } $p_details_text = '' .tep_draw_button2_top() . '<a href="' . tep_href_link('product_info.php?products_id='.$p_id) . '" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-text-icon-primary ui-priority-secondary" role="button"><span class="ui-button-icon-primary ui-icon ui-icon-triangle-1-e"></span><span class="ui-button-text">'. IMAGE_BUTTON_DETAILS .'</span></a>' . tep_draw_button2_bottom().''; $p_buy_now_text = '' .tep_draw_button_top() . '<a href="'.tep_href_link("products_new.php","action=buy_now&products_id=".$p_id).'" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-text-icon-primary ui-priority-secondary" role="button"><span class="ui-button-icon-primary ui-icon ui-icon-cart"></span><span class="ui-button-text">'. IMAGE_BUTTON_IN_CART .'</span></a>' . tep_draw_button_bottom().''; // ************************************* // ************************************* $clearance_prods_content_wide .= '<li style="width:' . PRODS_BLOCK_SPECIALS_WIDTH . 'px;" class="wrapper_prods equal-height_listing_block hover">'. "\n". '' .$clearance_offer.'<div class="border_prods">'. "\n". '<div class="pic_padd wrapper_pic_div" style="width:'.(SEARCH_IMAGE_WIDTH + PIC_MARG_W).'px;height:'.(SEARCH_IMAGE_HEIGHT + PIC_MARG_H).'px;">'.$p_pic.'</a>'. "\n". '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $clearance['products_id']) . '"></a></div>'. "\n". '<div class="prods_padd">'. '<div class="name name_padd equal-height">'.$p_name.'</div>'. "\n". ''.$p_price. "\n". ''.$p_availability. "\n". '<div class="listing_padd">'.$p_listing.'</div>'. "\n". '</div>'. "\n". '</div>'. "\n"; $col_special_wide ++; if ($col_special_wide > $col_items) { $clearance_prods_content_wide .= '</ul>'; $row_special_wide ++; $col_special_wide = 0; }else{ $clearance_prods_content_wide .= '</li>'; } } $clearance_prods_content_wide .= '</div>'; echo $clearance_prods_content_wide; ?> </div> </div> <?php if (($clearance_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?> <?php echo tep_draw_result2_top(); ?> <div class="cl_both result_bottom_padd ofh"> <div class="fl_left result_left"><?php echo $clearance_split->display_count(TEXT_DISPLAY_NUMBER_OF_SPECIALS); ?></div> <div class="fl_right result_right"><?php echo $clearance_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></div> </div> <?php echo tep_draw_result2_bottom(); ?> <?php } ?> <?php echo tep_draw_content_bottom();?> <script type="text/javascript"> $(window).load(function() { var maxHeight = 0; $(".equal-height").each(function() { if ($(this).height() > maxHeight) { maxHeight = $(this).height(); } }); $(".equal-height").height(maxHeight); }); </script> <?php require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> UUsing Upper case GROUP BY, output the correct result but with wrong count and split, see attached image. Big thanks