X-Cart forums

[micromedia]

This is more effective manufatucrer modul for product detail page. It is working on x-cart gold 4.1.6

manufacturer image,
manufacturer name,
link on this manufacturer page,

random 5 products from manufacturer with image, price, name


Create
modules/Manufacturers/manufacturerinfo.php

<?
if ( !defined('XCART_SESSION_START') ) { header("Location: ../../"); die("Access denied"); }

$query = "SELECT $sql_tbl[products].productid, $sql_tbl[products].product, $sql_tbl[products].descr,  $sql_tbl[pricing].price FROM $sql_tbl[products],$sql_tbl[pricing] WHERE $sql_tbl[products].forsale='Y' AND $sql_tbl[products].avail > 0 AND $sql_tbl[products].productid = $sql_tbl[pricing].productid AND $sql_tbl[products].manufacturerid = '$product_info[manufacturerid]' ORDER BY RAND() LIMIT 5" ;
$manufacturerinfos = func_query($query);
$smarty->assign("manufacturerinfos",$manufacturerinfos);


?>

Create
modules/Manufacturers/manufacturerinfo.tpl

{* $Id: manufacturerinfo.tpl,v 1.8.2.1 2007/03/19 13:12:29 max Exp $ *}
{if $product.manufacturer ne ""}

{if $manufacturerinfos}
{capture name=dialog }
<table width="100%" cellpadding="0" cellspacing="0">
  <tr>
    <td align="left" style="padding:5px;" valign="top"><a href="manufacturers.php?manufacturerid={$product.manufacturerid}"><img src="image.php?id={$product.manufacturerid}&type=M " alt="{$manufacturer}" border="0" /></a></td>
    <td align="left" style="padding:5px;" valign="top"  width="100%"><a href="manufacturers.php?manufacturerid={$product.manufacturerid}"><b>{$product.manufacturer}</b></a><br />
      {$product.manudescr|truncate:250:"...":true} <br />
      <br />
      <a href="manufacturers.php?manufacturerid={$product.manufacturerid}"><u>See All Products</u></a></td>
  </tr>
</table>
<hr/>
<table  width="100%" cellpadding="0" cellspacing="0">
  <tr > {foreach from=$manufacturerinfos item=manufacturerinfo }
    <td width="20%" valign="top"><div style="border:1px solid #ccc;padding:5px;margin:5px; text-align:center"> <a href="product.php?productid={$manufacturerinfo.productid}&amp;cat={$cat}&amp;manufacturerinfo"> <font class="ProductTitle">{$manufacturerinfo.product}</font></a><br />
        <a href="product.php?productid={$manufacturerinfo.productid}&amp;cat={$cat}&amp;manufacturerinfo"> {include file="product_thumbnail.tpl" image_x=75 productid=$manufacturerinfo.productid  product=$manufacturerinfo.product} </a><br />
       
        <font class="ProductPrice"> Our Price:&nbsp; {include file="currency.tpl" value=$manufacturerinfo.price}</font><br />
        {if $manufacturerinfo.list_price gt 0} <font class="MarketPrice"> Market Price:&nbsp;<s>{include file="currency.tpl" value=$manufacturerinfo.list_price}</s> </font> <br />
        {/if} 
		 <font size="1"> {$manufacturerinfo.descr|truncate:50:"...":true}</font><br />
		
		</div></td>
    {/foreach} </tr>
</table>
{/capture}
{include file="dialog.tpl" title=$lng.lbl_manufacturers content=$smarty.capture.dialog extra='width="100%"'}
{/if} 


{/if} 

EDIT product.php

After:

if ($active_modules["Manufacturers"])
	include $xcart_dir."/modules/Manufacturers/customer_manufacturers.php";

Add

if ($active_modules["Manufacturers"])
	include $xcart_dir."/modules/Manufacturers/manufacturerinfo.php";

EDIT skin1/customer/main/product.tpl

Add

{include file="modules/Manufacturers/manufacturerinfo.tpl" }

[YINIA]

Is this able to be used with XCart Pro?

[anandat]

Very nice mod micromedia...thanks a lot for sharing

Is there anyway I we can add number of products just after the name of manufacturer in same page ?

For example:
manufacturer XYZ <112 products) SEE ALL Products


I guess it's possible since in admin it shows how many product every manufacturer has but I can't figuer out what excatly require to change to display number of products .

I hope some x-cart guru here will help us.

[micromedia]

Originally Posted by anandat

Very nice mod micromedia...thanks a lot for sharing

Is there anyway I we can add number of products just after the name of manufacturer in same page ?

For example:
manufacturer XYZ <112 products) SEE ALL Products


I guess it's possible since in admin it shows how many product every manufacturer has but I can't figuer out what excatly require to change to display number of products .

I hope some x-cart guru here will help us.

Ok anadat.

lets add those code:

modules/Manufacturers/manufacturerinfo.php

<?
if ( !defined('XCART_SESSION_START') ) { header("Location: ../../"); die("Access denied"); }

$query = "SELECT $sql_tbl[products].productid, $sql_tbl[products].product, $sql_tbl[products].descr,  $sql_tbl[pricing].price FROM $sql_tbl[products],$sql_tbl[pricing] WHERE $sql_tbl[products].forsale='Y' AND $sql_tbl[products].avail > 0 AND $sql_tbl[products].productid = $sql_tbl[pricing].productid AND $sql_tbl[products].manufacturerid = '$product_info[manufacturerid]' ORDER BY RAND() LIMIT 5" ;
$manufacturerinfos = func_query($query);
$smarty->assign("manufacturerinfos",$manufacturerinfos);

$totalmanuprod = "SELECT COUNT(*) FROM $sql_tbl[products] WHERE $sql_tbl[products].forsale='Y' AND $sql_tbl[products].avail > 0 AND $sql_tbl[products].manufacturerid = '$product_info[manufacturerid]' " ;
$totalmanuprods = func_query_first_cell($totalmanuprod);
$smarty->assign("totalmanuprods",$totalmanuprods);
?>

modules/Manufacturers/manufacturerinfo.tpl

{* $Id: manufacturerinfo.tpl,v 1.8.2.1 2007/03/19 13:12:29 max Exp $ *}
{if $product.manufacturer ne ""}

{if $manufacturerinfos}
{capture name=dialog }
<table width="100%" cellpadding="0" cellspacing="0">
  <tr>
    <td align="left" style="padding:5px;" valign="top"><a href="manufacturers.php?manufacturerid={$product.manufacturerid}"><img src="image.php?id={$product.manufacturerid}&type=M " alt="{$manufacturer}" border="0" /></a></td>
    <td align="left" style="padding:5px;" valign="top"  width="100%"><a href="manufacturers.php?manufacturerid={$product.manufacturerid}"><b>{$product.manufacturer}</b></a> ( {$totalmanuprods} products)<br />
      {$product.manudescr|truncate:250:"...":true} <br />
      <br />
      <a href="manufacturers.php?manufacturerid={$product.manufacturerid}"><u>See All Products</u></a></td>
  </tr>
</table>
<hr/>
<table  width="100%" cellpadding="0" cellspacing="0">
  <tr > {foreach from=$manufacturerinfos item=manufacturerinfo }
    <td width="20%" valign="top"><div style="border:1px solid #ccc;padding:5px;margin:5px; text-align:center"> <a href="product.php?productid={$manufacturerinfo.productid}&amp;cat={$cat}&amp;manufacturerinfo"> <font class="ProductTitle">{$manufacturerinfo.product}</font></a><br />
        <a href="product.php?productid={$manufacturerinfo.productid}&amp;cat={$cat}&amp;manufacturerinfo"> {include file="product_thumbnail.tpl" image_x=75 productid=$manufacturerinfo.productid  product=$manufacturerinfo.product} </a><br />
       
        <font class="ProductPrice"> Our Price:&nbsp; {include file="currency.tpl" value=$manufacturerinfo.price}</font><br />
        {if $manufacturerinfo.list_price gt 0} <font class="MarketPrice"> Market Price:&nbsp;<s>{include file="currency.tpl" value=$manufacturerinfo.list_price}</s> </font> <br />
        {/if} 
		 <font size="1"> {$manufacturerinfo.descr|truncate:50:"...":true}</font><br />
		
		</div></td>
    {/foreach} </tr>
</table>
{/capture}
{include file="dialog.tpl" title=$lng.lbl_manufacturers content=$smarty.capture.dialog extra='width="100%"'}
{/if} 


{/if} 

It will be work. it shows number of product next to manufacturer name
like : manufacturer xyz (23 products)

[aslater]

Thanks micromedia just what we needed and looks great

[flyclothing]

Micromedia,

Definitely one of the best additions I have seen! I think this mod would be a great replacement for the upselling or related mod because your mod automatically pulls all products under that manufacturer or category and the related mod has to be done manually.

I have a few questions. The image for the manufacturer is not showing up, even though I have an image when I go under the category. What do you think might be the issue here?

If I did want to replace the related mod, where I could put the code you provided?

Thanks again. Excellent mod!

[flyclothing]

So I have been trying to match the "Customers who bought this..." mod to the format of the "Manufacturer's mod" and cant figure it out for the life of me.

Here is the code:

{if $also_bought_products|@count gt 0} {capture name=also_bought}
<table width="100%" cellpadding="0" cellspacing="0" border="0"><tr>
{section name=i loop=$also_bought_products}
{* SAFETYNET DSEFU MOD *}
{if $enable_seo_links == "Y"}
<td width="20%" valign="top"><div style="border:1px solid #ccc;padding:5px;margin:5px; text-align:center">
<p style="margin-top: 0; margin-bottom: 0"><b><A href="{seo_link prod_name=$also_bought_products[i].product prod_id=$also_bought_products[i].productid}" target="{$targetwin}">{$also_bought_products[i].product}</a></b></p>
<p style="margin-top: 0; margin-bottom: 0"><A href="{seo_link prod_name=$also_bought_products[i].product prod_id=$also_bought_products[i].productid}" target="{$targetwin}">{include file="product_thumbnail.tpl" image_x=100 productid=$also_bought_products[i].productid product=$also_bought_products[i].product tmbn_url=$also_bought_products[i].tmbn_url}</a></div></td>
{else}
{/if}
{* END SAFETYNET DSEFU MOD *}
</tr>
{/section}
</table>
{/capture} {include file="dialog.tpl" title="Customers who bought this also bought..." content=$smarty.capture.also_bought extra="width=100%"}{/if}

What would need to be changed to make this match the manufacturer's mod format with 5 products in a row? Is it simply a "for each" argument or something more?

[ProMuscles]

Great mod but in addition to more info can you add a button buy now

[ProMuscles]

I can not get it to work. Is it confirmed working?

[aslater]

Originally Posted by ProMuscles

I can not get it to work. Is it confirmed working?

Works for me and i am using 4.1.6 as well

http://www.bitzdirect.com/product.php?productid=6&cat=0&page=1