Magento

Magento Newsletter Tutorial

Magento Newsletter Tutorial When running an e-commerce store it is necessary to send out promotional emails and campaigns. Apparently, Magento having built in newsletter functionality and it’s easy to use. It allows site administrators to create and send email campaigns from admin panel. Before going to Magento newsletter page, we just need to set Magento email […]

Continue

Direct SQL queries in Magento

This tutorial mainly demonstrates direct SQL queries in Magento.  Magento data models are giving great flexibility for the data processing. We don’t need to touch the complex SQL statements because of this feature. This often gives really quick development speed and accuracy more over a bulletproof approach. But several situations it much needed to execute […]

Continue

Search by only product name in Mini Search In Magento

Magento has a good search functionality. By default when someone searches it search through all the description and short descriptions. So sometimes at first look this results appears to be strange. We need Search by only product name in Mini Search In Magento But the reason Magento pick this up because these keywords might be present […]

Continue

Get a parent category and all sub-sub–sub categories in Magento

Getting all sub(recursively) categories in Magento, not an easy task. I’ve seen so many of them looping through the category model and creating overhead to the server. It’s mainly because the each model creates and SQL query. Good performance Single Query Solution: Let $parentCategory be your Main Category, then this collection will load all subcategories, […]

Continue

How to get data from Magento System Configuration

Magento stores all the configuration values in the database, but it has a particular format to retrieve the data. Getting data from system configuration table is easy. sectionName, groupName and fieldName are present in etc/system.xml file of your module. It will automatically fetch config value of currently viewed store as you have the option to enable […]

Continue