Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Show all products of the same categorie and same manufacturer


Moleiro

Recommended Posts

Posted

Hi everyone

 

I need help in order to find out if there is a way or if it is possible to have a way to show all the products from a specific categorie and same manufacturer.

I mean let's imagine I have the categories "Shoes", "T-shirts" and "Shorts" and inside those categories I have products from Nike, Adidas, Puma etc...

What I want to do is to show all the Shoes from Nike, but just the shoes and not the T-shirts and Shorts.

I know via the Manufacturers menu I can show every product from a certain manufacturer but that way it shows EVERYTHING.

 

Thank you very much in advance

Posted
Hi everyone

 

I need help in order to find out if there is a way or if it is possible to have a way to show all the products from a specific categorie and same manufacturer.

I mean let's imagine I have the categories "Shoes", "T-shirts" and "Shorts" and inside those categories I have products from Nike, Adidas, Puma etc...

What I want to do is to show all the Shoes from Nike, but just the shoes and not the T-shirts and Shorts.

I know via the Manufacturers menu I can show every product from a certain manufacturer but that way it shows EVERYTHING.

 

Thank you very much in advance

 

It's possible to show anything .. and certainly possible to do what you are asking.

 

But if your question is .. Is there currently a contribution available then I'm afraid I don't know.

Posted
It's possible to show anything .. and certainly possible to do what you are asking.

 

But if your question is .. Is there currently a contribution available then I'm afraid I don't know.

 

Thank you for your reply anyway.

Since I am new to php, I tried to search for a contribution to do what I want...but no luck.

 

Anyone got a clue?

 

Thank's to everyone.

Posted

I found a very neat example of what I wanna do.

 

Please check this store: http://shops.oscommerce.com/directory/goto,26418

 

When you click in SKATEBOARDS and then DECKS it lists all skateboard decks, but in the top of the page there is several links that are manufacturers and when you click on one of that manufacturer it lists all products from categorie SKATEBOARD-->DECKS from that manufacturer you've just clicked.

 

Anyone have a clue on how to do something like this?

 

Thanks

Posted

Admin>Configuration>Product Listing>Display Category/Manufacturer Filter (0=disable; 1=enable) will show a dropdown box with manufacturers. I am sure if you had some experience with the code, you could have it show a table (list) rather than a box.

Posted
Admin>Configuration>Product Listing>Display Category/Manufacturer Filter (0=disable; 1=enable) will show a dropdown box with manufacturers. I am sure if you had some experience with the code, you could have it show a table (list) rather than a box.

 

Thank's man, this is what I need. By the way do you know which file do I need to edit in order to change the way that information is showed?I would like to have a image for each manufacturer of the categorie filter.

I am new to code and all this php stuff, but I'm familiar with html so I'm gonna try to learn by trying to change little things and see what happen.

 

Thank's for your reply.

Posted

I found it.

Now I know it's in index.php and in this code:

 

// optional Product List Filter
if (PRODUCT_LIST_FILTER > 0) {
  if (isset($HTTP_GET_VARS['manufacturers_id'])) {
	$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";
  } else {
	$filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";
  }
  $filterlist_query = tep_db_query($filterlist_sql);
  if (tep_db_num_rows($filterlist_query) > 1) {
	echo '			<td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';
	if (isset($HTTP_GET_VARS['manufacturers_id'])) {
	  echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);
	  $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));
	} else {
	  echo tep_draw_hidden_field('cPath', $cPath);
	  $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));
	}
	echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);
	while ($filterlist = tep_db_fetch_array($filterlist_query)) {
	  $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);
	}
	echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');
	echo tep_hide_session_id() . '</form></td>' . "\n";
  }
}

 

Since I am new to php, I don't have any idea on what I should do...

All I need is to replace the drop down manufacturer list with table rows with the manufacturers name. It will be awesome to use images instead of the text links but I know it's probably asking for too much so helping on replace the drop down for table rows with the links will be awesome.

 

Here is an example with the text links above the products just as i want to do:

 

http://www.shopidentity.com/index.php?cPath=5_17

 

And here is another example with the images instead of text links:

 

http://www.quartershop.com/index.php?main_...&cPath=1_42

 

Help Please!!!

Archived

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

×
×
  • Create New...