Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

product listing changes


Aenarion

Recommended Posts

I m trying to add manufacturer bellow the product name. The problem is that if I added from the admin menu it's going on the next column. I just want to add the manufacturer name under the product name.

 

any ideas?

 

cheers

Link to comment
Share on other sites

Your trying to do this where exactly?

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Similar is done with this:

Product Listing Enhancements, Thumbnails & Manufacturer Headings

http://addons.oscommerce.com/info/6051

 

Use that or see what is does to set yours.

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Thanks Sam for the great respond.

 

I tried the contribution but when i do thumbnails i get a message devide by 0, I m using some other contribs such as Seperate pricing per customer etc.

 

Anyway I put this code in the switch where it prints the name :

 

case 'PRODUCT_LIST_NAME':



$manufacturer_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p where p.products_id = '" . $listing[$x]['products_id'] . "' and p.manufacturers_id = m.manufacturers_id"); 



$manufacturer = tep_db_fetch_array($manufacturer_query);



$lc_align = '';



if (isset($HTTP_GET_VARS['manufacturers_id'])) {



$lc_text = $manufacturer ['manufacturers_name'] . '

' . $listing[$x]['products_name'] . '';



} else {



$lc_text = $manufacturer ['manufacturers_name'] . '

' . $listing[$x]['products_name'] . '';



}



break;

----------------------------

Bellow the result. Exactly what I needed to get the name of the manufacturer over the product name.

 

screenshotxq7.gif

 

The only thing i m considering is that the code would be an overkill for the database. Since every time the name is listed it's s checking 2 tables MANUFACTURERS & PRODUCTS to get the name of the manufacturer.

 

I m not sure what do you think?

Link to comment
Share on other sites

Did you run the Product Listing Setup detailed in the install? if you havent that could cause your error.

 

Yes, I think that would create way too many queries, unless you only have a small product list.

 

Better aproach would be to follow the one I used, get the manufacturer, then show all product in list for that one, then next manufacturer.

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Did you run the Product Listing Setup detailed in the install? if you havent that could cause your error.

 

Yes, I think that would create way too many queries, unless you only have a small product list.

 

Better aproach would be to follow the one I used, get the manufacturer, then show all product in list for that one, then next manufacturer.

 

Indeed i didnt do any setup, i just copied the file over my.

 

The best thing would be to add the manufacturer name in the $listing array so i can call something like this, $listing[$x]['manufacturer_name']. The problem is i cant understand where in the code exactly this list is generated.

 

cheers

Link to comment
Share on other sites

Indeed i didnt do any setup, i just copied the file over my.

 

The best thing would be to add the manufacturer name in the $listing array so i can call something like this, $listing[$x]['manufacturer_name']. The problem is i cant understand where in the code exactly this list is generated.

 

cheers

 

 

I have produced an update to Product Listing Enhancements, Thumbnails & Manufacturer Headings

 

It can now show the manufacturer name in the thumbnail, and you can now set the position order (vertically) of everything in the thumbnail.

 

I`ll have this up soon, it will be v1.3

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

There is a way to get your display, enable manufacturers list in admin, then delete both:

 

case 'PRODUCT_LIST_MANUFACTURER':
		$lc_align = '';
		$lc_text = ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a> ';
		break;

 

sections (thier not the same)

 

change name section to:

 

$listing['manufacturers_name'] . '<br>'.$listing['products_name']

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...