The Magento indexing mechanism is one of the core functionalities that improve a site performance. However, when programming bulk imports of data it is ideal to stop the indexing until the import is completed. For two reasons, first the indexing will slow the process, as on each line of data imported a reindex of data … Continue reading Magento Reindex Programmatically

Note: This article is based on the article Magento quick way to create order invoice published on 10 June 2010. Update 13 June 2011: Please note that it is recommended that API version 2 is used. The article has been updated to reflect this recommendation. Also please note that the capture() method is not required … Continue reading Creating an Invoice

Static blocks are a means of allowing store owners to modify the text displayed in sections of a page from the admin site. For example, a static block can be added to the header to show seasonal promotions. Static blocks can be added to templates through the use of layout files. Adding a static block … Continue reading Adding a static block to a template using layout files

In the last article we saw the different ways how one can analyse the SQL Queries running under the Magento’s hood. These are listed here again: To see all queries issued to the database Modify the core Magento code that deals with the database query generation Enable Magento Pdo MySql debugging Switch on MySQL logging … Continue reading Magento SQL Logging – (Part II)

As with any e-commerce solution Magento stores nearly all the data of the online store in a database. To simplify the communication between code and the database Magento provides a number of abstraction functions. The use of abstraction to communicate with the database leads to the question of what queries are being issued to the … Continue reading Magento SQL Logging – (Part I)