Php – How to display all products on the homepage in magento 1.7

magentomagento-1.7PHPshopping-cart

I managed to display new products and product by category with these

{{block type="catalog/product_new" column_count="6" products_count="3"
name="home.catalog.product.new" alias="product_homepage"
template="catalog/product/new.phtml"}}

{{block type="catalog/product_list" category_id="10"
template="catalog/product/list.phtml"}}

But I actually want display entire products in my store regardless their categories, is it possible?

My root category id is 3, so I tried with this line but no luck at all,

{{block type="catalog/product_list" category_id="3"
template="catalog/product/list.phtml"}}

Any ideas?

I am using the sample data to test magento, so I have this below in the data,

Root Catalog (0) 
    Furniture (7) 
    Electronics (42) 
    Apparel (66)

EDIT:

home.phtml

<?php
/**
 * Magento
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Academic Free License (AFL 3.0)
 * that is bundled with this package in the file LICENSE_AFL.txt.
 * It is also available through the world-wide-web at this URL:
 * http://opensource.org/licenses/afl-3.0.php
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@magentocommerce.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade Magento to newer
 * versions in the future. If you wish to customize Magento for your
 * needs please refer to http://www.magentocommerce.com for more information.
 *
 * @category    design
 * @package     base_default
 * @copyright   Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
 * @license     http://opensource.org/licenses/afl-3.0.php  Academic Free License (AFL 3.0)
 */
?>
There was no Home CMS page configured or found.

Best Answer

You can edit your home.phtml file and fetch the products manually

$products = Mage::getModel('catalog/category')->load($your_category_id)
->getProductCollection()
->addAttributeToSelect('*')
->addAttributeToFilter(
    'status',
    array('eq' =>'1')
);

And for all products you can do this

$products = Mage::getModel('catalog/category')
->getProductCollection()
->addAttributeToSelect('*')
->addAttributeToFilter(
    'status',
    array('eq' =>'1')
);
Related Topic