Kdjykuj

I want to get a list of products from only pending orders!
i have this is code but works only for register customers i need to show product for all orders even for guests and multi store.

<?php

require_once 'app/Mage.php';

Mage::app();

//Get All Users/Customers

$users = mage::getModel('customer/customer')->getCollection()

   ->addAttributeToSelect('*');



foreach ($users as $user){

$customer_id = $user['entity_id'];



//Get the  all orders by customer id

$order_collection = Mage::getResourceModel('sales/order_collection')

    ->addFieldToSelect('*')

    ->addFieldToFilter('customer_id',$customer_id)

    ->addFieldToFilter('status', array('in' => array('pending')))

    ->setOrder('created_at', 'desc'); 



    foreach($order_collection as $orders) {

        echo $increment_id = $orders['increment_id']."</br>";

        $order_id = $orders['entity_id'];



        //Get all items for the order id

        $order = Mage::getModel('sales/order')->load($order_id);



        $items = $order->getAllItems();



        foreach($items as $i) {



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

        }



        echo  "</br>";

    } 



}

?>

try below code. Guest customers don't have an ID. So it's better to remove customer condition.

<?php

require_once 'app/Mage.php';

Mage::app();

//Get All Users/Customers

//$users = mage::getModel('customer/customer')->getCollection()->addAttributeToSelect('*');



//foreach ($users as $user){

//$customer_id = $user['entity_id'];



//Get the  all orders by customer id

$order_collection = Mage::getResourceModel('sales/order_collection')

    ->addFieldToSelect('*')

    //->addFieldToFilter('customer_id',$customer_id)

    ->addFieldToFilter('status', array('in' => array('pending')))

    ->setOrder('created_at', 'desc'); 



    foreach($order_collection as $orders) {

        echo $increment_id = $orders['increment_id']."</br>";

        $order_id = $orders['entity_id'];



        //Get all items for the order id

        $order = Mage::getModel('sales/order')->load($order_id);



        $items = $order->getAllItems();



        foreach($items as $i) {



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

        }



        echo  "</br>";

    } 



//}

?>

i need to add custom attribute text value to table how do i get the value ?

    <?php

require_once 'app/Mage.php';

Mage::app();



//Get All Users/Customers

  //  $users = mage::getModel('customer/customer')->getCollection()

 //     ->addAttributeToSelect('*');







//Get the  all orders by customer id

$order_collection = Mage::getResourceModel('sales/order_collection')

    ->addFieldToSelect('*')

   // ->addFieldToFilter('customer_id',$customer_id)

    ->addFieldToFilter('status', array('in' => array('pending')))

    ->setOrder('created_at', 'desc'); 

echo '<table><tr><th>Comanda</th><th>Produs</th><th>qty</th><th>SKU</th></tr>';

    foreach($order_collection as $orders) {

       // echo $increment_id = $orders['increment_id']."</br>";

        $order_id = $orders['entity_id'];



        //Get all items for the order id

        $order = Mage::getModel('sales/order')->load($order_id);



        $items = $order->getAllItems();





        foreach($items as $i) {



              echo '<tr>

              <td>'.$orders['increment_id'].'</td>

              <td>'.$i->getName().'</td>

              <td>'.$i->getQtyOrdered().'</td>

              <td>'.$i->getSku().'</td>

              <td>'.$i->getCod().'</td><tr>';

        } 

        } 

        echo '</tr></table>';

?>