Tuesday, 29 September 2015

Show Categories Which Are not Included in Navigation Menu in Magento


Get categories list which are not include in Navigation in magento.

Some time you want that are not added in navigation but categories active and you want to
get or listing.

<ul class="full_category">
<?php $_categories = Mage::getResourceModel('catalog/category_collection')
    ->addAttributeToFilter('is_active', 1) //only active categories
    ->addAttributeToFilter('include_in_menu', 0)
    ->addAttributeToSort('position');//sort by position

foreach ($_categories as $_category) { ?>
<li class="cat">
<a href="<?php echo $_helper->getCategoryUrl($_category) ?>" title="<?php echo $_category->getName() ?>"><strong class="strongsm"><?php echo $_category->getName() ?></strong></a>
<?php }?>

Monday, 28 September 2015

Get All Cms Page in magento


Some Time You need to add Cms page in your site map. you need your page page link and name.
I have same issue. I getting for query and use it's working. you can try it.

Get all Cms Page in Magento

$storeId = $this->helper('core')->getStoreId(); // thanks to drawandcode for this
$cms = Mage::getModel('cms/page')->getCollection()
->addFieldToFilter('identifier',array(array('nin' => array('no-route','enable-cookies'))))
$url = Mage::getBaseUrl();
$html = "";
foreach($cms as $cmspage):
$page = $cmspage->getData();
if($page['identifier'] == "home"){
echo  "<li><a href=\"$url\" title=\"".$page['title']."\">".$page['title']."</a></li>\n";
} else {
echo "<li><a href=\"$url".$page['identifier']."\" title=\"".$page['title']."\">".$page['title']."</a></li>\n";

include , require and require_once , include_once in php

 include , require and require_once , include_once in php 

include, require and require_once,include_once are used to include a file into the PHP code

for example of include and require

<h1>Welcome to My blog!</h1>
<?php include 'header.php';

it can added file in php code.

in require example

<h1>Welcome to My blog!</h1>
<?php require 'header.php';

difference between  include and require

 when a file is included with the include statement and PHP cannot find it, the script will continue to execute


the echo statement will not be executed because the script execution dies after the require statement returned a fatal error


It can be used include a PHP file another one, it can used to add files once. If it is found that the file has already been included, calling script is going to ignore further inclusions.


include_once('name of the called file with path');


<?php include_once('xyz.php'); 


same as require_once used.

<?php require_once('example.php')  ?>

include_once and require_once same different with include and require.

Difference between Echo And Print In Php


Here I can Give both of use echo and print in php. I give example and use.

Echo and Print are almost same. they are both output on screen. they are used with and without

Difference Echo And Print

  1. print return value and echo not return value.
  2. echo faster than print.
  3.  echo without parentheses can take multiple parameters, which get concatenated but print give error.

How Can Use.

$data = "hello".
$data1 ="jaydip";

echo "<h2>My echo information</h2>";
echo "namste !<br>";

echo $data."".$data1;

echo without parentheses can take multiple parameters 
echo "jj","123",1,3;

same like in Print:

$data = "hello".
$data1 ="jaydip";

print "<h2>My echo information</h2>";
print "namste !<br>";

print $data."".$data1;

you can use as print in 
($test==2) ? print "true" : print "false";

Thursday, 24 September 2015

Filtering a Magento product collection by multiple categories and Stock item and filter current product in product detail page


I  Want to create section to get same product of different categories of products with Stock or quantity.

after i want get product of minimum of product quantity 50%.

for that i will join 'cataloginventory/stock_item', and  'catalog/category_product'  get this collection.

this section create in product detail page that why i am filter current product using it product id.

Please Below Code it help to you.

$product_id = Mage::registry('current_product')->getId();
    $category_ids = $_product->getCategoryIds();
$collection = Mage::getModel('catalog/product')->getCollection()
 ->addAttributeToFilter('entity_id', array('neq' => $product_id))
 ->addAttributeToFilter('status', 1)
$conditions = array();
foreach ($category_ids as $categoryId) {
 if (is_numeric($categoryId)) {
  $conditions[] = "{{table}}.category_id = $categoryId";
->joinField('category_id', 'catalog/category_product', null, 'product_id = entity_id', implode(" OR ", $conditions), 'inner');
 foreach ($collection as $_item) {
    //echo $_item->getName()."</br>";
     $product_qty = $_item->getQty();
     $product_qty = round($product_qty);
    $product_qty = $product_qty/100;
    if($product_qty >= 0.5){
        echo $_item->getName()."</br>";

Please Below code it help getting products.

Thursday, 17 September 2015

Price LessThan 1000 Get Products in Magento


Here I am Create Custom Query for Product list. I want to get all product that price
less than 1000 in magento. I am Giving Example for that

First Create Cms page goto Cms=>page

in cms page
goto design=>Layout Update XML

Write below code in xml

<reference name="root">
<action method="setTemplate"><template>page/2columns-left.phtml</template></action>
 <action method="unsetChild"><alias>breadcrumbs</alias></action>    
    <block type="page/html_breadcrumbs" name="breadcrumbs" as="breadcrumbs">
        <action method="addCrumb">
        <action method="addCrumb">
            <crumbName>Custom Page</crumbName>
            <crumbInfo><label>1000 Under</label><title>1000 Under</title></crumbInfo>

<reference name="left">
     <block type="catalog/navigation" name="catalog.categorymenu" before="catalog.leftnav" template="catalog/product/categorymenu.phtml"/>

<reference name="content">
<block type="catalog/product_new" name="product_list" template="catalog/product/list.phtml">
<block type="catalog/product_list_toolbar" name="product_list_toolbar" template="catalog/product/list/toolbar.phtml">
<block type="page/html_pager" name="product_list_toolbar_pager"/>
<action method="setToolbarBlockName"><name>product_list_toolbar</name></action>

after create block in your app\code\local\Mage\Catalog\Block\Product\new.php

Write this code for that


class Mage_Catalog_Block_Product_New extends Mage_Catalog_Block_Product_List 
   function get_prod_count() 
      //unset any saved limits 
      return (isset($_REQUEST['limit'])) ? intval($_REQUEST['limit']) : 12;//set your page limit 
   }// get_prod_count 

   function get_cur_page() 
      return (isset($_REQUEST['p'])) ? intval($_REQUEST['p']) : 1; 
   }// get_cur_page 

    * Retrieve loaded category collection 
    * @return Mage_Eav_Model_Entity_Collection_Abstract 
   protected function _getProductCollection() 

      $collection = Mage::getModel('catalog/product')
                        ->setOrder('price', 'ASC')
                        ->addAttributeToFilter('price', array('lt' => '1001'))
                        ->addFieldToFilter('status', array('eq' => '1')


      return $collection; 
   }// _getProductCollection 
}// Mage_Catalog_Block_Product_New 


Tuesday, 15 September 2015

Magento Category Product Listing Sort by Most Viewed Product


You Just want to orverride app\code\core\Mage\Catalog\Block\Product\List\Toolbar.php

paste in code\local\Mage\Catalog\Block\Product\List\Toolbar.php


first add your most viewed in sort by product select box

 public function getAvailableOrders()


       $this->addOrderToAvailableOrders('mostviewd', 'MOST POPULAR');

        return $this->_availableOrder;\\you can add this code here

 public function setCollection($collection)


if ($this->getCurrentOrder()) {

               if($this->getCurrentOrder()=='mostviewd') {
joinInner('report_event AS _table_views',
' _table_views.object_id = e.entity_id',
'COUNT(_table_views.event_id) AS views')->
group('e.entity_id')->order('views DESC');



add this code and check the result.

Monday, 14 September 2015

Magento Product View Count in Product List Page and Product View Page


Some Time You Want to display how many time product view count in magento

I am Give Simple Code it can be used in both product list page it can paste in loop then

it will display every product totoal view count. and product view page current product view

$id = $id=$_helper->productAttribute($_product, $_product->getId(), 'id');

$mostviewedProducts = Mage::getResourceModel('reports/product_collection')->addViewsCount();

            foreach($mostviewedProducts as $product) {
    echo $id."<br/>";
    echo $_product->getId()."<br/>";
   echo $product->getData('entity_id')."<br/>";
    echo  "Total View Count: " . $product->getData('views');

You can add time duration in

$fromDate = '2013-12-10';
$toDate   = now();

$id = $id=$_helper->productAttribute($_product, $_product->getId(), 'id');

$mostviewedProducts = Mage::getResourceModel('reports/product_collection')->addViewsCount($fromDate,$toDate);

            foreach($mostviewedProducts as $product) {
    echo $id."<br/>";
    echo $_product->getId()."<br/>";
   echo $product->getData('entity_id')."<br/>";
    echo  "Total View Count: " . $product->getData('views');

Sunday, 13 September 2015

Get Most view products of current product categories in product detail page(view.phtml) in magento


Here Qurery for Create Most View product of current product of categories

This Section Query used Most view Product view in magento. it's difficult to get because

I am seaching but to get proper result. after i get solution from different different reference

site. i am will give proper guide for that. it success to use it.

    $storeId = Mage::app()->getStore()->getId();
            $category_ids = $_product->getCategoryIds();
            /** date range product view count */
            $toDate   = now();
           $product_id = Mage::registry('current_product')->getId();

$products = Mage::getResourceModel('reports/product_collection')
    ->setPageSize(5)//set the pae size
    ->addAttributeToFilter('category_id', array('in' => $category_ids ));


here one problem you face if current product detail page in this section then you have

I have issue when I go to  section on product detail page; the current product is also getting displayed on this. I just need to remove the current product from  section.

it's soultion is that without change query

foreach($products as $_item){

    $myid =  $_item->getId();

    if ($myid !=  $product_id ){

<?php echo $_item->getProductUrl() ?>



Wednesday, 9 September 2015

When On Particular Category adding a product in admin side then product name should be created automatically using product attributes like weight,sizing Magento


I am Adding Product Admin Side. But When Particular category then it can be automatically
generate Product name. like it's Attributes. I Give Reference for that I give Example For That.

Create Simple Module.


Create Easylife_Meta.xml Here.

<?xml version="1.0"?>
                <Mage_Catalog />


Create config.xml

<?xml version="1.0"?>


Create File Observer.php


class Easylife_Meta_Model_Observer
    public function createName($observer)
        $product = $observer->getEvent()->getProduct();
       $data = $observer->getEvent()->getCategory();
        $product_category_id = $product['category_ids'];
        $productColor = $product->getWeight('weight');
        $productsizing = $product->getAttributeText('sizing');
       if (!empty($product_category_id)) {
        if (in_array("9", $product_category_id)){ // Here 9 in My Category ID
            $productSku = $productColor." ".$productsizing;

Here You can generate name for particular category. you can also change all product remoce if
contion  $product->setName($productSku); set here your value. here 9 is my category
you can check your category id then check it.

Monday, 7 September 2015

Magento Admin Password Reset in Localhost or Local Machine (Magento Password Reset is not Working)


How To Reset Magento Password In Localhost and Magento Site Using Phpmyadmin

I am changing Magento password reset. I Follow The tutorial but in my magento it's not working.

Simple How to reset Password in magento Check this.

You can reset your Magento admin password directly through the database related to your website.

You can use Phpmyadmin Tool.

UPDATE `admin_user` SET `password` = MD5('NEWPASSWORD') WHERE `username` = 'ADMINUSERNAME';

some time you don't know your magento database then you can check you database


<![CDATA[test_magento]]> =>//it's your database name.

you can reset your password using php myadmin ui 

check out below step 

Step 1:

Step :2 

Step 3:

I am Set this but some time it's not Working it make issue in localhost

You can remove Cache and session Folder Var Folder

otherwise not woking then 
follow below Step


$cookieParams = array(
            'lifetime' => $cookie->getLifetime(),
            'path'     => $cookie->getPath() //,
            // 'domain'   => $cookie->getConfigDomain(),
            // 'secure'   => $cookie->isSecure(),
            // 'httponly' => $cookie->getHttponly()

commet this display in code.