Magento / php Development

Magento - Get Admin User details by Id or by Name

2014-08-29T15:30:00.001+05:30

Day before I was looking for code which can gives me the ID of admin user by name and found some intresting code for that so putting this in front of all hope this will helps someone like me :)

<?php
//By Username get admin User's Details
$username = 'admin';
$user_data = Mage::getModel('admin/user')->getCollection()->addFieldToFilter('username',$username)->getData();
var_dump($user_data);

//By Username get admin User's Role Details
$username = 'admin';
$role_data = Mage::getModel('admin/user')->getCollection()->addFieldToFilter('username',$username)->getFirstItem()->getRole()->getData();
var_dump($role_data);

//By ID get admin User's Details
$id = 1;
$user_data = Mage::getModel('admin/user')->load($id)->getData();
var_dump($user_data);


//By ID get admin User's Role Details
$id = 1;
$role_data = Mage::getModel('admin/user')->load($id)->getRole()->getData();
var_dump($role_data);

Comments are welcome :)

Magento - Adding Custom Option for all products dynamically

2014-08-14T20:03:00.001+05:30

Adding Custom Option for all products dynamically

<?php
require_once 'app/Mage.php';
umask(0);

Mage::app('admin');

// If your database is having lots of data then use set_time_limit / ini_set
//set_time_limit(0);
//ini_set('memory_limit','1024M');

$option = array(
    'title' => 'custom option title',
    'type' => 'radio', // could be drop_down ,checkbox , multiple
    'is_require' => 1,
    'sort_order' => 0,
    'values' => getOptions()
    );


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


foreach ($collection as $product_all) {
        

        $sku = $product_all['sku'];
        // retrieve product id using sku
        $product_id = Mage::getModel('catalog/product')->getIdBySku($sku);
        
        //In Case of creating a new product.
        /*$product = Mage::getModel('catalog/product');
        $product->setProductOptions(array($option));
        $product->setCanSaveCustomOptions(true);*/

        //Or if we are adding the options to a already created product.
        $product = Mage::getModel('catalog/product')->load($product_id);
        $product->setProductOptions(array($option));
        $product->setCanSaveCustomOptions(true);

        //Do not forget to save the product
        $product->save();
        echo "Done
";
}



function getOptions(){
   return array(
   array(
    'title' => 'Option Value 1',
    'price' =>100,
    'price_type' => 'fixed',
    'sku' => 'sku for 1',
    'sort_order' => '1'
    ),
array(
    'title' => 'Option Value 2',
    'price' =>100,
    'price_type' => 'fixed',
    'sku' => 'sku for 2',
    'sort_order' => '1'
    ),
  array(
    'title' => 'Option Value 3',
    'price' =>100,
    'price_type' => 'fixed',
    'sku' => 'sku for 3',
    'sort_order' => '1'
    )
);
}

Comments are welcome :)

Magento - Create multiple Sub-Category in few minutes

2014-07-03T13:08:00.000+05:30

After log days I am posting something interesting here, we all knows creating category and assigning product to them in Magento is very time consuming

So I came with an solution for this.

First create the list of sub categories in CSV file, in first column with column heading "Category Name" and file name as "category.csv" then run below script

Need to change into below script:

1. $rootCateId - here you need to set the ID of root category under which you want to add sub categories
2. $path = here I set this as "1/2/" mostly in magento by default this is same but cross check it once.

One more thing after this in some cases magento will ask you for re-indexing process.

That's it.

Comments are welcome... :)

<?php

set_time_limit(0);
ini_set('memory_limit', '1024M');
umask(0);
require_once 'app/Mage.php';
Mage::app('admin');
if (($handle = fopen("category.csv", "r")) !== FALSE) {
  $counter = 1;
  while (($data = fgetcsv($handle)) !== FALSE) {
        if ($counter > 1) {
          $cateName = $data[0];
           echo $cateName."\n"; 
           $rootCateId = 559; // here we need to assign root cate Id under which you want to create your new category
          if($cateName){
           createCategory($cateName, $rootCateId);
          }
        }
        $counter++;
        if($counter > 2){  // if want to break the scrip
            //exit();
        }
    }
}
function createCategory($name, $rootCateId){

 $path = "1/2/".$rootCateId; // here 1/2 is my store root category path you can check this in database table 'catalog_category_entity' table
 $cateName = $name;
 $category = Mage::getModel('catalog/category');
 $category->setStoreId(0); // 0 = default/all store view. If you want to save data for a specific store view, replace 0 by Mage::app()->getStore()->getId().

 if ($id) { //if update
   //$category->load($id);
 }
  
 $general['name'] = $cateName;
 $general['path'] = $path; // catalog path
 //$general['description'] = " Category";
 //$general['meta_title'] = "My Category"; //Page title
 //$general['meta_keywords'] = "";
 //$general['meta_description'] = "";
 //$general['landing_page'] = ""; //has to be created in advance, here comes id
 $general['display_mode'] = "PRODUCTS"; //static block and the products are shown on the page
 $general['is_active'] = 1;
 $general['is_anchor'] = 0;
 //$general['page_layout'] = 'two_columns_left';
 //$general['url_key'] = "cars";//url to be used for this category's page by magento.
 //$general['image'] = "cars.jpg";

 $category->addData($general);
 try {
     $category->save();
     echo "Success! new category Id: ".$category->getId()."\n";
 }
 catch (Exception $e){
     echo $e->getMessage();
 }
}

Magento - Use of Custom Variables

2014-03-25T11:04:00.002+05:30

Magento provides such a nice feature about custom variables its implemented from CE ver 1.4 onward.

How to use it in admin?

Login to Admin
System->Custom variables->Add New Variable for e.g. “your_variable” check below screen

Admin view of Custom Variable

put HTML content and Plain text for your variable

How to use this in Code

To use this in CMS pages just put like below

{{customVar code=your_variable}}

To use this in phtml pages

$variableHtml = Mage::getModel(’core/variable’)->loadByCode(’your_variable’)->getValue(’html’);
$variableHtml = Mage::getModel(’core/variable’)->loadByCode(’your_variable’)->getValue(’plain’);

something more interested about custom variable

print_r ( Mage::getModel('core/variable')->loadByCode('your_variable')->getData() ) ;

array o/p will be:

[variable_id] => 1 [code!] => your_variable [name] => Your Variable [plain_value] => your custom variables plain val [html_value] => your custom variables html val [store_plain_value] => your custom variables plain val [store_html_value] => your custom variables html val

Database table for this are core_variable and core_variable_value

that's it
comments are welcome ;)

Magento - Programmatically Re-Indexing

2014-03-13T16:59:00.000+05:30

In Magento re-indexing is very much important as we knows this but sometime you have to quickly re-index all the section or specific section in magento so while dealing with this either you have to login to admin panel for re-indexing or another way is using shell script (check this for shell script). so hows that if we write the root script for the same so it will increase our speed of development and will help in some other factors also mostly we can use cron job to run root script for re-indexing process.

So how to do this, just copy the below code in one .php file I will say reindex.php and store it at your magento root file.

Simply call your reindex.php file in browser by http://your_domain_name/reindex.php

<h2>Programmatically Re-Indexing in Magento</h2>

<a href="reindex.php?reindex_type=all">Reindex All</a></br>
<a href="reindex.php?reindex_type=product_attributes">Reindex Product Attributes</a></br>
<a href="reindex.php?reindex_type=product_prices">Reindex Product Prices</a></br>
<a href="reindex.php?reindex_type=catalog_url_rewrites">Reindex Catalog URL Rewrites</a></br>
<a href="reindex.php?reindex_type=product_flat_data">Reindex Product Flat Data</a></br>
<a href="reindex.php?reindex_type=category_flat_data">Reindex Category Flat Data</a></br>
<a href="reindex.php?reindex_type=category_products">Reindex Category Products</a></br>
<a href="reindex.php?reindex_type=catalog_search_index">Reindex Catalog Search Index</a></br>
<a href="reindex.php?reindex_type=stock_status">Reindex Stock Status</a></br>
<a href="reindex.php?reindex_type=tag_aggregation_data">Reindex Tag Aggregation Data</a></br></br>
<a href="reindex.php">Refresh</a></br></br>
<?php
require_once 'app/Mage.php';
$app = Mage::app('admin');
umask(0);

$reindex_which = $_GET["reindex_type"];

$index_ids = array(1,2,3,4,5,6,7,8,9);

switch ($reindex_which) {
    case "all":
        foreach($index_ids as $id)
  {
   try
   {
    $process = Mage::getModel('index/process')->load($id);
    //MODE_REAL_TIME or MODE_MANUAL
    //$process->setMode(Mage_Index_Model_Process::MODE_MANUAL)->save(); 
    $process->reindexAll();
    echo "Indexing Process is done for all<br />";
   }
   catch(Exception $e)
   {
   echo $e->getMessage();
   }
  }
        break;
    case "product_attributes":
         try
   {
    $process = Mage::getModel('index/process')->load(1);
    //MODE_REAL_TIME or MODE_MANUAL
    //$process->setMode(Mage_Index_Model_Process::MODE_MANUAL)->save(); 
    $process->reindexAll();
    echo "Indexing Process is done for Product Attributes<br />";
   }
   catch(Exception $e)
   {
   echo $e->getMessage();
   }
        break;
    case "product_prices":
         try
   {
    $process = Mage::getModel('index/process')->load(2);
    //MODE_REAL_TIME or MODE_MANUAL
    //$process->setMode(Mage_Index_Model_Process::MODE_MANUAL)->save(); 
    $process->reindexAll();
    echo "Indexing Process is done for Product Prices<br />";
   }
   catch(Exception $e)
   {
   echo $e->getMessage();
   }
        break;
    case "catalog_url_rewrites":
         try
   {
    $process = Mage::getModel('index/process')->load(3);
    //MODE_REAL_TIME or MODE_MANUAL
    //$process->setMode(Mage_Index_Model_Process::MODE_MANUAL)->save(); 
    $process->reindexAll();
    echo "Indexing Process is done for Catalog URL Rewrites<br />";
   }
   catch(Exception $e)
   {
   echo $e->getMessage();
   }
        break;  
    case "product_flat_data":
         try
   {
    $process = Mage::getModel('index/process')->load(4);
    //MODE_REAL_TIME or MODE_MANUAL
    //$process->setMode(Mage_Index_Model_Process::MODE_MANUAL)->save(); 
    $process->reindexAll();
    echo "Indexing Process is done for Product Flat Data<br />";
   }
   catch(Exception $e)
   {
   echo $e->getMessage();
   }
        break;      
    case "category_flat_data":
         try
   {
    $process = Mage::getModel('index/process')->load(5);
    //MODE_REAL_TIME or MODE_MANUAL
    //$process->setMode(Mage_Index_Model_Process::MODE_MANUAL)->save(); 
    $process->reindexAll();
    echo "Indexing Process is done for Category Flat Data<br />";
   }
   catch(Exception $e)
   {
   echo $e->getMessage();
   }
        break;    
    case "category_products":
         try
   {
    $process = Mage::getModel('index/process')->load(6);
    //MODE_REAL_TIME or MODE_MANUAL
    //$process->setMode(Mage_Index_Model_Process::MODE_MANUAL)->save(); 
    $process->reindexAll();
    echo "Indexing Process is done for Category Products<br />";
   }
   catch(Exception $e)
   {
   echo $e->getMessage();
   }
        break;
    case "catalog_search_index":
         try
   {
    $process = Mage::getModel('index/process')->load(7);
    //MODE_REAL_TIME or MODE_MANUAL
    //$process->setMode(Mage_Index_Model_Process::MODE_MANUAL)->save(); 
    $process->reindexAll();
    echo "Indexing Process is done for Catalog Search Index<br />";
   }
   catch(Exception $e)
   {
   echo $e->getMessage();
   }
        break;        
    case "stock_status":
         try
   {
    $process = Mage::getModel('index/process')->load(8);
    //MODE_REAL_TIME or MODE_MANUAL
    //$process->setMode(Mage_Index_Model_Process::MODE_MANUAL)->save(); 
    $process->reindexAll();
    echo "Indexing Process is done for Stock Status<br />";
   }
   catch(Exception $e)
   {
   echo $e->getMessage();
   }
        break;    
    case "tag_aggregation_data":
         try
   {
    $process = Mage::getModel('index/process')->load(9);
    //MODE_REAL_TIME or MODE_MANUAL
    //$process->setMode(Mage_Index_Model_Process::MODE_MANUAL)->save(); 
    $process->reindexAll();
    echo "Indexing Process is done for Tag Aggregation Data<br />";
   }
   catch(Exception $e)
   {
   echo $e->getMessage();
   }
        break; 
}
?>

Page view

that's it

comments are welcome ;)

Magento - Share compare product page on facebook to get review from your friends

2014-03-03T15:42:00.000+05:30

Hi Magentoers,

Here I want to address one thing to you all it's regarding to the compare product in magento.

we all knows magento provides us an compare product functionality as a customer point of view while comparing some products we always have some questions, doubts about that products now it could be better to ask the review to your friends on facebook by sharing your compare product page.

As per developer point of view how to do that? Very Simple

Step 1: You have to override one function which is present in app/code/core/Mage/Catalog/controllers/Product/CompateController.php i.e. function indexAction()
and add the below line of code after $items = $this->getRequest()->getParam('items');

<?php

 if($items){
            Mage::getSingleton('catalog/session')
                ->setCompareUrlParams($items);
      }

Now Your function will look like below

<?php

public function indexAction()
    {
        $items = $this->getRequest()->getParam('items');

        // Added code for Facebook share
        if($items){
            Mage::getSingleton('catalog/session')
                ->setCompareUrlParams($items);
        }

        if ($beforeUrl = $this->getRequest()->getParam(self::PARAM_NAME_URL_ENCODED)) {
            Mage::getSingleton('catalog/session')
                ->setBeforeCompareUrl(Mage::helper('core')->urlDecode($beforeUrl));
        }

        if ($items) {
            $items = explode(',', $items);
            $list = Mage::getSingleton('catalog/product_compare_list');
            $list->addProducts($items);
            $this->_redirect('*/*/*');
            return;
        }

        $this->loadLayout();
        $this->renderLayout();
    }

Step 2: Now go to app/design/frontend/default/your_template/template/catalog/product/compare/list.phtml and add below code where you want to show the facebook share button

1	<div class="fb-share-button" data-href="<?php echo Mage::getBaseUrl().'catalog/product_compare/index/'.Mage::getSingleton('catalog/session')->getCompareUrlParams();?>" data-type="button_count"></div>

Step 3: Now last step is to add javascript method which require to work share button add below step at the bottom of the list.phtml page.

<div id="fb-root"></div>
<script>(function(d, s, id) {
  var js, fjs = d.getElementsByTagName(s)[0];
  if (d.getElementById(id)) return;
  js = d.createElement(s); js.id = id;
  js.src = "//connect.facebook.net/en_US/all.js#xfbml=1";
  fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>

Compare Product default view

that's it
comments are welcome ;)

Magento sub links 404 error

2014-02-27T17:15:00.002+05:30

In some cases while after moved magento site from one server to another or else in some condition your home page works fine but you have to face 404 error for sub pages or sub links

What to do in this case?

Simple just run below queries in your magento database
(PN: Take a backup of your database if possible)

Queries will be like below:

1	UPDATE `core_config_data` SET `value` = '0' WHERE `core_config_data`.`path` = 'catalog/seo/save_rewrites_history';

and

1	UPDATE `core_config_data` SET `value` = '0' WHERE `core_config_data`.`path` = 'web/seo/use_rewrites';

Comments are Welcome ;)

Magento - Upload file code

2014-01-24T13:04:00.001+05:30

php Logic:

<?php
$post = $this->getRequest()->getPost();
//var_dump($post); die;
if(isset($_FILES['file']['name']) && (file_exists($_FILES['file']['tmp_name']))) {
  try {
 
 $uploader = new Varien_File_Uploader('file');
 $uploader->setAllowedExtensions(array('pdf','doc','png','jpg')); // or pdf or anything

 $uploader->setAllowRenameFiles(false);
 // setAllowRenameFiles(true) -> move your file in a folder the magento way
 // setAllowRenameFiles(true) -> move your file directly in the $path folder
 $uploader->setFilesDispersion(false);
   
 $path = Mage::getBaseDir('media');
 
 $uploader->save($path, $_FILES['file']['name']);
  
 $data['file'] = $_FILES['file']['name'];
  
 $message = $this->__('Your file has been uploaded successfully.');
 Mage::getSingleton('adminhtml/session')->addSuccess($message);
  
  }catch(Exception $e) {
  Mage::getSingleton('adminhtml/session')->addError($e->getMessage());
  }
}else{
  Mage::getSingleton('adminhtml/session')->addError('Invalid form data.'); 
}

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

Form Code:

<div class="content-header">
    <table cellspacing="0" class="grid-header">
        <tr>
            <td><h3><?=$this->__('File Upload')?></h3></td>
            <td class="a-right">
                <button onclick="fileForm.submit()" class="scalable save" type="button"><span>Upload File</span></button>
            </td>
        </tr>
    </table>
</div>
<div class="entry-edit">
    <form id="file_form" name="file_form" method="post" action="<?=$this->getUrl('*/*/post')?>" enctype="multipart/form-data">
        <input name="form_key" type="hidden" value="<?php echo Mage::getSingleton('core/session')->getFormKey() ?>" />
        <h4 class="icon-head head-edit-form fieldset-legend"><?=$this->__('file upload section')?></h4>
        <fieldset id="my-fieldset">
            <table cellspacing="0" class="form-list">
                <tr>
     <td class="label"><?=$this->__('Upload File')?> <span class="required">*</span></td>
     <td class="input-ele"><input class="required-entry" type="file" name="file" id="file"/></td>
                </tr>
            </table>
        </fieldset>
    </form>
</div>
<script type="text/javascript">
    var fileForm = new varienForm('file_form');
</script>

that's it
comments are welcome ;)

Magento - Get Customer's group data into array

2014-01-15T18:27:00.003+05:30

As sometime in magento we required to work on customer group for some customization kind of things so how to get all the customer group data into an array

The below screenshots data that I want into array

Admin Customer Group view

Now normally you’d load this into the model like so:

<?php
$group = Mage::getModel('customer/group')->getCollection();
$groupArray = array();
foreach ($group as $eachGroup) {
  $groupData = array(
   'customer_group_id' => $eachGroup->getCustomerGroupId(),
   'customer_group_code' => $eachGroup->getCustomerGroupCode(),
   'tax_class_id' => $eachGroup->getTaxClassId() // we dont required this
  );
  if (!empty($groupData)) {
   array_push($groupArray, $groupData);
  }
 }
var_dump($groupArray);

o/p will be like below

array (size=4)
  0 => 
    array (size=3)
      'customer_group_id' => string '0' (length=1)
      'customer_group_code' => string 'NOT LOGGED IN' (length=13)
      'tax_class_id' => string '3' (length=1)
  1 => 
    array (size=3)
      'customer_group_id' => string '1' (length=1)
      'customer_group_code' => string 'General' (length=7)
      'tax_class_id' => string '3' (length=1)
  2 => 
    array (size=3)
      'customer_group_id' => string '2' (length=1)
      'customer_group_code' => string 'Wholesale' (length=9)
      'tax_class_id' => string '3' (length=1)
  3 => 
    array (size=3)
      'customer_group_id' => string '3' (length=1)
      'customer_group_code' => string 'Retailer' (length=8)
      'tax_class_id' => string '3' (length=1)

that's it
comments are welcome ;)

Magento - Admin login problem

2013-11-19T23:36:00.003+05:30

You input the right password to your Admin login page, but getting the access denied, password is not working either on your local machine. so what to do now?

Very Simple one just use the below SQL query.

once you used this into your phpmyadmin then you can use password as "admin" once you are able to login then change your password as you want.

1	UPDATE `admin_user` SET `password` = 'b5eb650d32fc4980284427104829b556:f6' WHERE `username` = 'your_admin_username';

Login with
Username : your_admin_username like admin / superuser etc.
Password: admin ( b5eb650d32fc4980284427104829b556:f6 this is MD5 conversion for admin word)

Invalid Login issue

that's it
comments are welcome ;)

Magento - Get Customer & Product Info from an Order

2013-11-19T19:30:00.001+05:30

Here are a few little snippits of code that you may find useful when trying to get information out of an order number. First of all get your order number (I’m using $this->getOrderId() on the checkout success page but you can get your order number in any fashion really). Once you have your order number it’ll look something like this: 1000000001.

Now normally you’d load this into the model like so:

<?php
$orderid = "1000000001";
$orderid = round(substr($orderid, 1));
$order = Mage::getModel('sales/order')->load($orderid);

This should reduce your order to, in our case 54.

However Sebastian has added the following which should work without using the substr method above (needed for multi-stores):

<pre>$orderid = "1000000054";
$order = Mage::getModel('sales/order')->loadByIncrementId($orderid);</pre>

Once loaded you can now start grabbing things from it! Why not try the following?

$giftMessage = Mage::getModel("giftmessage/message")->load($order->getGiftMessageId());
// then use echo $giftMessage->getMessage();
$address = trim($order->getShippingAddress()->getFormated(true));
// then just echo $address (will give you it formatted with \n separating lines)
$items = $order->getAllItems();
$total=0;
$products = array();
foreach ($items as $item) {
$products["prod"][] = $item->getProductId();
$products["qty"][] = $item->getQtyOrdered();
$total += $item->getQtyOrdered();
}
$total = round($total);
// then you have an array of products with id's and corresponding qty's

// also echo out the total number of qty's in your order

that's it
comments are welcome ;)

Magento - Find which Class is loaded in the current Template

2013-11-19T19:23:00.000+05:30

If you've just started working with Magento, you'll find that figuring out which class is loaded in the current template file very difficult. Here's a little snippet that helps you figure it out. Just place the following into any .phtml template files:

<?php
    print_r(get_class_methods(get_class($this)));

//or

    print_r($this->debug());

//or

    echo Zend_Debug::dump($this);

?>

that's it
comments are welcome ;)

REST - RESTClient in fierfox

2013-11-19T19:18:00.001+05:30

REST Client one of the major thing now a days mostly all developers today use to work on this REST API so how to figure out your output in firefox for REST.
Nice Add-on provided for firefox. can Install using below link.

https://addons.mozilla.org/en-US/firefox/addon/restclient/

Magento - Get the Total Price of items currently in the Cart

2013-11-19T19:06:00.001+05:30

For this only single line code will help you like below.

1	<?php echo $this->helper('checkout')->formatPrice(Mage::getSingleton('checkout/cart')->getQuote()->getGrandTotal()); ?>

that's it
comments are welcome ;)

Magneto - Programmatically remove Customer Attribute

2013-03-14T15:44:00.001+05:30

In Magento customer attributes is based on EAV structure (Entity Attribute Value)
in some cases we need to add the customers custom attributes also want to remove those
to remove the attributes the code is as below

<?php
error_reporting(E_ALL | E_STRICT);
$mageFilename = 'app/Mage.php';
require_once $mageFilename;
Mage::setIsDeveloperMode(true);
umask(0);
Mage::app();
Mage::app()->setCurrentStore(Mage::getModel('core/store')->load(Mage_Core_Model_App::ADMIN_STORE_ID));

$setup = new Mage_Eav_Model_Entity_Setup('core_setup');

    try {
        $custAttr = 'user_name';  // here enter your attribute name which you want to remove
       
        $setup->removeAttribute('customer', $custAttr);
        echo $custAttr." attribute is removed";
    }
        catch (Mage_Core_Exception $e) {
        $this->_fault('data_invalid', $e->getMessage());
    }

?>

that's it
comments are welcome ;)

Magento - Category List Dropdown in Tree view (With Parent and child)

2013-02-11T18:02:00.001+05:30

After Log Exercises With code finally I am able to build the tree view in magento with dropdown I search alot on this but nothing is there to build Category Tree Dropdown

Tree view of Category list

here is the code by using you can create the Tree Structure in magento view

my .phtml file code is as belows

<select id="category-changer" name="category-changer" style="width:150px;">
<option value="">--Select Categories--</option>
<?php
 $_CategoryHelper = Mage::helper("testthis")->getCategoriesDropdown(); 
 
 foreach($_CategoryHelper as $value){  
  foreach($value as $key => $val){

   if($key=='label'){
    $catNameIs = $val;
   }
   if($key=='value'){
    $catIdIs = $val;
   }
   if($key=='level'){
    $catLevelIs = $val;
    $b ='';
     for($i=1;$i<$catLevelIs;$i++){
      $b = $b."-";
     }
   }
  }
  ?>
  <option value="<?php echo $catIdIs; ?>"><?php echo $b.$catNameIs ?></option>
  <?php
 } 
?>
</select>

and my helper with function getCategoriesDropdown()

<?php
class Mymodule_Testthis_Helper_Data extends Mage_Core_Helper_Abstract {    

public function getCategoriesDropdown() {

    $categoriesArray = Mage::getModel('catalog/category')
            ->getCollection()
            ->addAttributeToSelect('name')
            ->addAttributeToSort('path', 'asc')
            ->addFieldToFilter('is_active', array('eq'=>'1'))
            ->load()
            ->toArray();


    foreach ($categoriesArray as $categoryId => $category) {
        if (isset($category['name'])) {
            $categories[] = array(
                'label' => $category['name'],
                'level'  =>$category['level'],
                'value' => $categoryId
            );
        }
    }
    return $categories;
}

?>

that's it

fell free to add comments

Magento - adding product and qty using url

2013-01-08T14:20:00.002+05:30

You can add the magento product using url just like below here product=101 is the product id

http://domain_name/index.php/checkout/cart/add?product=101&qty=1

Magento - Search any text into your magnto code (grep)

2012-12-15T10:25:00.000+05:30

If you want to grep the command then you can use the unix command into your terminal if you are using Ubuntu or else
if you using windows then you need ssh UI like putty.exe or else

so it takes the tile for that here is the simple method you can get this

you just need to put the following code into .php file here i am putting it into my grep.php file and I will search the text into my magento root_folder/app folder

<?php

ini_set('max_execution_time', 3600);
ini_set("memory_limit","256M");

$item = $_GET['item'];
if(trim($item) != '')
{
 $script = "grep -n -r '$item' ".dirname(__FILE__)."";
//$script = "grep -n -r '$item' ".dirname(__FILE__)."/your_folder_path_here";

 $results = exec($script,$retval);
 if($results) {
  echo "Search Done";
  echo "</br>"; 
 
 foreach ($retval as $value) {
   echo "".$value."</br>";
  }
 }
 else {
  echo "Search Done, No results found.\n";
 }
}
else {
 echo "No Search performed";
}

?>

Now how to call this or run this one
http://yourdomainname/grep.php?item={keyword}

then you can get the related records using this one
if any query put it into comments thanks

Magento - cannot initialize indexer process Error

2012-11-10T10:37:00.000+05:30

While re-indexing from the Magento Admin Panel sometimes we get errors like “An error occurred while saving the URLrewrite” or “cannot initialize indexer process” , etc

So method to solve the above problem:-

1.Go to the Magento root installation directory through FTP or Cpanel or etc and goto var/locks directory and delete all the files under it.

2. Go to the Magento database by login to phpMyAdmin or etc and run the below MySQL query

DELETE cpop.* FROM catalog_product_option_price AS cpop

INNER JOIN catalog_product_option AS cpo

ON cpo.option_id = cpop.option_id

WHERE

cpo.type = 'checkbox' OR

cpo.type = 'radio' OR

cpo.type = 'drop_down';

DELETE cpotp.* FROM catalog_product_option_type_price AS cpotp

INNER JOIN catalog_product_option_type_value AS cpotv

ON cpotv.option_type_id = cpotp.option_type_id

INNER JOIN catalog_product_option AS cpo

ON cpotv.option_id = cpo.option_id

WHERE

cpo.type <> 'checkbox' AND

cpo.type <> 'radio' AND

cpo.type <> 'drop_down';

Note :- It is advisable to take backup of database before running the above SQL query.

3.Login to Magento Admin panel & again re-index from Index management panel

refereed : http://www.magentocommerce.com/wiki/steps_to_solve_re-indexing_errors_in_magento_admin

Magento - Customer Login from Admin

2012-11-02T17:34:00.000+05:30

Here is the Nice blog on that
please check this if you really need this kind of technique

http://www.atwix.com/magento/login-as-customer-from-admin/

Magento - Updating product prices using CSV

2012-11-02T17:04:00.001+05:30

Product prices can be updated via default import profile though but this is very slow and requires lots of csv fields(besides sku & price) for updating.
Today i am going to talk about updating product prices just by using csv with two fields: sku & price(new) which is very fast enough even for thousands of products.

Steps:

1> Prepare CSV file(prices.csv) with two fields: sku & price and upload in the root of Magento installation.
You can see the snapshot how it should look like:

prices.csv

Note: Field/Values should be enclosed within double quotes(“) and separated by a comma(,). I would prefer OpenOffice for csv formatting.

2> Create a file: update_prices.php in the root of magento installation and paste the following code:

<?php

/**

 * @author      MagePsycho <info@magepsycho.com>

 * @website     http://www.magepsycho.com

 * @category    Export / Import

 */

$mageFilename = 'app/Mage.php';

require_once $mageFilename;

Mage::setIsDeveloperMode(true);

ini_set('display_errors', 1);

umask(0);

Mage::app('admin');

Mage::register('isSecureArea', 1);

Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

set_time_limit(0);

ini_set('memory_limit','1024M');

/***************** UTILITY FUNCTIONS ********************/

function _getConnection($type = 'core_read'){

    return Mage::getSingleton('core/resource')->getConnection($type);

}

function _getTableName($tableName){

    return Mage::getSingleton('core/resource')->getTableName($tableName);

}

function _getAttributeId($attribute_code = 'price'){

    $connection = _getConnection('core_read');

    $sql = "SELECT attribute_id

                FROM " . _getTableName('eav_attribute') . "

            WHERE

                entity_type_id = ?

                AND attribute_code = ?";

    $entity_type_id = _getEntityTypeId();

    return $connection->fetchOne($sql, array($entity_type_id, $attribute_code));

}

function _getEntityTypeId($entity_type_code = 'catalog_product'){

    $connection = _getConnection('core_read');

    $sql        = "SELECT entity_type_id FROM " . _getTableName('eav_entity_type') . " WHERE entity_type_code = ?";

    return $connection->fetchOne($sql, array($entity_type_code));

}

function _getIdFromSku($sku){

    $connection = _getConnection('core_read');

    $sql        = "SELECT entity_id FROM " . _getTableName('catalog_product_entity') . " WHERE sku = ?";

    return $connection->fetchOne($sql, array($sku));

}

function _checkIfSkuExists($sku){

    $connection = _getConnection('core_read');

    $sql        = "SELECT COUNT(*) AS count_no FROM " . _getTableName('catalog_product_entity') . " WHERE sku = ?";

    $count      = $connection->fetchOne($sql, array($sku));

    if($count > 0){

        return true;

    }else{

        return false;

    }

}

function _updatePrices($data){

    $connection     = _getConnection('core_write');

    $sku            = $data[0];

    $newPrice       = $data[1];

    $productId      = _getIdFromSku($sku);

    $attributeId    = _getAttributeId();

    $sql = "UPDATE " . _getTableName('catalog_product_entity_decimal') . " cped

                SET  cped.value = ?

            WHERE  cped.attribute_id = ?

            AND cped.entity_id = ?";

    $connection->query($sql, array($newPrice, $attributeId, $productId));

}

/***************** UTILITY FUNCTIONS ********************/

$csv                = new Varien_File_Csv();

$data               = $csv->getData('prices.csv'); //path to csv

array_shift($data);

$message = '';

$count   = 1;

foreach($data as $_data){

    if(_checkIfSkuExists($_data[0])){

        try{

            _updatePrices($_data);

            $message .= $count . '> Success:: While Updating Price (' . $_data[1] . ') of Sku (' . $_data[0] . '). <br />';

        }catch(Exception $e){

            $message .=  $count .'> Error:: While Upating  Price (' . $_data[1] . ') of Sku (' . $_data[0] . ') => '.$e->getMessage().'<br />';

        }

    }else{

        $message .=  $count .'> Error:: Product with Sku (' . $_data[0] . ') does\'t exist.<br />';

    }

    $count++;

}

echo $message;

3> Open your browser and run the following url:

http://your-magento-url/update_prices.php

You will see how fast the prices of corresponding skus are updated.

Source: http://www.blog.magepsycho.com/updating-product-prices-in-magento-in-easier-faster-way/

Magento - Import/Export Category Extension

2012-11-01T17:38:00.001+05:30

If there is a requirement of import/Export bulk category, So to solve this here is the import/export extension.

If you have fear about using unknown extension then you can check my another blog link
http://magento-rohan.blogspot.in/2014/07/magento-create-multiple-sub-category-in.html

Magento - Import Manufacturers

2012-11-01T17:28:00.000+05:30

Sometime when you need to deal with import of thousands of Manufacturers, then manual data entry is really a overhead and tedious.

In such case you can follow the following simple steps for the import of manufacturers (Quick & Dirty way):

Steps

Follow the following steps:

1> Create a file in the root of magento dir: manufacturer_import.php

2> Write the following code there:

<?php
require_once 'app/Mage.php';
umask(0);
Mage::app('default');
$_manufacturers = file('manufacturers.txt');
$_attribute = Mage::getModel('eav/entity_attribute')->loadByCode('catalog_product', 'manufacturer');
$manufacturers = array('value' => array(), 'order' => array(), 'delete' => array());
$i = 0;
foreach($_manufacturers as $_manufacturer){
$i++;
$manufacturers['value']['option_' . $i] = array($_manufacturer);
}
$_attribute->setOption($manufacturers);
try{
$_attribute->save();
echo 'Manufacturer successfully imported';
}catch(Exception $e){
echo 'Import Error::'.$e->getMessage();
}

3> Note i have used manufacturers.txt in the root dir with the values of manufacturers in newline format. For example:

Dell
Toshiba
Sony
Fujitsu
... and so on

You can also use array instead. But above techniques comes into handy when you have hundreds of manufacturers.

4> Simply run from browser:

http://my-magento-store/import_manufacturer.php

5> You are done.

Note: Don’t repeat 4 unless you delete those values from backend manually.

Todo: Skip the import for existing values.

Conclusion

You can use above snippet for any attribute with dropdown options like manufacturer:

$_attribute =  Mage::getModel('eav/entity_attribute')->loadByCode('catalog_product', 'any-attribute-with-option-value');

Cheers!!

refereed:

http://www.magentocommerce.com/wiki/3_-_store_setup_and_management/import_export/import_manufacturers

Magento - Login via Curl (Cross Domain)

2012-10-27T18:11:00.002+05:30

If you have ever wanted to be able to login your customers from an external domain you can do so in two obvious ways:

1. Use an HTML form to post to the login controller in Magento

<form action="http://www.mymagentosite.co.uk/customer/account/loginPost" method="post">

<input type="text" name="login[username]" value="username" />

<input type="password" name="login[password]" value="password" />

<input type="submit" name="submit" value="submit" />

</form>

However if you want to be able to log the customer in without them filling out a form then perhaps the following method is good for you?

2. Using Curl

Firstly we need to have the correct username+password for our customer – as long as you have this it shouldn’t be a problem.

On our external domain we can create a new file – something like crossdomainlogin.php.

In this php file paste in the following:

<?php

session_start();

$string = "login[username]=".urlencode("me@mymagentodomain.co.uk")."&login[password]=".urlencode("password");

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL, 'http://www.mymagentodomain.co.uk/customer/account/loginPost');

curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

curl_setopt($ch, CURLOPT_COOKIE, session_name().'='.session_id());

curl_setopt($ch, CURLOPT_COOKIESESSION, true);

curl_setopt($ch, CURLOPT_POST, true);

curl_setopt($ch, CURLOPT_POSTFIELDS, $string);

curl_setopt($ch, CURLOPT_HEADER, true);

$output = (string) curl_exec($ch);

curl_close($ch);

preg_match('/frontend=(.+); expires=/i', $output, $matches);

$temp = $matches[0];

$sid = str_replace(array("frontend=","; expires="), "", $temp);

//echo $sid;

header('Location: http://www.mymagentodomain.co.uk/customer/account/?SID='.$sid);

What the above code does is:

1. Log’s you in via Curl
2. Stores the new session ID
3. Transfers you to the Magento site with the new session ID stamped to your URL

Magento - Get loaded class into magento

2012-10-27T18:00:00.001+05:30

if you are working with .phtml files and you want to know which class is getting loaded for this

then you can use the below codes in your .phtml file

<?php
    print_r(get_class_methods(get_class($this)));
?>
or

<?php
    print_r($this->debug());
?>

or

<?php
    echo Zend_Debug::dump($this);
?>

Magento / php Development

Magento - Get Admin User details by Id or by Name

Magento - Adding Custom Option for all products dynamically

Magento - Create multiple Sub-Category in few minutes

Magento - Use of Custom Variables

Magento - Programmatically Re-Indexing

Magento - Share compare product page on facebook to get review from your friends

Magento sub links 404 error

Magento - Upload file code

Magento - Get Customer's group data into array

Magento - Admin login problem

Magento - Get Customer & Product Info from an Order

Magento - Find which Class is loaded in the current Template

REST - RESTClient in fierfox

Magento - Get the Total Price of items currently in the Cart

Magneto - Programmatically remove Customer Attribute

Magento - Category List Dropdown in Tree view (With Parent and child)

Magento - adding product and qty using url

Magento - Search any text into your magnto code (grep)

Search text into magento code (grep)

Magento - cannot initialize indexer process Error

Steps to solve re-indexing errors in Magento Admin

Magento - Customer Login from Admin

Magento - Updating product prices using CSV

Steps:

Magento - Import/Export Category Extension

Magento - Import Manufacturers

Steps

Conclusion

Magento - Login via Curl (Cross Domain)

Magento - Get loaded class into magento