How to run Magento 1.3.X on PHP 5.3?

You know that Magento version (>= 1.4.X) works well under PHP 5.3. But what if you want to run the Magento 1.3.X under the same AMP(Apache/Mysql/PHP) package? You may need this in order to test the extension/theme compatibilities. In order to run Magento 1.3.x on PHP 5.3, you need to replace the following function from …

Read more

List out all the product names in Magento via SQL code

You know we can easily fetch the product names using the Model object. But what if you want to list out all the product names via SQL code? Don’t worry here is the SQL code for you: SELECT `value` AS product_name FROM catalog_product_entity_varchar WHERE entity_type_id = (SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = ‘catalog_product’) AND …

Read more

Magento: Export / Import CMS pages / Static Blocks Via SSH

It’s really a tedious task when you have to copy all the cms pages/static blocks from your development server to the live server. If you are importing the whole database then you are lucky enough but if you are updating in already installed Magento server then :(, luckily you can use the following commands via …

Read more

How to convert varchar type attribute to price type in Magento?

People make mistakes. It’s part of human nature. But some clients don’t understand this 😉A few months ago I made some mistake in creating a custom attribute for a product. I created attribute type = ‘varchar’ but it was supposed to be of type = ‘price’ since it was going to be used for shipping …

Read more