Magento themes and extensions

Magento and Google Services Integration – All-In-One Guide

Posted on June 24th, 2011 | Posted by admin

There are tutorials all around the web as well as at the Inchoo website that guide you through various Google services integration with Magento eCommerce platform. I wanted to unite all of these resources on one place and also bring something new to the table.

In this guide, we’ll talk about:

1. Google Analytics integration with Magento
2. Google AdWords conversion tracking with Magento
3. Google Base integration with Magento
4. Google’s Feedburner service integration with Magento
5. Tracking conversions in numbers instead of percentage with Google Analytics custom report

Simple Magento Extension generator

Posted on June 24th, 2011 | Posted by admin

Writing Magento modules on a everyday basis can become extremely boring job when it comes to the part where you define your module directories, config file, model, block, helper, etc. What I am trying to say is that there is significant amount of repetitive work being done each time you start new module development. To compensate for this a little bit, I created this little Magento module that helps you create other modules. Hope it does not sound to much confusing.

To access the module functionality you need to install by copy-pasting the content of archive to your Magento installation and then open the http://mystore.loc/alpha url. I realize that using “alpha” for the module name is not much innovative. Basically you can look at this module as being a skeleton upon which you might build your own module generator. The code itself was done in a hasty way so it might need some refactoring if you wish to play with it. I plan on continuing my work on this module. This is just an alpha version  .

How to generate your own reports in Magento

Posted on June 22nd, 2011 | Posted by admin

Coolest thing in Magento’s is generating your own reports.
The quickest way to create Magento’s reports is to generate them through the grids.

First you will need to create collection of data which you want to display and save.
Then you have to add those fields in your grid, the rest is piece of cake.

In your custom grid class you need to call method “addExportType” from “Mage_Adminhtml_Block_Widget_Grid” class
(your custom grid class needs to extend Mage_Adminhtml_Block_Widget_Grid class).
Code of protected function _prepareColumns() in your Grid class:

How to set up DNS records manually

Posted on June 22nd, 2011 | Posted by admin

Hi! Today I’ll explain some basic terms and show you on a simple example how to set up DNS records manually. First of all, let me start by explaining some basic terms.

First, you should be able to differ web server, mail server and name server (these are the 3 basic servers for the complete web solution – for running web site and functional e-mail service).For the simplicity of explanation, lets use as our domain we wish to set up, and and as our nameservers.

Usage of temporary tables in MySQL databases

Posted on June 22nd, 2011 | Posted by admin

Hi! My recent project had some specific requirements regarding the work with database. Since DB server had some limitations (regarding number of queries), and fairly big number of queries that needed to be executed I created a solution that included temp tables. And now, I’d like to explain how to use them and why.

Suppose that in your application, you need to execute a calculation on a set of tables. The usual approach is to create a query that defines the joins between multiple tables, and selects the data from the joined tables. The problem with that approach is that every time you call that the query, the tables have to be rejoined in order to create the result. And that is usually fairly resource hungry. Instead, you can get around the problem by putting the results into temporary table, so the values are there while the database connection lasts.