Magento 1.9 Get table of products for pending orders The Next CEO of Stack OverflowCreate...

What is "(CFMCC)" on an ILS approach chart?

Why has the US not been more assertive in confronting Russia in recent years?

Would a galaxy be visible from outside, but nearby?

How does the mv command work with external drives?

How did the Bene Gesserit know how to make a Kwisatz Haderach?

If the heap is zero-initialized for security, then why is the stack merely uninitialized?

Sending manuscript to multiple publishers

What benefits would be gained by using human laborers instead of drones in deep sea mining?

I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin

Which kind of appliances can one connect to electric sockets located in an airplane's toilet?

Which tube will fit a -(700 x 25c) wheel?

Why does the UK parliament need a vote on the political declaration?

Are there any unintended negative consequences to allowing PCs to gain multiple levels at once in a short milestone-XP game?

Written every which way

What is the result of assigning to std::vector<T>::begin()?

Is it possible to search for a directory/file combination?

How did people program for Consoles with multiple CPUs?

If Nick Fury and Coulson already knew about aliens (Kree and Skrull) why did they wait until Thor's appearance to start making weapons?

Would this house-rule that treats advantage as a +1 to the roll instead (and disadvantage as -1) and allows them to stack be balanced?

Can I equip Skullclamp on a creature I am sacrificing?

"In the right combination" vs "with the right combination"?

How long to clear the 'suck zone' of a turbofan after start is initiated?

How do I transpose the first and deepest levels of an arbitrarily nested array?

What happens if you roll doubles 3 times then land on "Go to jail?"



Magento 1.9 Get table of products for pending orders



The Next CEO of Stack OverflowCreate invoice and shipment in magento via cron based on store view and order ageGet Sales Order attributes collectionMagento: How to get customer last order by joining customers and orders?M1 CE, paypal exception “PayPal NVP gateway errors”Magento 1.9: How to show instock items first in product listing even after using sortingPDF printing not working for two ordersGet Payment Update for orders with Pending Payment Review statusMagento 1.9 : sales_flat_order and sales_flat_order_grid tables are not updatingMagento - Add customer attribute to order gridExport Category name in xml feed Magento 1.9.2












0















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

}
?>









share|improve this question





























    0















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

    }
    ?>









    share|improve this question



























      0












      0








      0








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

      }
      ?>









      share|improve this question
















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

      }
      ?>






      magento-1.9






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 1 hour ago









      Teja Bhagavan Kollepara

      3,01241949




      3,01241949










      asked Oct 3 '18 at 19:02









      GSM BoutiqueGSM Boutique

      284




      284






















          2 Answers
          2






          active

          oldest

          votes


















          0














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

          //}
          ?>





          share|improve this answer
























          • Hello the code is working tank you

            – GSM Boutique
            Oct 3 '18 at 21:09











          • i need to add custom attribute to table

            – GSM Boutique
            Oct 3 '18 at 21:10











          • Please post another question for it. and close this one

            – Abhishek Panchal
            Oct 3 '18 at 21:11



















          0














          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>';
          ?>





          share|improve this answer
























            Your Answer








            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "479"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: false,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: null,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f244957%2fmagento-1-9-get-table-of-products-for-pending-orders%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














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

            //}
            ?>





            share|improve this answer
























            • Hello the code is working tank you

              – GSM Boutique
              Oct 3 '18 at 21:09











            • i need to add custom attribute to table

              – GSM Boutique
              Oct 3 '18 at 21:10











            • Please post another question for it. and close this one

              – Abhishek Panchal
              Oct 3 '18 at 21:11
















            0














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

            //}
            ?>





            share|improve this answer
























            • Hello the code is working tank you

              – GSM Boutique
              Oct 3 '18 at 21:09











            • i need to add custom attribute to table

              – GSM Boutique
              Oct 3 '18 at 21:10











            • Please post another question for it. and close this one

              – Abhishek Panchal
              Oct 3 '18 at 21:11














            0












            0








            0







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

            //}
            ?>





            share|improve this answer













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

            //}
            ?>






            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Oct 3 '18 at 19:08









            Abhishek PanchalAbhishek Panchal

            3,5913929




            3,5913929













            • Hello the code is working tank you

              – GSM Boutique
              Oct 3 '18 at 21:09











            • i need to add custom attribute to table

              – GSM Boutique
              Oct 3 '18 at 21:10











            • Please post another question for it. and close this one

              – Abhishek Panchal
              Oct 3 '18 at 21:11



















            • Hello the code is working tank you

              – GSM Boutique
              Oct 3 '18 at 21:09











            • i need to add custom attribute to table

              – GSM Boutique
              Oct 3 '18 at 21:10











            • Please post another question for it. and close this one

              – Abhishek Panchal
              Oct 3 '18 at 21:11

















            Hello the code is working tank you

            – GSM Boutique
            Oct 3 '18 at 21:09





            Hello the code is working tank you

            – GSM Boutique
            Oct 3 '18 at 21:09













            i need to add custom attribute to table

            – GSM Boutique
            Oct 3 '18 at 21:10





            i need to add custom attribute to table

            – GSM Boutique
            Oct 3 '18 at 21:10













            Please post another question for it. and close this one

            – Abhishek Panchal
            Oct 3 '18 at 21:11





            Please post another question for it. and close this one

            – Abhishek Panchal
            Oct 3 '18 at 21:11













            0














            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>';
            ?>





            share|improve this answer




























              0














              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>';
              ?>





              share|improve this answer


























                0












                0








                0







                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>';
                ?>





                share|improve this answer













                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>';
                ?>






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Oct 3 '18 at 21:12









                GSM BoutiqueGSM Boutique

                284




                284






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Magento Stack Exchange!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f244957%2fmagento-1-9-get-table-of-products-for-pending-orders%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    “%fieldName is a required field.”, in Magento2 REST API Call for GET Method Type The Next...

                    How to change City field to a dropdown in Checkout step Magento 2Magento 2 : How to change UI field(s)...

                    變成蝙蝠會怎樣? 參考資料 外部連結 导航菜单Thomas Nagel, "What is it like to be a...