Magento Themes and Magento Extensions

How To Setup Google Adwords Conversion Tracking On Magento

Posted on May 5th, 2013 | Posted by admin

Setting up Google Adwords Conversion Tracking on your Magento store

1. Open this file:

2. At the bottom of the file, insert this code:

    $order_details = Mage::getModel(’sales/order’)->loadByIncrementId(Mage::getSingleton(‘checkout/session’)->getLastRealOrderId());
    $adwords_saleamt = $order_details->subtotal;

3. Login to your Google Adwords account

Magento Display All The Categories In The Left Navigation Lists

Posted on May 4th, 2013 | Posted by admin

In magento themes have the option to list out category list in the left navigation. But some of the themes are not available.

So, we need to create manually to list out the category lists in left nav bar.

1. We need to create left.phtml file in the following location

app\design\frontend\default\YOUR THEME\template\catalog\Navigation\

Then place the followiing code to list out the left navigation category lists like category and subcategory lists.

How to find the size / rows of Magento database & tables?

Posted on May 2nd, 2013 | Posted by admin


Magento is a giant e-commerce application having more than 300 tables. It uses an eav model concept and provides different complex features which makes the database huge.

Sometimes you may wonder what’s the database size of your Magento database or individual tables so that you can work on some optimization task or freeing some of your server space.
Here we are going to discuss some SQL queries which seems to be helpful.

SQL Snippets

1. Find size & rows of Magento database

Magento: How to check if current page is homepage

Posted on April 30th, 2013 | Posted by admin

Magento: How to check if current page is homepage

If you are checking in header.phtml then this will work for you :

if($this->getIsHomePage()) {
echo ‘Homepage!’;
} else {
echo ‘NOT in Homepage!’;
here is an alternative way to check for homepage( works in all .phtml files.):->

$routeName = Mage::app()->getRequest()->getRouteName();
$identifier = Mage::getSingleton(‘cms/page’)->getIdentifier();

Magento – Add Custom Category Attributes

Posted on April 23rd, 2013 | Posted by admin

Magento – Add Custom Category Attributes

A client wanted to add a description to each of his product categories, such that the first built-in description would be above the product listing, and the second description would be below the product listing.  Rather than have them create static blocks for every category, it was obvious that I’d have to create a new category attribute.

Fortunately, I stumbled upon one possible solution.  The method doesn’t involve creating a full-blown module, rather, just a few database modifications using phpMyAdmin.

Summarized, the process comes down to:

  1. Create a new row in the eav_attribute table, one that mimics a category’s meta-description attribute with everything being the same except for a unique identifier and a label.
  2. Create a new row in the eav_entity_attribute table, to provide a sort order for your newly created attribute, following in the format footsteps of the existing rows.
Page 4 of 51« First...«23456»102030...Last »