One of the differences between Magento eCommerce platform and lets say WordPress, when looked from developer point of view, is “avoid raw queries” approach. For a web application, Magento is massive system. His database, although not so massive but surely breathtaking with around 220 tables forces you to use “eye candy” EAV model to do even simple things.

For instance, if I were to tell you that I want you to retrieve 5 simple products from database that have price in the range of 200-600USD you would most likely spent 1-4 hours trying to work out the query. In the end you would be lucky if you even get the query that wont break on next Magento upgrade. Let me just remind you on some of the things you need to be careful in example above.

It’s been a while since my last post. I’ve been working on Magento quite actively last two months. I noticed this negative trend in my blogging; more I know about Magento, the less I write about it. Some things just look so easy now, and they start to feel like something I should not write about. Anyhow…. time to share some wisdom with community

Our current client uses somewhat specific (don’t they all) store set. When I say specific, i don’t imply anything bad about it. One of the stand up features at this clients site is the advanced search functionality. One of the coolest features of the built in advanced search is the possibility to search based on attributes assigned to a product.

To do the search by attributes, your attributes must have that option turned on when created (or later, when editing an attribute). In our case we had a client that wanted something like

Those of you who know what SVN is, feel free to skip this article. Those of you who are not familiar with SVN, this is a must-read. If you use standard FTP to upload all Magento files, you may find this process very time consuming. Magento 1.1.8 has over 6.700 files in over 2.200 folders. FTPing can sometimes take few hours on some servers. Let’s look at alternatives.

Both alternatives require SSH access to the server. I’m aware that some low quality webhosting providers do not provide you with SSH info immediately. If you don’t have SSH info, ask webhosting support. If they don’t give it to you, change webhosting provider. Make it a rule, you’ll make your life much easier.