E commerce

- February 15, 2009

Magento product page : how to display other products from same category

Magento comes with a lot of product relationship features :  implemented as selective lists maintained for each product by the shop owner, related / cross selling and up selling backend features allow some sort of manual product linking that displays product associations on the front end. For example related products are displayed by default in the product page right column, while upsell / crosssell products are displayed on the shopping cart page. These 3 types of product associations are well explained on inchoo’s blog, and  on magento ’s knowledge base you’ll find user instructions on how to setup   product relationship in the backend.

What we aim here is to setup an automatic  display of related products on a product view page, via the categories they belong to. We build two loops : one that gets categories the product belongs to, and another one inside that gets products of each category.

How to setup category related products in Product view :

  1. add the following code somewhere in default\template\catalog\product\view.phtml
  2. Configure the category query according to your catalog by uncommenting the following :
    • ->setPage(1, 1) : selects only one category
    • ->addFieldToFilter(’level’,”3″) : selects only 3rd level categories
    • ->addFieldToFilter(’parent_id’,”3″) : select only child categories of no 3
    • ->setOrder(”level”) : combined by setPage, returns the lowest level category
  3. please that the product loop uses the $_product variable, which can be dangerous because this name is widely used. We use it here for comodity reasons because I just took toe display code from Magento’s product list view
  1. if ($_product) {
  2.   // get collection of categories this product is associated with
  3.   $categories =$_product->getCategoryCollection()
  4.   //  ->setPage(1, 1)
  5.  //->addFieldToFilter(’level’,"3")                                     
  6.  //->addFieldToFilter(’parent_id’,"3")                                 
  7.  //->setOrder("level")
  8.    ->load();
  9.        
  10. // if the product is associated with any category
  11. if ($categories->count())
  12. foreach ($categories as $_category)
  13. {
  14.   $cur_category = Mage::getModel(‘catalog/category’)->load($_category->getId());
  15. ?><div style="clear:both">
  16. <h2>Dans la même collection :<?=$cur_category->getName()?></h2>
  17. </div>
  18. <?$products = Mage::getResourceModel(‘catalog/product_collection’)
  19. ->addCategoryFilter($_category)
  20. ->addAttributeToSelect(’small_image’);
  21.  
  22.  foreach ( $products as $productModel )
  23.    {
  24.         $_product = Mage::getModel(‘catalog/product’)->load($productModel->getId());
  25.           $width=135; $height=135;
  26.          $_imageUrl =  $this->helper(‘catalog/image’)->init($productModel, ’small_image’)->resize($width, $height);
  27. ?>
  28.   <div class="product-shop">
  29.    <h5><a href="<?php echo $_product->getProductUrl() ?>" title="<?php echo $this->htmlEscape($_product->getName()) ?>">
  30. <?php echo $this->htmlEscape($_product->getName())?></a></h5>
  31.  
  32.  <img src=<?=$_imageUrl ?> width="<?=$width?>" height="<?=$height?>"/>
  33. <?php echo $this->getPriceHtml($_product, true) ?>
  34.    <?php if($_product->isSaleable()): ?>
  35.  <button class="form-button" onclick="setLocation(’<?php echo $this->getAddToCartUrl($_product) ?>’)"><span><?php echo $this->__(‘Add to Cart’) ?></span></button>
  36.  <?php else: ?>
  37.   <div class="out-of-stock"><?php echo $this->__(‘Out of stock’) ?></div>
  38.      <?php endif; ?>
  39.      <div class="clear"></div>
  40.       <div class="description">
  41.        <?php echo nl2br($_product->getShortDescription()) ?>
  42.     <a href="<?php echo $_product->getProductUrl() ?>" title="<?php echo $this->htmlEscape($_product->getName()) ?>"><small><?php echo $this->__(‘Learn More’) ?></small></a>
  43.             </div>
  44.     </div>
  45. <?  }  
  46.   }
  47. }
  48. ?>

  1. 13 Responses to “Magento product page : how to display other products from same category”

  2. This works great, except for the fact that it breaks the actual product page you’re on. All the products now share the same name (But they all have their correct title tag and description…), and they all have the same add to cart link.

    Halfway there!

    By Justin on Feb 16, 2009

  3. Well I don’t experience that bug : are you sure you put the code at the bottom of category/product/view.phtml

    otherwise make sure you don’t mix the $_product page variables with the new loop that also uses $_product variables : if you’re not lazy like I am just change the variable name inside the loop and that might solve what looks like a variable name issue

    By admin on Feb 16, 2009

  4. Hi, this is not very hard but requires you to follow the tutorial here

    http://www.webmasterbulletin.net/2008/12/how-to-install-magento-free-themes/564

    let me know how it goes, is your site public yet ?

    By admin on Mar 30, 2009

  5. How shall this work out, when I only paste the code above into the view.phtml there is the opening tag <?php missing, so I would definitely cause a php error as the last on that page is a closing tag. So, I added the missing php tag before the code right after the last div of the page and the whole product page disappears. I do not know what version you worked with, this is still with 1.2.1.2 and a custom template, but this should also work in any custom view phtml but sadly does not.

    By How? on Apr 20, 2009

  6. @HOW : you have to paste this code after the existing code in view.phtml

    By admin on Apr 20, 2009

  7. hi i have teh code installed and working, but i have a large number of products per category and as a result it takes a while to load. Do you know how to limit the query to say pick out 4 items and return those

    By nigel on May 2, 2009

  8. also to help anyone who may have issues – check the code for any errant formatting after pasting the code – specifically check where the ‘ are supposed to be in areas like
    __(’Out of stock’) ?>

    By nigel on May 2, 2009

  9. hi nigel, common magento query limit statement : add the following to line 21, should do the job

    $products->getSelect()->limit(4)

    By admin on May 3, 2009

  10. In magento how to show product category in the admin with product listing

    By saphia on May 6, 2009

  11. If you want to get random products from same category, put at line 21 this code:

    $products->getSelect()->order(’rand()’);

    By Deter on Aug 5, 2009

  12. This is great code. How would you display the category products with same manufacturer?

    Thanks!

    By Matt on Nov 2, 2009

  13. Gave me the direction I needed … thanks!

    By onionlips on Nov 13, 2009

  14. I want to show only “in stock” products on one page & both “in stock” and “out of stock” products on other page from same category. How can i do that…? Please help me on this. Its really an urgent. Waiting for your positive reply.

    By pankaj on Nov 18, 2009

Post a Comment

© 2010 - Webmaster Bulletin - Powered by WordPress. Design by WPThemeDesigner.com.