Magento: Installing New Language Package [Step-by-Step Guide]

Here is the step-by-step procedure to install new language package on Magento. Let’s assume that you want to install Dutch language package. 1. Go to this link. 2. Get the extension key. 3. Login to Magento admin 4. Go to System -> Magento Connect -> Magento Connect Manager 5. Install your desired language package 6. … Read more

Magento Paypal: Email, Shipping Cost & Order Status issue in version 1.4.0.1

Magento version 1.4.0.1 has some issues with Paypal email, shipping cost and order status. Note: All these issues occur when payment is done through Paypal 1. Order confirmation email is not sent Fix: – Open app/code/core/Mage/Checkout/Model/Type/Onepage.php – Go to line 626 – Comment out the IF condition as below: /** * we only want to … Read more

Magento: Incorrect template design for login and register page due to Persistent Shopping Cart

Problem: I am using Magento 1.6 and my login and register page design has problem. It is not taking the template path from my custom theme. Instead, it is taking the template path from base persistent folder. For example, the login template path is taken from frontend/base/default/template/persistent/customer/form/login.phtml instead of frontend/default/MY_THEME/template/customer/form/login.phtml It’s strange how this persistent … Read more

Magento: Overriding / Rewriting Mysql4 and Resource Eav Collection Class

Here is a tip to override/rewrite Mysql4 and Resource Eav collection class. I will only be including the config xml code. You can read more about Model Overriding over here: Magento: Model Controller Block Helper Override By Mysql4 Collection Class, I mean like the following class: Mage_Sales_Model_Mysql4_Order_Collection Overriding Mysql4 Collection Class <global> <models> <sales_mysql4> <rewrite> … Read more

Magento: Adding OR and AND query condition to collection

Here is a quick tip to add OR query and AND query to collection object. I am implementing this on product collection. Getting product collection // PRODUCT COLLECTION $collection = Mage::getModel('catalog/product')->getCollection(); Adding AND query condition Filtering collection to select only those products whose sku is like ‘ch’ AND status is equal to 1 (i.e. enabled … Read more

Magento: A small bug on module creator

Module Creator helps in building basic module structure in Magento. It can be used as a standalone application or a Magento module in the process of creating a new Magento module. You can download and find more about it here: http://www.magentocommerce.com/wiki/5_-_modules_and_development/0_-_module_development_in_magento/custom_module_with_custom_database_table I found a small bug while working with a module created through Module Creator. … Read more

The Top 20 replies by programmers when their programs do not work

The Top 20 replies by programmers when their programs do not work: That’s weird… It’s never done that before. It worked yesterday. How is that possible? It must be a hardware problem. What did you type in wrong to get it to crash? There is something funky in your data. I haven’t touched that module … Read more

Alter MySQL table to add & drop column & add Foreign Key

This article shows:- – How to add column to mysql database table after the table has already been created – How to delete column from mysql database table after the table has already been created – How to add foreign key to table column after the table has already been created Basically, all this can … Read more