Book Image

Magento 1.8 Development Cookbook

By : Bart Delvaux, Nurul Ferdous
Book Image

Magento 1.8 Development Cookbook

By: Bart Delvaux, Nurul Ferdous

Overview of this book

<p>Magento is an open source e-commerce platform which has all the functionality to function from small to large online stores. Its architecture makes it possible to extend the functionalities with plugins where a lot of them are shared by the community. This is the reason why the platform is liked by developers and retailers.</p> <p>A practical developer guide packed with recipes that cover all the parts of Magento development. The recipes will start with the simple development exercises and get the more advanced as the book progresses. A good reference for every Magento developer!</p> <p>This book starts with the basics. The first thing is to create a test environment. Next, the architecture, tools, files and other basics are described to make you ready for the real work.</p> <p>The real work starts with the simple things like theming and catalog configuration. When you are familiar with this, we will move on to more complex features such as module and database development. When you have survived this, we will move on to the last part of making a shop ready for launch: performance optimization and testing. This book will guide you through all the development phases of Magento, covering the most common pitfalls through its recipes.</p>
Table of Contents (19 chapters)
Magento 1.8 Development Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Working with EAV tables


The EAV table is a database model that is used for some entities in Magento. In this recipe, we will explore the details of the EAV implementation in Magento.

Getting ready

The EAV pattern is used for some entities in Magento such as the product entity. In this recipe, we will make some queries for updating a product using SQL queries. Open your database client and prepare yourself for running some complex queries.

How to do it...

The following steps show you how you can create a query to return the data of a Magento EAV model:

  1. The Magento EAV entities are declared in the eav_entity_type table. Run the following query to see which EAV entities are available:

    SELECT * FROM eav_entity_type;
    

    Remember the ID of the catalog_product entity.

  2. To get the attributes related to a product, we have to look in the eav_attribute table. To see which attributes are related to a product, we have to run the following query:

    SELECT * FROM eav_attribute WHERE entity_type_id = 10
    

    Make sure 10...