<?php

require_once('app/Mage.php');

umask(0);

Mage::app('admin');

set_time_limit(0);

$productCollection = Mage::getModel('catalog/product')

     ->getCollection()

     ->addAttributeToSelect('*')

     ->joinField('qty',

                 'cataloginventory/stock_item',

                 'qty',

                 'product_id=entity_id',

                 '{{table}}.is_in_stock=1',

                 'left')

     ->addAttributeToFilter('qty', array("eq" => 0));

echo "<h2>Simple Products with 0 quantity and In Stock</h2>";

foreach($productCollection as $product) { //print_r($product->getData());exit;

    if($product->getTypeId() == 'simple')

        echo $product->getName() . " | " . $product->getSku() . "<br>";

}

echo 'Done';

?>

<?php

require_once('app/Mage.php');

umask(0);

Mage::app('admin');

set_time_limit(0);

$i=0;

$sql = "select

    type_id,sku

 from catalog_product_entity a

 left join catalog_category_product cp on cp.`product_id` = a.entity_id

 left join catalog_product_relation cpr on cpr.child_id = a.entity_id

 where

       cp.product_id is null

   and cpr.parent_id is null

   and a.type_id = 'configurable'";

$connection = Mage::getSingleton('core/resource')->getConnection('core_read');

//echo count($connection->fetchAll($sql));exit;

foreach ($connection->fetchAll($sql) as $arr_row) {

        $pid = $arr_row['sku'];

        $product = Mage::getModel('catalog/product')->loadByAttribute('sku',$pid);

        if($product->getTypeId()!='configurable') continue;

        $i++;

        echo $i .") ". $product->getName() . " - " . $product->getSku() . "<br>";

}

?>

<?php $cards = unserialize($_order->getGiftCards());

        if($cards!='' && count($cards)>0) { ?>

<div class="box-left">

    <div class="entry-edit">

        <div class="entry-edit-head">

            <h4 class="icon-head head-account"><?php echo Mage::helper('sales')->__('Gift Cards') ?></h4>

        </div>

        <div class="fieldset">

            <div class="hor-scroll">

                <table cellspacing="0" class="form-list">

                <?php foreach ($cards as $card) { ?>

                <tr>

                    <td class="label"><label><?php echo Mage::helper('sales')->__('Giftcard Code') ?></label></td>

                    <td class="value">

                        <div style="font-weight:bold"><?php echo $card['c'];?></div>

                    </td>

                </tr>

                <tr>

                    <td class="label"><label><?php echo Mage::helper('sales')->__('Giftcard Amount') ?></label></td>

                    <td class="value">

                        <div style="font-weight:bold"><?php echo $card['a'];?></div>

                    </td>

                </tr>

                <?php }?>

                </table>

            </div>

        </div>

    </div>

</div>

<?php }?>

$model = Mage::getResourceModel('catalog/setup','catalog_setup');

$data=array(

'type'=>'int',

'input'=>'boolean', //for Yes/No dropdown

'sort_order'=>50,

'label'=>'CUSTOM ATTRIBUTE CODE LABEL',

'global'=>Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,

'required'=>'0',

'comparable'=>'0',

'searchable'=>'0',

'is_configurable'=>'1',

'user_defined'=>'1',

'visible_on_front' => 0, //want to show on frontend?

'visible_in_advanced_search' => 0,

'is_html_allowed_on_front' => 0,

'required'=> 0,

'unique'=>false,

'apply_to' => 'configurable', //simple,configurable,bundled,grouped,virtual,downloadable

'is_configurable' => false

);

$model->addAttribute('catalog_product','CUSTOM_ATTRIBUTE_CODE',$data);

$model->addAttributeToSet(

    'catalog_product', 'Default', 'General', 'CUSTOM_ATTRIBUTE_CODE'

); //Default = attribute set, General = attribute group

$model = Mage::getResourceModel('catalog/setup','catalog_setup');

$model->removeAttribute('catalog_product','CUSTOM_ATTRIBUTE_CODE');