Magento themes and extensions

Magento and Google Adwords conversion tracking

Share
Posted on June 22nd, 2011 | Posted by admin

If you use Google Adwords advertising for your Magento web store, you will probably need this module. This module will be very useful, because Magento doesn’t have functionality for tracking Adowrds conversion. Feel free to download module and use it on personal responsibility. I’m using this module on web store without any problems.

You need to know that this module will track Adwords conversion over checkout/success page. At checkout/success page will be executed javascript (this is code of Block for checkout/success page):

How to generate your own reports in Magento

Share
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

Share
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 www.example.com as our domain we wish to set up, and dns1.examplens.com and dns2.examplens.com as our nameservers.

Usage of temporary tables in MySQL databases

Share
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.

Custom typography in Magento – Cufón

Share
Posted on June 22nd, 2011 | Posted by admin

Are you sick and tired of boring, old web-safe fonts? For some time now, there are a couple of really quality solutions for their replacement. I believe Cufón is one of the most popular. This article will help you learn how to implement it in your Magento online store.

Follow these steps (and you might find white rabbit):

  1. Choose the font you want to use. Make sure the EULAs of these fonts allow Web Embedding.
  2. Go to Cufón website , upload you font, let the Cufón do its magic and download your .font.js file.
  3. While you’re there, download cufon-yui.js , you’ll need it too.
  4. Place downloaded files in js/cufon/ folder on your server.
  5. Open page.xml file of your theme and place this code inside your head section
    1
    2
    <action method="addJs"><script>cufon/cufon-yui.js</script></action>
    <action method="addJs"><script>cufon/YourFontFile.font.js</script></action>
  6. Open head.phtml file of your theme and place this code right before the end of it.
    1
    <script type="text/javascript">Cufon.replace('h1, h2');</script>