Magento Themes and Magento Extensions

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.

Web server – contains our www.example.com web site files

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>

How to setup http protocol with SSL on LAMP environment

Share
Posted on June 21st, 2011 | Posted by admin

Today I’ll explain how to setup testing environment with https protocol on Ubuntu. It should take around 10-15 minutes to do it manually. I assume you have installed LAMPP on your development PC.

First thing first. We’ll need an SSL certificate to even begin. So I’ll explain how to create self-signed SSL certificate. There are even free trusted SSL certificates out there, but i haven’t tried them.:DYou can look it up here: http://www.cacert.org and http://cert.startcom.org. But lets go back on topic of creating it by ourselves.

13 things to do before you start building an online store

Share
Posted on June 21st, 2011 | Posted by admin

If there is one most valuable thing that you need to know before you build your first online store it is this: Build it and they’ll come doesn’t work. This article will try to prepare a company that is thinking about building an online store for all the things they need to know before they start this process.

Research and goals

1. Competitors – The first thing you need to do is research your competitors. Have a look at other online stores that are selling the same or similar products. Gather as much information as you can about their marketing tactics, technical solutions and the way their business works. Now look at your business realistically and ask yourself if you can compete with that. Figure out where is your place in the ecosystem. Are you able to compete with better prices, or are you able to compete with the quality? Maybe you can market your products better? Maybe you can have a better technical solution? Maybe you can advertise with better ROI? If there is no way you can compete with them, your online store will be a big waste of money so this is the most important step in building an online store and conclusions you draw from this research will guide you into different directions while you continue reading this checklist.