Getting super attributes info using raw SQL in Magento

Introduction While creating a configurable product, you need to create an attribute(s) which will be used as a select option(s) for the customer(For Example Color, Size, etc.). These kinda attributes are called super attributes or configurable attributes. In this article, we will be discussing how to get different info about super attributes using raw SQL. …

Read more

Magento EAV structure & role of eav_attribute’s backend_type field

Introduction: Magento database is based on EAV(Entity Attribute Value) architecture. And it uses this architecture, especially for categories, products, customers & customer addresses. Before Magento version 1.4.x it used EAV structure for orders as well but thereafter order’s EAV structure has been converted to a flat structure. From the definition of EAV: Entity(E): Entity actually …

Read more

Configuring Magento for Development / Debug Mode

Configuring Magento for Development/Debug Mode

Configuring Magento for Development / Debug Mode: 1. Disable Cache System > Cache Management > Select All [check-boxes] > Actions = Disable > Submit 2. Re-Index All System > Index Management > Select All [check-boxes] > Actions = Reindex Data > Submit 3. Disable Compilation System > Tools > Compilation > Disable Note: By default …

Read more

Usage of Magento event: core_block_abstract_to_html_after

Introduction There are lots of events in Magento which are dispatched by default. Among them ‘core_block_abstract_to_html_after’ is the one. Recently we have re-developed the Easy Template Path Hints extension using this event as the previous version of the extension has some confliction issues with other modules. In this article we will demonstrate the implementation of …

Read more

How to change default sort order/dir in Magento search results?

Introduction Today we will be discussing how to change the default sort order/dir in Magento search results (simple & advanced). Regarding solution, some say you need to change the /app/code/core/Mage/Catalog/Block/Product/List/Toolbar.php file in order to change the default sort order field and dir. But you don’t need to do so as there is an extremely easy …

Read more