[solved]how to dispaly best sellers products in productscategory.tpl file

[Kennedy5020]

Hi,

 

 

I need to display top sellers products in productscategory.tpl file ( \modules\productscategory\productscategory.tpl )

 

I got below code from this location for top sellers (\themes\default\modules\blockbestsellers\blockbestsellers.tpl file )

 

 

code :

 

 

<div id="best-sellers_block_right" class="block products_block">
<p class="title_block"><a href="{$link->getPageLink('best-sales')}">{l s='Top sellers' mod='blockbestsellers'}</a></p>
<div class="block_content">
{if $best_sellers|@count > 0}
<ul class="product_images">
{foreach from=$best_sellers item=product name=myLoop}
<li class="{if $smarty.foreach.myLoop.first}first_item{elseif $smarty.foreach.myLoop.last}last_item{else}item{/if} clearfix">
<a href="{$product.link}" title="{$product.legend|escape:'htmlall':'UTF-8'}" class="content_img clearfix">
<span class="number">{$smarty.foreach.myLoop.iteration}</span>
<img src="{$link->getImageLink($product.link_rewrite, $product.id_image, 'small_default')}" height="{$smallSize.height}" width="{$smallSize.width}" alt="{$product.legend|escape:'htmlall':'UTF-8'}" />

</a>
<p><a href="{$product.link}" title="{$product.legend|escape:'htmlall':'UTF-8'}">
{$product.name|strip_tags:'UTF-8'|escape:'htmlall':'UTF-8'}<br />
<span class="price">{$product.price}</span>
</a></p>
</li>
{/foreach}
</ul>
<p class="lnk"><a href="{$link->getPageLink('best-sales')}" title="{l s='All best sellers' mod='blockbestsellers'}" class="button_large">» {l s='All best sellers' mod='blockbestsellers'}</a></p>
{else}
<p>{l s='No best sellers at this time' mod='blockbestsellers'}</p>
{/if}
</div>
</div>

 

but when i call above code in productscategory.tpl file ,always shows "No best sellers at this time" only. But i have record in db.

How to call one module to another module

Pls help

Edited June 28, 2013 by karthick (see edit history)

[vekia]

it's because you have to edit .php file too. You have to add to smarty array variable ($best_sellers) with products

[SmartDataSoft]

It is better to build a module and add a hook on category page and than show. for this the code will be portable. when you move.