Magento Themes and Magento Extensions

Remove indexing notification on magento

Share
Posted on May 13th, 2013 | Posted by admin

This index notification that magento has not yet been indexed its categories,artibuts and so on relly anoyes when it come to appear each time we login an use the Magento admin panle

it is luck as the following:

One or more of the Indexes are not up to date: Product Attributes, Product Prices, Catalog URL Rewrites, Product Flat Data, Category Flat Data, products including in this category, Catalog Search Index, Stock Status, Tag Aggregation Data. Click here to go to Index Management and rebuild required indexes

How to create a sub-query on Magento Way?

Share
Posted on May 11th, 2013 | Posted by admin

How to create a sub-query on Magento Way?
You can use the next examples:

public function getActiveCustomers($date)
{
    $orderTable = Mage::getResourceModel('sales/order_collection')
        ->addFieldToFilter('created_at', array('gt' => $date));
    $this->getSelect()
        ->joinLeft(array('order_table' => new Zend_Db_Expr( '(' . $orderTable->getSelect() . ')')),
'e.entity_id = order_table.customer_id')
        ->where('order_table.entity_id', 'notnull');
    return $this;

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

Share
Posted on May 8th, 2013 | Posted by admin

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
Magento - Category List Dropdown in Tree view

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

my .phtml file code is as belows

How To Append Additional Fields In Magento’s Default Contact Form?

Share
Posted on May 6th, 2013 | Posted by admin

Magento itself provides a lean Contact Us form which can be used by customers to contact the store owners. But, what if you want to take additional inputs from your user? Customizing Magento Contact Us form is one of the most common request any Magento developer recives. So, here is an easy way of appending/inserting more fields to customize Magento Contact form.

Step 1. Edit form.phtml file located atapp/design/frontend/default/YOUR_THEME/template/contacts/form.phtml. Suppose you want to add subject field after telephone. Then find the following lines of code

Magento : Delete Test Orders & Customers using SQL

Share
Posted on May 1st, 2013 | Posted by admin

When moving a Magento development site to live or cleaning up dummy orders and customers, you might want to wipe out all test customers and orders from the Magento database / backend. The following SQL queries can be run on the database. Be careful: make a backup of the database before doing this. I’ve run this code over and over again, without any trouble, but still, just be careful.

Page 3 of 12«12345»10...Last »