Mobile-Menu iFuturz Infoweb Inc. Contact Portfolio

07

Sep

Display Product manufacturer name and logo on products listing page in oscommerce

Display Product manufacturer name and logo on products listing page in oscommerce

Posted On : September 7, 2013

| No Comment

This article describe how can you can display manufacturer name and logo on product listing page in your oscommerce store.

Login in your oscommerce store admin panel and go to configuration -> product listing section. Now click on the display product manufacturer name option and click on edit button.


Then fill up the sort order in textbox and click on update button

Now open your oscommerce store directory and open the index.php file.  On line 187 find the following code.

View Code PHP
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

Now replace the above code with following code and save file and close it.

View Code PHP
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, m.manufacturers_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

Next open the /includes/modules/products_listing.php file .on line 103 find the following code.

View Code PHP
case 'PRODUCT_LIST_MANUFACTURER':
           $lc_align = '';
           $lc_text = ' ' . $listing['manufacturers_name'] . ' ';
            break;

Now replace the above code with following code and save file and close it.

View Code PHP
case 'PRODUCT_LIST_MANUFACTURER':
            $lc_align = '';
            $lc_text = ' ' . $listing['manufacturers_name'] . ' ';
            if (tep_not_null($listing['manufacturers_image']))
			{
			   $lc_text .= ''.tep_image(DIR_WS_IMAGES . $listing['manufacturers_image'], $listing['manufacturers_image'], '', '', 'class="displayed"').'';
			}
 
		    break;

Now open the product listing page and you can see the manufacturers name and logo display on the page. Just check the following snap.

  • Tags:

Comment