X-Cart forums

[mizzlewillz]

Hello,

I was trying to figure this out, but couldn't seem to get the SQL right. ( I believe that is where my problem is).

What would I have to do to display the product's manufacturer in the product's detailed page. I want to use the manufacturer's table in the database, but can't seem to get it to work.

Any ideas?

Thanks in advance for any comments / suggestions!!

-mike

[twulff]

This is the way I have done it:

# changes to product.php
add this code somewhere before the smarty assigns will happen like line #112
#
# Get the real manufacturer
#
$thisManufactorer = $product_info["manufacturerid"];
$manufacturer = func_query("SELECT * FROM $sql_tbl[manufacturers] WHERE manufacturerid = $thisManufactorer");
$smarty->assign("manufacturer", $manufacturer[0]["manufacturer"]);

#changes to customer/main/product.tpl
# where to place the code is up to you
<tr><TD align="left" valign="top">
Producer:

</td>
<TD align="left" valign="top">
{$manufacturer}
<font size=1 face=Arial>(click to get all productions of this producer)</font>

</td>
</tr>

I hope this will help you a little bit

[adpboss]

Mike,

Please add your version number and server info to your forum signature.

[thundernugs]

thomas,
very cool mod indeed. works perfect in 4.0.2.

nice work!

[carbonpixel]

does anyone have a link that shows this working...?

My problem is that I want to setup categories and sub categories (example --- bath & body [category], soaps [subcategory].

Then I want to add a product to this (or possibly more categories).

Now the key thing is that when I create a new product I want to enter the manufacture (or select from a list of manufactures directly from the product page).

I now want to give the customer the ability of viewing all the manufactures and when he selects one it shoud lists all the products categorized in categorises/subcategories.

A customer should also be able to search for a manufactures and have all products listed.

[thundernugs]

what version are you running?

manufacturers was incorporated into version 4

you can see the manufacturer listed on the product page on my site here:

http://www.netmedicalsupply.com/store/catalog/BioStim-M7-Digital-TENS-Unit-p-22161.html

live site, so no test orders please

notice the manufacturer listing on the lower left, and the ability to search for mfr in the advanced search page.

ver 4 also allow unlimited categories/subcategories

hth,
mike

[jmdabb]

Great, I got manufacturer on product page, now how do I get it to show on the Invoice.

I'm using xcart for a bookstore and client wants author (manufacturer) to show under each product title.

http://www.books-newzealand.co.nz (live site, no test orders please)

version 4.04

[adpboss]

Modified TPL code for my purposes.

Advantages, only show Manufacturer if the manufacturer exists for that product. I also turned off the absolute link to the manufacturers.php and went with the relative link.

{if $manufacturer ne ""}
<tr><TD align="left" valign="top"> 
Manufacturer:
 
</td> 
<TD align="left" valign="top"> 
{$manufacturer}
<font size=1 face=Arial>(Click to get more information about this manufacturer)</font>
 
</td> 
</tr>
{/if}

[PhilJ]

Based on this, does anyone know how to get the manufacturer's description to display on product.tpl ?

I tried

{$manufacturer.descr|escape}

but that doesn't work - it just shows the first character of the manufacturer's name and nothing of the description.

[mffowler]

For manufacturer name, not description of:

All I did was put the following code in the customer/main/product.tpl:

<TR><TD align="left" valign="top">{$lng.lbl_manufacturer}:</TD>
<TD align="left" valign="top">{$product.manufacturer}</TD>
</TR>

... and now my product's manufacturer is in the product details page.

- Mike