Magento, Jquery,PHP

How to override catalogsearch model class in magento

2011-12-28T17:20:00.001+05:30

In magento if you wish to override some controller then definately you will get lots of site which will describe how to do that but for model class, you will have some result. So I think to share my knowledge here. I am going to override default catalog search Model of magento. For that I will create an module with name space name Mage and module name Searchby. I hope you people know how to create an module so I will show you how to override model class only

Go to config.xml of your custom module then write the below code to override the catalogsearch model class

<?xml version="1.0" encoding="UTF-8"?> <config> <modules> <Mage_Searchby> <version>0.1.0</version> </Mage_Searchby> </modules> <frontend> <routers> <searchby> <use>standard</use> <args> <module>Mage_Searchby</module> <frontName>searchby</frontName> </args> </searchby> </routers> </frontend> <global> <models> <catalogsearch> <rewrite> <layer>Mage_Searchby_Model_Layer</layer> </rewrite> </catalogsearch> </models> </global> </config>

Now create an Layer.php file inside yourmodulename/Model then write the below code

<?php class Mage_Searchby_Model_Layer extends Mage_CatalogSearch_Model_Layer { public function prepareProductCollection($collection) { //Code to be executed } }?>

That's all thanks

How to add search by category in magento mini search

2011-11-25T16:42:00.002+05:30

There is no free extension in magento commerce which will help you to search your store with particular category. I tried from myself and able to do, I am sharing my exprerience here with.

First create the drop down list of all category in form.mini.phtml

<select name="category" id="category_search_field"> <option value="">-- Any Category --</option> <?php foreach ($catalog->getStoreCategories() as $_category): ?> <?php if($_category->hasChildren()): ?> <option class="parent-cat" value="<?php echo $_category->getId(); ?>"><?php echo $_category->getName();?></option> <?php foreach ($_category->getChildren() as $subcategory): if($subcategory->getIsActive()) : ?> <option value="<?php echo $subcategory->getId(); ?>"<?php echo ($this->getRequest()->getQuery('category') == $subcategory->getId() ? ' selected="selected"': "") ?>><?php echo $subcategory->getName(); ?></option> <?php endif; endforeach; ?> <?php elseif($_category->getIsActive()): ?> <option value="<?php echo $_category->getId(); ?>"><?php echo $_category->getName();?></option> <?php endif; ?> <?php endforeach ?> </select>

Now go to app/code/core/Mage/CatalogSearch/Helper and open the Data.php and add the below code

public function getStoreCategories() { $helper = Mage::helper('catalog/category'); return $helper->getStoreCategories(); } public function getSelectedCategory() { $catid = (int)addslashes($_REQUEST['category']); $cat=""; if($catid>1) $cat = Mage::getModel('catalog/category')->load($catid); return $cat; }

Now go to app/code/core/Mage/CatalogSearch/Model and open the Layer.php

replace

public function prepareProductCollection($collection) { $collection ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes()) ->addSearchFilter(Mage::helper('catalogsearch')->getQuery()->getQueryText()) ->setStore(Mage::app()->getStore()) ->addMinimalPrice() ->addFinalPrice() ->addTaxPercents() ->addStoreFilter() ->addUrlRewrite(); Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection); Mage::getSingleton('catalog/product_visibility')->addVisibleInSearchFilterToCollection($collection); return $this; }

with

public function prepareProductCollection($collection) { if(Mage::helper('catalogsearch')->getSelectedCategory()!="") { $collection ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes()) ->addSearchFilter(Mage::helper('catalogsearch')->getQuery()->getQueryText()) ->setStore(Mage::app()->getStore()) ->addMinimalPrice() ->addFinalPrice() ->addTaxPercents() ->addStoreFilter() ->addCategoryFilter(Mage::helper('catalogsearch')->getSelectedCategory()) ->addUrlRewrite(); } else { $collection ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes()) ->addSearchFilter(Mage::helper('catalogsearch')->getQuery()->getQueryText()) ->setStore(Mage::app()->getStore()) ->addMinimalPrice() ->addFinalPrice() ->addTaxPercents() ->addStoreFilter() ->addUrlRewrite(); } Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection); Mage::getSingleton('catalog/product_visibility')->addVisibleInSearchFilterToCollection($collection);

return $this;
}

save and Enjoy.

cache is not generating in magento

2011-11-17T11:46:00.000+05:30

Magento stores cache inside the cache folder which resides under Var folder of your root magento ,But if your cache folder or var folder have not correct file permisson that is 777 then magento will not be able to generate any cache. So change Var folder permission to 777 , you will see the effect.

How To Display Best Selling Products On Magento Store

2011-10-31T19:45:00.001+05:30

To promote best selling products on your site Magento use so many way to show bestseller product, One of them I am going to show. Below code will fetch the all the list of all product which have already sell.

<?php

$_productCollection = Mage::getResourceModel('reports/product_collection')

->addOrderedQty()

->setOrder('ordered_qty', 'desc');

?>

This is the collection of all the product which already have sell.

Now use foreach loop to show some number of product and it details. I wish to show only the name of the product which has sell most. And I will show on the left sidebar of the page.

<div class="block best-seller">

<div class="right-title-bg"><h3>Best Selling Product</h3></div>

<div class="block-content">

<ul class="best-selling-item">

$count = 0;

foreach($_productCollection as $product):

$id = $product->getId();

$prod = Mage::getModel('catalog/product')->load($id);?>

<li><a href="<?php echo $prod->getProductUrl();?>" title="<?php echo $prod->getName();?>"><?php echo $prod->getName();?></a></li>

<?php

$count++ ;

if($count==$totalPerPage)

break;

endforeach;

?>

</ul>

</div>

</div>

If you wish to show all the details of the product then you also can do that as you will get the product Id from $prod->getId(); and from product Id you can fetch each and every details of the product

How to print product collection query in magento

2011-10-29T18:47:00.001+05:30

Let you have write a product collection with some attribute to select some product, but you are not getting proper result then you must need to print the sql query to see whether you have write the correct syntax in magento default collection. then write the below code to get the sql query .

<?php    

$productcollection = Mage::getModel('catalog/product')->getCollection()

->addAttributeToFilter('bestseller', array('eq' => 1))

->addAttributeToSelect('*');

echo $productcollection->getSelect()->assemble();

?>

How to delete all sales order in magento

2011-09-27T15:20:00.004+05:30

In Magento Connect you will find some extension which will delete all cancel order and Pending Order, But it never delete all processed order. To delete all orders following code snippet can be used.

<?php

require 'app/Mage.php';

Mage::app('admin')->setUseSessionInUrl(false);                                                                              

$sales_orders = Mage::getModel('sales/order')->getCollection()->getData();

foreach($sales_orders as $sales_order){

    $id = 0;

    $id = $sales_order['increment_id'];

    try{

        Mage::getModel('sales/order')->loadByIncrementId($id)->delete();

        echo "order #".$id." is removed".PHP_EOL;

    }catch(Exception $e){

        echo "order #".$id." could not be remvoved: ".$e->getMessage().PHP_EOL;

    }

}

echo "complete."

?>

How to use or mysql condition in $collection data of magento

2011-09-26T11:42:00.001+05:30

Magento provide addAttributeToFilter to use and operator in $collection, But using of OR operator is little bit different . I was guess that there must be and OrAttributeToFilter , But I was wrong I think magento forgot to write this function, Lastly I found the solution to use mysql OR in magento . In addAttributeToFilter we have to write the condition in the form of array.

protected function _prepareCollection()

{

   $collection = Mage::getModel('catalog/product')->getCollection();

   $collection->addAttributeToFilter(

      array(

          array('attribute'=>'category_ids','finset'=>2),

          array('attribute'=>'category_ids','finset'=>3)

      )

   );

}

use your own attribute name and value to get the data

How to upload and read csv file in magento

2011-09-16T19:55:00.001+05:30

To upload CSV file and to read that file line by line , Please write the below code in magento



if(isset($_FILES['import_file']['name']) && $_FILES['import_file']['name'] != '')

{

    $uploaderFile = new Varien_File_Uploader('import_file');

    $uploaderFile->setAllowedExtensions(array());

    $uploaderFile->setAllowRenameFiles(false);

    $uploaderFile->setFilesDispersion(false);

    $uploaderFilepath = Mage::getBaseDir('media') . DS . 'importcsv' . DS ;

    $uploaderFile->save($uploaderFilepath, $_FILES['import_file']['name'] );

    $file =  $_FILES['import_file']['name'];

    $filepath = $uploaderFilepath.$file;

    $i = 0;

    if(($handle = fopen("$filepath", "r")) !== FALSE) {

        while(($data = fgetcsv($handle, 1000, ",")) !== FALSE){             

            if($i>0 && count($data)>1){

                updateData($data);

            }           

            $i++;

        }

    }

    else{

        Mage::getSingleton('adminhtml/session')->addError("There is some Error");

        $this->_redirect('*/*/index');

    }

}

    function updateData($data)

    {

        //Write your code here and Update it to magento tables

    }

How to get contact us email address in magento

2011-08-30T12:53:00.006+05:30

Here’s the code to get Contacts email:


<?php echo Mage::getStoreConfig('contacts/email/recipient_email');?>

Or you can change it from admin -> System-> Configuration. From the left tab select Contacts then On the right side you will see Email Options Tab. From that tab you can see there is a field for send Emails To.Change th evalue to your require email address

How to uncheck Radio button by jquery

2011-08-04T19:58:00.009+05:30

Write the Below code to Unchecked Radio Button by Jquery

<script type="text/javascript">
    $(document).ready(function(){
        $("#btn").click(function(){ 
           $('input[name="rd"][type="radio"]:checked').each(function(){ 
               $(this).attr("checked", false); 
            }); 
        });
    });
</script>


<form action="" name="aa" method="post">
    <input type="radio" name="rd" value="1"/>
    <input type="radio" name="rd" value="2"/>
    <input type="radio" name="rd" value="3"/>
    <input type="button" id="btn" value="Click" />
</form>

How to change value and fetch value of Minimum Order Amounts of free shipping in magento

2011-08-04T19:38:00.004+05:30

First of all to make Minimum Order Amounts of Free Shipping to [STORE VIEW] instead of [WEBSITE] then Go to app->code->core->Mage->Shipping->etc->System.xml
then change the value of <show_in_store> to 1 under carriers -> groups -> freeshipping ->free_shipping_subtotal.

Now to fetch the value of the Minimum Order Amount according to store view write the below code


    <?php echo Mage::getStoreConfig('carriers/freeshipping/free_shipping_subtotal'); ?>

How to remove validation on zip code in magento checkout page

2011-07-30T07:33:00.005+05:30

In the World some of the country has no zip code like Ireland, But magento has default zip code validation to make that optional for specific country magento has added a new feature in admin panel. To make Zip code optional please follow the following steps.

Login to your your magento admin panel then go to System -> Configuration->General. From Country option tab you can see there is an option " Postal code is optional for the following countries " Select the country which you want to Optional/Not validate . then click on save config to save your settings. To be more clear on this please see the below screenshot.

How to change default quantity on Magento Product Page

2011-07-17T11:46:00.006+05:30

By default magento shows zero in the place of quantity text field in product details page, if you wish to change then just login to your admin panel go to System->Configuration->Catalog->inventory.

There, add your minimal quantity from Minimum Qty Allowed in Shopping Cart

See the below screenshot to make it more clear

How to change css padding property using javascript dynamically

2011-06-16T15:40:00.004+05:30

Using Javascript we can change css value. Here I have written how to change the value of padding top, padding bottom, padding left, padding right differently. var ab = 20; //To change Padding-top value write document.getElementById("div_Id").style.paddingTop = ab.toString()+"px" //To change Padding-left value write document.getElementById("div_Id").style.paddingLeft = ab.toString()+"px" //To change Padding-right value write document.getElementById("div_Id").style.paddingRight = ab.toString()+"px" //To change Padding-bottom value write document.getElementById("div_Id").style.paddingBottom = ab.toString()+"px"

How to send Email in magento

2011-05-17T19:20:00.004+05:30

Any body can send mail using php mail() function.But in magento all the functionality has wriiten you need to just send argument inside those functions. See the following code to send mail using magento function

<?php 

  $mail = Mage::getModel('core/email');

  $mail->setToName('Your Name');

  $mail->setToEmail('Youe Email');

  $mail->setBody('Mail Text / Mail Content');

  $mail->setSubject('Mail Subject');

  $mail->setFromEmail('Sender Mail Id');

  $mail->setFromName("Msg to Show on Subject");

  $mail->setType('html');// YOu can use Html or text as Mail format


  try {

  $mail->send();

  Mage::getSingleton('core/session')->addSuccess('Your request has been sent');

  $this->_redirect('');

  }

  catch (Exception $e) {

  Mage::getSingleton('core/session')->addError('Unable to send.');

  $this->_redirect('');

  }

  ?>

How to get all list of country in magento

2011-05-17T16:31:00.001+05:30

Write the following code to any phtml file or template file you will get list of all the Country


<select name="country" id="country">

<?php $country_list = Mage::getResourceModel('directory/country_collection')

->loadData()

->toOptionArray(false) ?>

<?php if (count($country_list) > 0){ ?>

<option value="">Please Select</option>

<?php foreach($country_list as $country){ ?>

<option value="<?php echo $country['value'] ?>">

<?php echo $country['label'] ?>

</option>

<?php } ?>

<?php }?>

</select>

How to get category or subcategory postioned by the admin panel in magento

2011-05-17T12:04:00.002+05:30

When we load a category it shows his subcategory according to the product id. If you wish to show category according to the order which you have in you admin panel then you have to fetch your category with little bit different style.See the below code in which I have fetched all subcategory with proper order



<?php 

$obj= new Mage_Catalog_Block_Navigation();

$category = $obj->getStoreCategories();

foreach($category as $_category)

{

$catid = $_category->getId();

$parentCategory = Mage::getModel('catalog/category')->load($catid);

$childrenIdArray = explode(',',$parentCategory->getChildren());

if ($key = array_search($parentCategory->getId(),$childrenIdArray)) {

unset($childrenIdArray[$key]);

} 

$collection = Mage::getModel('catalog/category')->getCollection()

->addAttributeToFilter('entity_id', array('in' => $childrenIdArray))

->addAttributeToSelect('*'); 



$sortedcategory = $collection->addOrderField('position')->getData(); 

foreach($sortedcategory as $sorted)

{

$_subcat = Mage::getModel('catalog/category')->load($sorted['entity_id']);

$subcatname = $_subcat->getName();

echo "<h3>".$subcatname."</h3>";

}

}

?>

How to get all gallery image with resize of a product in magento

2011-05-04T17:21:00.003+05:30

In product page you can get gallery image of the current product, But if you think to fetch all gallery image of a product in other page like cms page, then you have to write the code with little bit modification. The code should looks like below


<?php 

$obj = new Mage_Catalog_Block_Product_View_Media();

$_product = new Mage_Catalog_Model_Product();

// Load all product information of a particular product

$Products_one = Mage::getModel('catalog/product')->load($id);

// Use your Product Id instead of $id


$countt = count($Products_one->getMediaGalleryImages());

if($countt>0){

foreach ($Products_one->getMediaGalleryImages() as $_image)

{

// For the Original Image 


 echo "<img src=".Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA).str_replace(Mage::getBaseUrl('media'),"",$_image->url)." alt='' />";

 //For gallery Image

 $resizeimage = $obj->helper('catalog/image')->init($_product, 'thumbnail', $_image->getFile())->backgroundColor(242,242,243)->resize(400,300);

 echo "<img src=".$resizeimage."alt='' />";
 

}


}

CSS Hack for Google Chrome and Safari

2011-05-03T10:55:00.004+05:30

If you are developing any site or designing any website, having design problem in chrome and safari you can write the below css, It only works on Google chrome and Safari Browser


@media screen and (-webkit-min-device-pixel-ratio:0)
 {

.classname{ background:#ccc; } /*It will works on Google chrome and safari */

}

How to upload file in magento

2011-04-28T17:31:00.002+05:30

If you are making your custom module in magento and if you unable to use default magento file upload then you can use magento custom file uploading code to upload file.


// If you want to upload files under media folder 

$absolute_path = Mage::getBaseDir('media') . DS ; 

$relative_path = Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA); 

// File Upload  

$files = $_FILES['file_upload']['name']; 

if(isset($files) && $files != '') 

{ 

    try 

    { 

        if(file_exists($absolute_path.DS.$files)) 

        { 

            $var = rand(0,99); 

            $files = $var.'_'.$files; 

        } 

        // Starting upload    
    
        $uploader = new Varien_File_Uploader('file_upload');  

        // Any extention would work 

        $uploader->setAllowedExtensions(array('jpg','jpeg','gif','png')); 

        $uploader->setAllowRenameFiles(false);   

        //false -> get the file directly in the specified folder 

        //true -> get the file in the product like folders  /media/catalog/product/file.gif 

        $uploader->setFilesDispersion(false); 

        //We set media as the upload dir 

        $uploader->save($absolute_path, $files);   

    }  
         
    catch(Exception $e) 

    { 

        Mage::getSingleton('adminhtml/session')->addError($e->getMessage()); 

    } 

    // Your uploaded file Url will be 

    echo $file_url = $relative_path.$files; 

}

How to fetch all associative product of a configurable product in magento

2011-04-28T15:50:00.003+05:30

Configurable product is the product which is created by some Associated product, If you have an configurable product and you want to get list of all associated product and it's attribute then just write the below

You must have your configurable product Id, My configurable product Id is 11


$id=11; //Use your Configurable product Id

$_product = new Mage_Catalog_Model_Product();

$childIds = Mage::getModel('catalog/product_type_configurable')->getChildrenIds($id);

foreach($childIds[0] as $key=>$val)

{

   $associatedProduct = Mage::getModel('catalog/product') ->load($val);

   echo $associatedProduct ->getName();

//Let you have a color attribute in each associated product then you can fetch by

   $colorids[] = $associatedProduct ->getColor();

   $colorname[] = $associatedProduct ->getAttributeText('color');

}

How to and where to change default product image in Magento

2011-04-28T12:19:00.005+05:30

If you forgot to upload any product image then Magento always show a default image,If you think to change default image then login to admin panel then goto System -> Configuration then click on Catalog tab. From Product Image Placeholders change your Base Image , Small Image and Thumbnail . Now click on Save Config button to make changes.

How to Add option to select box by jquery

2011-04-20T11:09:00.007+05:30

I have write the below code to add option to select drop down by jquery. Add value to the below input box then click on add button.You can see the effect.That option will be added to the below selectbox

The code you need to write is


$('#selectbox').append($("<option></option>").attr("value",option_value).text(text_to_display));

How to add new order status in magento admin panel

2011-04-01T17:36:00.004+05:30

To add New Status in magento admin panel, you need to write your own custom module , then in your config.xml file write the below code to add new Status


<config>
    <global>
        <sales>
            <order>
                <statuses>
                    <custom_status translate="label"><label><![CDATA[Custom Status]]></label></custom_status>
                </statuses>
                <states>
                    <new><!-- order state where you want to assign your custom status e.g:- New, Onhold, Canceld etc-->
                        <statuses>
                            <custom_status/>
                        </statuses>
                    </new>
                </states>
            </order>
        </sales>
    </global>
</config>

It will work upto 1.4.2 , But in Magento 1.5.0 or above there is Special Option to do this. To make own Custom status above magento 1.5 version go to System->Order Statuses. Then Click on Create New Status. After creating new status click on Assign Status to State to assign that status

How To Create a custom url redirect in Magento using URL Rewrite Management

2011-03-28T16:35:00.005+05:30

To make magento more SEO friendly, It needs to redirect to a custom url, By default magento have this feature but if you have created any module whose url like modulename/id/3, then you needs to redirect it to a SEO friendly url. To redirect the url to a "301 Permanent redirect" you just login to your admin panel, then go to -> Catalog -> URL Rewrite Management, from the drop down select Custom ,follow the below screenshot to make it more easy.

1) In the Id path give your current url (e.g: review/product/list/id/14/category/3)
2) In Request Path write same as Id path (e.g: review/product/list/id/14/category/3)
3) In Target Path give oyu custom Url with domain name (e.g:- http://www.mysite.com/mobile.html)