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…