<?php

require_once('app/Mage.php');

umask(0);

Mage::app('admin');

set_time_limit(0);

$category = Mage::getModel('catalog/category');

$tree = $category->getTreeModel();

$tree->load();

$ids = $tree->getCollection()->getAllIds();

if ($ids)

{

     foreach ($ids as $id)

  {

     $cat = Mage::getModel('catalog/category');

     $cat->load($id);

     if($cat->getLevel()==3 && $cat->getIsActive()==1)

     {

        $category1 = Mage::getModel('catalog/category')->load($cat->getId());

        $products = Mage::getResourceModel('catalog/product_collection')

                                ->addAttributeToSelect('name')

                             ->addCategoryFilter($category1);

        echo "<b>".$cat->getName()."</b><br>";

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

                echo " &nbsp; &nbsp; &nbsp; " . $product->getName() . " - ". $product->getSku() . "<br/>";

        }

     }

  }

}

?>

<?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=0',

                 'left')

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

echo "<h2>Simple Products with >0 quantity and Out of 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);

$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>";

}

?>

$category = Mage::getModel('catalog/category')->load($categoryId); 

$products = Mage::getResourceModel('reports/product_collection') 

    ->addOrderedQty() //total number of quantities ordered

    ->addAttributeToSelect('*') //get all attributes

    ->setOrder('ordered_qty', 'desc') //most ordered quantity products first

    ->addCategoryFilter($category);