<SOLVED>How to display manufacture name in the featured product

[kirinMissy]

Hello,

I'd like to show manufacture name including link to show their products for the featured product on the homepage. Please help...

I've searched and found the topic to show manufacture image here -> http://www.prestashop.com/forums/viewthread/41293/

But I don't know how to show the name and link. I'm using V.1.4 RC3.

Thank you

[kirinMissy]

I've found the solution from this thread -> http://www.prestashop.com/forums/viewthread/77057/seo_search_engine_optimization/solved_how_to_include_supplier_name_in_product_list/

For V. 1.4.0.12, I made two-step adjustment to the file classes/Category.php

1. Line 479 change from

SELECT p.*, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY)) > 0 AS new,

to this one

        SELECT p.*, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, s.`name` AS supplier_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY)) > 0 AS new,

This code will be added:

s.`name` AS supplier_name,

2. After Line 493, add the new line for this code

LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`

After you edit the file "Category.php". You can insert {$product.supplier_name} into modules/homefeatured/homefeature.tpl wherever you want the supplier name to be displayed.

Hope this help..