Currently browsing

Data migration from ZenCart and OsCommerce to Magento

Here is instruction on how to import customers, orders, categories, products and images from ZenCart or OsCommerce to Magento. 1) Install osCommerce Migration Tool ZenCart and OsCommerce databases are equal, because ZenCart is an OsCommerce fork project. osCommerce Migration Tool was developed by Magento Core team, you can install it …

Magento: How to create extension package?

You have built a custom magento extension (magento module) and you want to package it and submit it to magento connect (magento extension directory). This article shows how to create Magento extension package. I have included images for every step which I followed while creating extension package for my module …

Magento: Event Observer with Save before and Save after

Magento has this cool functionality of Event Observer. Magento follows the Observer Design Pattern for its event hooking system. With this Event Observer Hook, additional functionality can be added without modifying the core code. Looking for improvement for your Magento Store? Facebook Connector Extension Product related article extension Magento Offer …

Magento: Join, filter, select and sort attributes, fields and tables

In my previous article (Magento: Very Useful Collection Functions), I had written about database interaction functions present in class Varien_Data_Collection_Db. Here, I am going to explain some database interaction functions present in the class Mage_Eav_Model_Entity_Collection_Abstract. These collection functions are very useful to select data from Magento database. We need them …

Magento: Set Random Order in Collection using RAND()

Scenario: You have created a custom module. You have entered certain data in your database. You need to show the data randomly. Solution: In MySQL the rand() function helps the select query to fetch data randomly. In Magento, you can select random rows from MySQL table usingZend_Db_Expr(‘RAND()’). You have to …

Magento: Block Controller Model Helper Override

This article will show how you can override Magento Block, Controller, Model and Helper files. We will be dealing with the config XML files and the class files to override. We override Magento core classes to update/modify the core functionalities according to our need. We can directly makes changes in …