Magento Project Stratus

Share
Posted on April 28th, 2011 | Posted by admin

Guido Jansen recently broke the news of the new landing page at Magento’s official website that promotes so far unannounced service under the name of “Project Stratus“. This appears to be Magento in the cloud.

The project appears to be preparing for a closed beta testing and they are accepting applications. You can also enter your email to receive more information about the project once it becomes available.

The rumors of some sort of official Magento SaaS solution were out there for a while. I think I first read about such ideas more than a year ago. First time I heard of it, I was kind of worried that such a solution would significantly reduce the amount of work companies such as ourselves receive, since our work is mostly related to customizing Magento, and I didn’t know if there would be any way for us to continue doing this in a SaaS world.

Custom typography in Magento – @font-face

Share
Posted on April 28th, 2011 | Posted by admin

If you want to add some juice to your e-commerce website, and be different from the others, you could add some custom fonts for you headings, product titles or prices.
The best technique these days, in my opinion, is to use browser’s native method: @font-face. With a little tweaking, you can make it work in almost all browsers.

Usage

The basic usage would be to add @font-face rule to your stylesheet, with a path to your font file.

1
2
3
4
@font-face {
font-family: KomikaDisplayRegular;
src: url(/KomikaDisplayRegular.otf);
}

And then when you want to use that font, just reference it in your CSS declaration.

1
2
3
h1 {
font:60px/68px 'KomikaDisplayRegular',Arial,sans-serif;
}

Listing products by attribute

Share
Posted on April 27th, 2011 | Posted by admin

This is step by step tutorial for the beginners that will show you how to list products by attribute.
I will start with functions that Magento already has built-in: New products and Promotional products.
All the instructions below is made from Magento Professional 1.9.0.0

Listing products with attribute New

You can find settings for defining New attribute in Magento administration under Manage products in Products management. For this tutorial I will use CMS page called Homepage as example.
In CMS Page layout -> Layout Update XML is defined template for CMS page by

MySQL – Left, Right, Outer or Inner Join? No – the SELF JOIN

Share
Posted on April 27th, 2011 | Posted by admin

Hi to all of you! Today, I’m going to explain SELF JOIN in MySQL – I’ll answer why and then how should you use it.

But first, a short explanation. I’m going to explain a non often used SQL that came in hand recently. If you are still learning MySQL, please refer to some basics first – a good start. And now, to the fun part. :D

Why do anyone need SELF JOIN?

Well, SQL self-join is very useful when you want to retrieve related data stored in one table such as organizational structure. Its basically an inner join with reference on the table itself.

Taming magento errors display

Share
Posted on April 27th, 2011 | Posted by admin

Murphy says: “Anything that can go wrong, will go wrong”. When it happens to your store it’s best to get the information about it ASAP and present the error in the most humane possible way. Let’s do it!

Since ever Magento presented it’s errors on the front-end for everyone to see and it was good for the developers but once the site has gone live that couldn’t be an option anymore. In Magento 1.4 those errors are now hidden and all your customer could get about the actual error was the “error number”.