Multiselect Options Text

To render the text-values of an multiselect in a BE-grid: <?php /** * * Magento * * NOTICE OF LICENSE * * This source file is subject to the Open Software License (OSL 3.0) * It is available through the world-wide-web at this URL: * http://opensource.org/licenses/osl-3.0.php * * * @category AskSheldon * @package AskSheldon_Adminhtml * […]

Image resizer

Just a testscript to test the quality of Magento’s image processing: <?php /** * * Magento * * NOTICE OF LICENSE * * This source file is subject to the Open Software License (OSL 3.0) * It is available through the world-wide-web at this URL: * http://opensource.org/licenses/osl-3.0.php * * * @category AskSheldon * @package AskSheldon_FeaturedProducts […]

Create your own Backend theme

When developing Magento Backend functionalities, sometimes you need to add own layout files or templates. In these cases it is a good idea to create a new Backend theme under adminhtml and to modify the Magento configuration to lookup layout files and templates in this new theme before searching in the default one. Therefore you have to create […]

Prevent unwanted email delivery

If you have multiple instances of a Magento shop – for example a staging and a production environment – sooner or later you’ll come to the point, where you need to  synchronize the database from live- to stage-system to get realistic production-like application behavior. In this case it is a good idea to prevent the system from sending mails […]

Get stores last order increment ids

This can be done by the following database query: SELECT cs.store_id, csg.name AS group_name, cw.name AS website_name, cs.name AS store_name, increment_last_id AS last_increment_id, entity_type_code AS entity_code FROM eav_entity_store AS ees INNER JOIN eav_entity_type AS eet ON eet.entity_type_id = ees.entity_type_id INNER JOIN core_store AS cs ON cs.store_id = ees.store_id INNER JOIN core_store_group AS csg ON csg.group_id […]

Increment order increment ids for all stores

The following query increments the last increment ids for all store by 100: UPDATE eav_entity_store AS ees INNER JOIN eav_entity_type AS eet ON eet.entity_type_id = ees.entity_type_id SET ees.increment_last_id = ees.increment_last_id + 100 WHERE eet.entity_type_code=’order’; The actual values for each store can be queried as shown in Get stores last order increment ids.

Install CMS pages with your module

You can do this as shown in the following example of a Magento data setup script: <?php /* @var $installer Mage_Core_Model_Resource_Setup */ $oInstaller = $this; $oInstaller->startSetup(); $aCmsPages = [ [ ‘title’ => ‘FAQ’, ‘root_template’ => ‘two_columns_left’, ‘meta_keywords’ => ‘FAQ’, ‘meta_description’ => ‘FAQ’, ‘identifier’ => ‘faq’, ‘is_active’ => 1, ‘stores’ => 0, ‘sort_order’ => 0, ‘content_heading’ => […]

Install CMS blocks with your module

You can do this as shown in the following example: <?php /* @var $installer Mage_Core_Model_Resource_Setup */ $oInstaller = $this; $oInstaller->startSetup(); $oCmsBlocks = [ [ ‘title’ => ‘Footer bar for benefits’, ‘identifier’ => ‘footer-bar’, ‘content’ => <<<HTML <ul> <li>Shop Benefit 1</li> <li>Shop Benefit 2</li> <li>Shop Benefit 3</li> <li>Shop Benefit 4</li> <li>Customer Service (D): <a href=”tel:08008828838″ class=”tel”>0800 […]