Magento Solutions | The Magento Expert

Change column count of category page in admin area (backend) (Magento 1)

Mex 5. September 2014 Magento Solutions

Open the category in the admin area (backend) and add the following xml to the layout update section.

<reference name="product_list">
    <action method="setColumnCount"><count>4</count></action>
</reference>

</reference>

View solution

Suppress warning when searching on https secured pages (Magento 1)

Mex 15. Juli 2014 Magento Solutions

Searching for something while being on a https secured page opens a warning dialog. Thats annoying for the visitor of your page. To fix that problem, open a suitable module or create a new one and add the following xml…

View solution

Calling a stored procedure from Magento

Mex 16. Juni 2014 Magento Solutions

Using the code below you can call a stored procedure directly from Magento.

$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$query = 'CALL stored_procedure()';
$results = $readConnection->exec($query);

$resource = Mage::getSingleton('core/resource');

$readConnection = $resource->getConnection('core_read');

$query = 'CALL stored_procedure()';

$results = $readConnection->exec($query);

View solution

Redirecting to any page from a template (phtml) (Magento 1)

Mex 14. Mai 2014 Magento Solutions

Use the code below to redirect to any page from a Magento template (phtml) file. In this case, it is a redirect to the home page.

Mage::app()->getFrontController()->getResponse()->setRedirect(Mage::getBaseUrl());

1	Mage::app()->getFrontController()->getResponse()->setRedirect(Mage::getBaseUrl());

View solution

Changing the category page column count programmatically (Magento 1)

Mex 5. Mai 2014 Magento Solutions

Add the following code to your themes catalog\product\list.phtml file. It will change the column count to 2.

$this->setColumnCount(2);

1	$this->setColumnCount(2);

View solution

Getting a blocks HTML in a template (phtml) (Magento 1)

Mex 5. Mai 2014 Magento Solutions

The below code shows how to echo the HTML of a block with the id ‘my_block’.

echo $this->getLayout()->createBlock('cms/block')->setBlockId('my_block')->toHtml();

1	echo $this->getLayout()->createBlock('cms/block')->setBlockId('my_block')->toHtml();

View solution

Changing the admin route for security reasons (Magento 1)

Mex 7. April 2014 Magento Solutions

One step towards making your shop more secure is to change the default admin route from http://www.your-shop.com/admin to something more secure and less guessable. The route must be changed in app/etc/local.xml.

<admin>
    <routers>
        <adminhtml>
            <args>
                <frontName>your-new-backend-route</frontName>
            </args>
        </adminhtml>
    </routers>
</admin>

<admin>

<args>

<frontName>your-new-backend-route</frontName>

</args>

</adminhtml>

</routers>

</admin>

After adding that to your app/etc/local.xml file, clear…

View solution

Getting products from a category (Magento 1)

Mex 10. März 2014 Magento Solutions

The following code returns all products from within a certain category in a collection.

// category id = 5
// addAttributeToSelect is optional
$products = Mage::getModel('catalog/category')->load(5)->getProductCollection()->addAttributeToSelect('*');

// category id = 5

// addAttributeToSelect is optional

$products = Mage::getModel('catalog/category')->load(5)->getProductCollection()->addAttributeToSelect('*');

View solution

Getting orders with items that have a certain attribute set (Magento 1)

Mex 3. März 2014 Magento Solutions

The following MySQL query returns all Magento orders that have at least one item with attribute set id 9.

/* 9 = attribute set Id */
select
	increment_id,
	created_at,
	entity_id 
from
	sales_flat_order 
where
	entity_id not in (
		SELECT
			o.entity_id      
		FROM
			sales_flat_order o      
		LEFT JOIN
			sales_flat_order_item i        
				ON o.entity_id = i.order_id      
		LEFT JOIN
			catalog_product_entity p        
				ON i.product_id = p.entity_id      
		WHERE
			p.attribute_set_id = 9
	)

/* 9 = attribute set Id */

select

increment_id,

created_at,

entity_id

from

sales_flat_order

where

entity_id not in (

SELECT

o.entity_id

FROM

sales_flat_order o

LEFT JOIN

sales_flat_order_item i

ON o.entity_id = i.order_id

LEFT JOIN

catalog_product_entity p

ON i.product_id = p.entity_id

WHERE

p.attribute_set_id = 9

)

View solution

Deleting all items from the compare list in the database (Magento 1)

Mex 26. Februar 2014 Magento Solutions

The following MySQL query deletes all rows from the Magento compare list table.

delete from catalog_compare_item;

1	delete from catalog_compare_item;

View solution