Developers coming into Magento are often put off by seemingly voodoo rituals like “Don’t directly manipulate the database tables with SQL”. This may be a ritual, but it’s a smart one, and my answer to this questions tells you why. It also includes an example SQL query for fetching all the product status values when you’re ready to dive deep on Magento’s EAV structure.
Anti-SQL Bias
astorm
Frustrated by Magento? Then you’ll love
Commerce Bug,
the must have debugging extension for anyone using Magento. Whether you’re just starting out or you’re a seasoned pro, Commerce Bug will save you and your team hours everyday. Grab a copy and start working with Magento instead of against it.
Updated for Magento 2! No Frills Magento Layout is the only Magento front end book you'll ever need. Get your copy today!
Programming Quickies
Quick dispatches from the life of a working programmer.