Magento Product Collection Query

Magento product collection query

For developers, print the product collection query.

$statusEnabled = Mage_Catalog_Model_Product_Status::STATUS_ENABLED;

$collection = Mage::getModel('catalog/product')
                 ->getCollection()
                 ->addAttributeToFilter('status', 
                  $statusEnabled);
/**
 *
 * Print query
 *
 */
echo $collection->getSelect();
/**
 *or
 */
echo $collection->getSelect()->__toString();
/**
 *
 *print collection query 
 */
$Collection->printLogQuery(true);

You can then view the result query.
For developer, enable the system log settings by
System -> Configuration -> Developer -> Log Settings
see the generated log file in [magento_root_folder]/var/log/ folder

Magento Add the Default Permission for Folders

Folder permissions

/media - accessing the product images
/var - generating the cache, report files

Downloader, var and media folders are need be writable
[magento_root_folder]/var - 777 [magento_root_folder]/media - 777 [magento_root_folder]/downloader - 777

Once completed instllation and development process.
Reset back downloader folder to 755 so that this folders are non-writeable in production.

For files keep the permission as 644.

Use local.xml in theme layout for Updating Handles

Use local xml in layout file to update the handles

Step 1

Create local.xml in your custom theme as app/design/frontend/[package]/[theme]/layout/

Step 2

Create the layout code in local.xml and update the layout handles that you want in custom theme.

Within the layout tag, update the base xml handles. For example, want to remove the newsletter globally in left column for your current theme.

Magento Product Collection Filter by Dropdown Option Value

Filter product collection by option value.

Filter by option value

The product collection filter by attribute option value.

$statusEnable = Mage_Catalog_Model_Product_Status::STATUS_ENABLED;
$collection  = Mage::getModel('catalog/product')
                    ->getCollection()
                    ->addAttributeToFilter('status',
                        array('eq' => $statusEnable)
                      )                    
                    ->addAttributeToSelect('*')
                    ->addAttributeToFilter('[attibute_name]', 
                        array('eq' => '[value]')
                      );
    

Filter by dropdown option value

The product collection filter by dropdown option value.

$sAttributeName = '[custom_attribute_identifier_id]'; //for example: color, size

/*
 * Get custom attribute option values
 *
 */
$optionValues = Mage::getResourceModel('catalog/product')
                ->getAttribute($sAttributeName)
                ->getSource()
                ->getAllOptions(false);

/*
 * Select the option id for the choosen dropdown option value
 *
 */
foreach($optionValues as $options) {

    if($options['label'] == '[choosen_value]') {
        $optionIds[] = $options['value'];         
    }
}

/* print_r($optionIds); */

/*
 * Filter product collection by dropdown option id
 *
 */
$collection  = Mage::getModel('catalog/product')
                    ->getCollection()
                    ->addAttributeToFilter('status',
                        array('eq' => Mage_Catalog_Model_Product_Status::STATUS_ENABLED)
                      )                    
                    ->addAttributeToSelect('*')
                    ->addAttributeToFilter($sAttributeName, 
                        array('in' => $optionIds)
                      );

[choosen_value] In frontend, selected dropdown value to match option values to get option id.

Magento Product Collection by Attribute Filter

Add attribute to filter in product collection

The below part code shows the product collection filter by attribute.

For example
You want to filter the product collection by status enabled product,
refer the code below this do that

$collection  = Mage::getModel ('catalog/product')
                    ->getCollection()
                    ->addAttributeToFilter('status',
                        array('eq' => Mage_Catalog_Model_Product_Status::STATUS_ENABLED)
                      );

print_r($collection);

Magento Get Options Values for Dropdown

Get dropdown option values

The dropdown value that you want to get an option values.
$sAttributeName

$sAttributeName = 'color';
$optionValues = Mage::getResourceModel('catalog/product')
                ->getAttribute($sAttributeName)
                ->getSource()
                ->getAllOptions(false);

You dont want the empty value in the option values then set the false value for first argument in below function call
getAllOptions(false)

Remove the Block in xml file

Remove the block in layout xml file

To remove the block from specific layout. You will copy the base layout file from the base folder to current theme layout folder.
In that, you will remove the block name using

And other way for removing the block by creating the local.xml in your current theme layout folder and add the block remove code there.
For example

In some cases you want to remove the child block, refer the code below to remove the child block

Update Multiple Products Atrributes values using UpdateAction Function

Update multiple product id attribute values

To update multiple product attribute values using simple code.

Mage::getSingleton('catalog/product_action')
   ->updateAttributes(
    $productIds, 
    array('[attribute_id]' => [attribute_value])
     );

If you want to update the attribute values for muliple products, then the above code will do the magic for that.

for ex:
Want to update the meta title for multiple products, refer the code below.

/*
$collection refers to the set of product collections
*/
$productIds = $collection->getAllIds();
/*
*print_r($productIds);
*/
Mage::getSingleton('catalog/product_action')
   ->updateAttributes(
    $productIds, 
    array('meta_title' => 'title added')
     );

How to add Additional Data in Payment Additional Data Field

Set additional data/information in payment instance

If you want to add the additional information in payment instance, then

Step1
In the Model file of your created payment

Mage_Payment_Model_Method_[custom_name]

add the below code in

assignData()

function

$this->getInfoInstance()->setAdditionalData([value to set]);

for example

$data['pay'] = 'xxxx';
$this->getInfoInstance()->setAdditionalData(serialize($data));

Step2
In Block folder, create payment info file that extends info block, add the below code in info phtml file

protected $_pay;

public function getPay()
{
     if (is_null($this->_pay)) {
        $this->_convertAdditionalData();
     }
     return $this->_pay;
}

protected function _convertAdditionalData()
{
    $this->_pay= '';

    $data = @unserialize($this->getInfo()->getAdditionalData());        
    if (is_array($data )) {
         $this->_emi = isset($data ['pay']) ? (string) $data ['pay'] : '';
    }
    return $this;
}

Step3
In the payment info phtml file, add the below code to show the additional data added.

<?php  
echo ( if($this->getPay()) ? $this->getPay() : '');  
?>

Now check the

additional_data field

in

sales_flat_order_payment

table for that order, you will find the data that added in table.

Magento how to Call cms Static Block Created in Admin

Create CMS static block

Create static block in Magento admin area. Add new block in Admin -> CMS ->Static Blocks and create new. Note down the Identifier of that block going to create.

If want to call the static block in phtml file, refer the below code to add in that

$this->getLayout()->createBlock('cms/block')->setBlockId('[identifier]')->toHtml();

[identifier] denotes the name of the static block.

You can add this code in which the block to appear.