In this tutorial, i will show you all different magento admin form fields we can use in admin forms. Magento…

UPDATE your_table SET your_field = REPLACE(your_field, ‘articles/updates/’, ‘articles/news/’) WHERE your_field LIKE ‘%articles/updates/%’

By deafult, when customer/user log in Magento, he/she is redirected to its account page. But if you’d like to redirect…

Get all disabled products from Magento using product collection: <?phpset_time_limit(0);error_reporting(E_ALL ^ E_NOTICE);ini_set(“display_errors”,’On’); require_once ‘app/Mage.php’;umask(0);Mage::app(‘default’); $products = Mage::getModel(‘catalog/product’)->getCollection()    ->addAttributeToSelect(‘*’)  ->addFieldToFilter(‘status’,Mage_Catalog_Model_Product_Status::STATUS_DISABLED); $products->load();foreach($products…

A collection is a Model type containing other Models, it is basically used in Magento to handle product lists (ie….

Creating a module which interact with a database table is quite simple. Most of the developers use magento module creator…

UPDATE catalog_product_entity_media_gallery AS mg,       catalog_product_entity_media_gallery_value AS mgv,       catalog_product_entity_varchar AS evSET ev.value = mg.valueWHERE  mg.value_id = mgv.value_idAND mg.entity_id = ev.entity_idAND ev.attribute_id…

If re-indexing the Product flat data index gives an unknown re-indexing error or “Some problem with re-indexing process” error message…

Sometimes We need to remove the Attribute from already build Configurable product…As it is hard to remove but we can…

Create attribute     Drag it to appropriate attribute set     Go to phpmyadmin, table ‘catalog_eav_attribute’ and look at the last…

If certain precaution are not taken on time then magento Database could go extremely large.AS most of the low performance…

First of all overwrite the file app/code/core/Mage/Catalog/Model/Layer.php and copy this file to app/code/local/Mage/Catalog/Model/Layer.php In function getProductCollection(), Put this code after…

We know Magento support multiple currency. Use following code given below to check current currency in the Magento site frontend….

addAttributeToFilter is a function that can be called on a product collection in Magento. In short, it adds a condition…

When we are filtering data in Magento, time occurs when we want to fetch result after filters like Not equal,…

In this blog we will see how generate a category tree, recursively showing all categories and sub categories. The code…

Here, I will show you the code to get the most viewed products in Magento. The function addViewsCount() filters the…

There are some pages in Magento with no breadcrumbs enabled by default. In order to enable it, for example, on…

In order to create the menu a function need to be added. The function that will receive the ID of…

Magento Layered Navigation in Drop-Down It is very simple.We just need to replace the contents of file/app/design/frontend/default/your-magento-template/template/catalog/layer/filter.phtmlwith <select onchange=”setLocation(this.value)”>  <option…

When reindexing “Category Flat Data ” gives error Cannot initialize the indexer process.  I run the below query and the…

<?php$simpleProductId = 465;$parentIds = Mage::getResourceSingleton(‘catalog/product_type_configurable’) ->getParentIdsByChild($simpleProductId);$product = Mage::getModel(‘catalog/product’)->load($parentIds[0]);echo $product->getId(); // ID = 462 (aka, Parent of 465)?>

If you are building website in Magento, you may have noticed that there are two columns insales_flat_order table which are confusing….

//linked in like buttonhttp://developer.linkedin.com/plugins/share-button //twitter tweet button https://twitter.com/about/resources/buttons#tweethttps://dev.twitter.com/docs/tweet-button //facebook like button http://developers.facebook.com/docs/reference/plugins/like/ //google +1 button http://www.google.com/intl/en/webmasters/+1/button/index.html