• Eyelash / php jquery image management

    • 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. 20 Responses to “Magento product page : how to display other products from same category”

    2. February 16, 2009 - Justin

      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!

    3. February 16, 2009 - admin

      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

    4. March 30, 2009 - admin

      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 ?

    5. April 20, 2009 - How?

      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.

    6. April 20, 2009 - admin

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

    7. May 2, 2009 - nigel

      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

    8. May 2, 2009 - nigel

      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’) ?>

    9. May 3, 2009 - admin

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

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

    10. May 6, 2009 - saphia

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

    11. August 5, 2009 - Deter

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

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

    12. November 2, 2009 - Matt

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

      Thanks!

    13. November 13, 2009 - onionlips

      Gave me the direction I needed … thanks!

    14. November 18, 2009 - pankaj

      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.

    15. September 15, 2010 - gggggggg

      Can anyone confirm if this works with 1.4.1.1 ?

    16. September 24, 2010 - Pranav

      I want to show bestseller or most viewed products at the below part on the product view page, can anybody please help ?

    17. February 2, 2011 - Danny

      Great! Really great! Even works in Magento 1.5. Thank you!

    18. April 2, 2011 - vignesh

      I have to show only enabled product. it shows all the products

    19. March 1, 2012 - Saurabh

      Hello Paul,
      Can you help me…
      I need to display all enabled product in category view page in Magento.

      Thanks

    20. August 11, 2012 - コスプレ衣装

      Gredit job,I use this code in my site magento 1.5,and everything is good.

    1. 1 Trackback(s)

    2. May 5, 2011: Magento - Display other products from the same category - Paul Donnelly - Website Designer and Developer from Northern Ireland

    Quick contact form

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