how to fetch order number, payment method and customer name according to invoice number in admin panel grid? The Next CEO of Stack OverflowHow to remove invoice, shipment and creditmemo from Admin grid in magento1.9.0.1 programmaticallyAuto Invoice Check/Money Order Payment methodHow to get paid invoice collection filter by payment methodGrandTotal(excl. tax) and Payment Method in Admin >> Sales >> Invoice gridHow to obtain customer attribute in sales order grid?Removing columns and adding columns in Invoice Admin Grid pageCapture payment from invoice create and view from adminChange Order Number and Invoice NumberMagento 2.2: Order, Invoice, and Shipment do not display in admin gridPayment Method Sales/Order grid - Magento 1.9

How to write the block matrix in LaTex?

When Does an Atlas Uniquely Define a Manifold?

What can we do to stop prior company from asking us questions?

Why is there a PLL in CPU?

What's the point of interval inversion?

Is a stroke of luck acceptable after a series of unfavorable events?

What is the purpose of the Evocation wizard's Potent Cantrip feature?

Why does standard notation not preserve intervals (visually)

Can I equip Skullclamp on a creature I am sacrificing?

Rotate a column

Horror movie/show or scene where a horse creature opens its mouth really wide and devours a man in a stables

How to use tikz in fbox?

Term for the "extreme-extension" version of a straw man fallacy?

Implement the Thanos sorting algorithm

Is it okay to store user locations?

How to write papers efficiently when English isn't my first language?

Is HostGator storing my password in plaintext?

Why does C# sound extremely flat when saxophone is tuned to G?

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

How should I support this large drywall patch?

How can I get through very long and very dry, but also very useful technical documents when learning a new tool?

Was a professor correct to chastise me for writing "Prof. X" rather than "Professor X"?

India just shot down a satellite from the ground. At what altitude range is the resulting debris field?

How did people program for Consoles with multiple CPUs?



how to fetch order number, payment method and customer name according to invoice number in admin panel grid?



The Next CEO of Stack OverflowHow to remove invoice, shipment and creditmemo from Admin grid in magento1.9.0.1 programmaticallyAuto Invoice Check/Money Order Payment methodHow to get paid invoice collection filter by payment methodGrandTotal(excl. tax) and Payment Method in Admin >> Sales >> Invoice gridHow to obtain customer attribute in sales order grid?Removing columns and adding columns in Invoice Admin Grid pageCapture payment from invoice create and view from adminChange Order Number and Invoice NumberMagento 2.2: Order, Invoice, and Shipment do not display in admin gridPayment Method Sales/Order grid - Magento 1.9










0















I`m fetching invoice collection using Mage::getModel('sales/order_invoice')->getCollection(); but I also want Order number, payment method and customer name according to the invoice number. How to fetch that and display in grid?










share|improve this question




























    0















    I`m fetching invoice collection using Mage::getModel('sales/order_invoice')->getCollection(); but I also want Order number, payment method and customer name according to the invoice number. How to fetch that and display in grid?










    share|improve this question


























      0












      0








      0








      I`m fetching invoice collection using Mage::getModel('sales/order_invoice')->getCollection(); but I also want Order number, payment method and customer name according to the invoice number. How to fetch that and display in grid?










      share|improve this question
















      I`m fetching invoice collection using Mage::getModel('sales/order_invoice')->getCollection(); but I also want Order number, payment method and customer name according to the invoice number. How to fetch that and display in grid?







      magento-1.9 sales-order invoice






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 31 mins ago









      Teja Bhagavan Kollepara

      3,01241949




      3,01241949










      asked Jun 26 '18 at 22:14









      Darshan JethwaDarshan Jethwa

      166




      166




















          1 Answer
          1






          active

          oldest

          votes


















          0














          Please find the below answer to get order number,order information,payment method and customer name based on invoice id --



          <?php
          require_once('./app/Mage.php');
          Mage::app();

          $invoiceid =15;

          /* get invoice collection */
          $invoicecollection = Mage::getModel("sales/order_invoice")->getCollection()
          ->addFieldToFilter('entity_id',$invoiceid)
          ->getData();

          /* get order number and collection with customer name */
          $orderId = $invoicecollection[0]['order_id'];
          $order = Mage::getModel('sales/order')->load($orderId);

          //echo "<pre>"; print_r($order->getData());
          echo $order->getCustomerFirstname();

          /* get payment information and card type */
          $payment = $order->getPayment();
          //echo "<pre>"; print_r($payment->getData());
          echo $payment['cc_type'];

          //Get Payment Info
          echo $payment->getMethodInstance()->getCode();
          echo $payment->getMethodInstance()->getTitle();

          ?>





          share|improve this answer























          • This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

            – Darshan Jethwa
            Jun 26 '18 at 23:41











          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%2f231457%2fhow-to-fetch-order-number-payment-method-and-customer-name-according-to-invoice%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          Please find the below answer to get order number,order information,payment method and customer name based on invoice id --



          <?php
          require_once('./app/Mage.php');
          Mage::app();

          $invoiceid =15;

          /* get invoice collection */
          $invoicecollection = Mage::getModel("sales/order_invoice")->getCollection()
          ->addFieldToFilter('entity_id',$invoiceid)
          ->getData();

          /* get order number and collection with customer name */
          $orderId = $invoicecollection[0]['order_id'];
          $order = Mage::getModel('sales/order')->load($orderId);

          //echo "<pre>"; print_r($order->getData());
          echo $order->getCustomerFirstname();

          /* get payment information and card type */
          $payment = $order->getPayment();
          //echo "<pre>"; print_r($payment->getData());
          echo $payment['cc_type'];

          //Get Payment Info
          echo $payment->getMethodInstance()->getCode();
          echo $payment->getMethodInstance()->getTitle();

          ?>





          share|improve this answer























          • This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

            – Darshan Jethwa
            Jun 26 '18 at 23:41















          0














          Please find the below answer to get order number,order information,payment method and customer name based on invoice id --



          <?php
          require_once('./app/Mage.php');
          Mage::app();

          $invoiceid =15;

          /* get invoice collection */
          $invoicecollection = Mage::getModel("sales/order_invoice")->getCollection()
          ->addFieldToFilter('entity_id',$invoiceid)
          ->getData();

          /* get order number and collection with customer name */
          $orderId = $invoicecollection[0]['order_id'];
          $order = Mage::getModel('sales/order')->load($orderId);

          //echo "<pre>"; print_r($order->getData());
          echo $order->getCustomerFirstname();

          /* get payment information and card type */
          $payment = $order->getPayment();
          //echo "<pre>"; print_r($payment->getData());
          echo $payment['cc_type'];

          //Get Payment Info
          echo $payment->getMethodInstance()->getCode();
          echo $payment->getMethodInstance()->getTitle();

          ?>





          share|improve this answer























          • This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

            – Darshan Jethwa
            Jun 26 '18 at 23:41













          0












          0








          0







          Please find the below answer to get order number,order information,payment method and customer name based on invoice id --



          <?php
          require_once('./app/Mage.php');
          Mage::app();

          $invoiceid =15;

          /* get invoice collection */
          $invoicecollection = Mage::getModel("sales/order_invoice")->getCollection()
          ->addFieldToFilter('entity_id',$invoiceid)
          ->getData();

          /* get order number and collection with customer name */
          $orderId = $invoicecollection[0]['order_id'];
          $order = Mage::getModel('sales/order')->load($orderId);

          //echo "<pre>"; print_r($order->getData());
          echo $order->getCustomerFirstname();

          /* get payment information and card type */
          $payment = $order->getPayment();
          //echo "<pre>"; print_r($payment->getData());
          echo $payment['cc_type'];

          //Get Payment Info
          echo $payment->getMethodInstance()->getCode();
          echo $payment->getMethodInstance()->getTitle();

          ?>





          share|improve this answer













          Please find the below answer to get order number,order information,payment method and customer name based on invoice id --



          <?php
          require_once('./app/Mage.php');
          Mage::app();

          $invoiceid =15;

          /* get invoice collection */
          $invoicecollection = Mage::getModel("sales/order_invoice")->getCollection()
          ->addFieldToFilter('entity_id',$invoiceid)
          ->getData();

          /* get order number and collection with customer name */
          $orderId = $invoicecollection[0]['order_id'];
          $order = Mage::getModel('sales/order')->load($orderId);

          //echo "<pre>"; print_r($order->getData());
          echo $order->getCustomerFirstname();

          /* get payment information and card type */
          $payment = $order->getPayment();
          //echo "<pre>"; print_r($payment->getData());
          echo $payment['cc_type'];

          //Get Payment Info
          echo $payment->getMethodInstance()->getCode();
          echo $payment->getMethodInstance()->getTitle();

          ?>






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Jun 26 '18 at 23:22









          ramesh dramesh d

          162




          162












          • This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

            – Darshan Jethwa
            Jun 26 '18 at 23:41

















          • This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

            – Darshan Jethwa
            Jun 26 '18 at 23:41
















          This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

          – Darshan Jethwa
          Jun 26 '18 at 23:41





          This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

          – Darshan Jethwa
          Jun 26 '18 at 23:41

















          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%2f231457%2fhow-to-fetch-order-number-payment-method-and-customer-name-according-to-invoice%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

          Magento 2 duplicate PHPSESSID cookie when using session_start() in custom php scriptMagento 2: User cant logged in into to account page, no error showing!Magento duplicate on subdomainGrabbing storeview from cookie (after using language selector)How do I run php custom script on magento2Magento 2: Include PHP script in headerSession lock after using Cm_RedisSessionscript php to update stockMagento set cookie popupMagento 2 session id cookie - where to find it?How to import Configurable product from csv with custom attributes using php scriptMagento 2 run custom PHP script

          Can not update quote_id field of “quote_item” table magento 2Magento 2.1 - We can't remove the item. (Shopping Cart doesnt allow us to remove items before becomes empty)Add value for custom quote item attribute using REST apiREST API endpoint v1/carts/cartId/items always returns error messageCorrect way to save entries to databaseHow to remove all associated quote objects of a customer completelyMagento 2 - Save value from custom input field to quote_itemGet quote_item data using quote id and product id filter in Magento 2How to set additional data to quote_item table from controller in Magento 2?What is the purpose of additional_data column in quote_item table in magento2Set Custom Price to Quote item magento2 from controller

          How to solve knockout JS error in Magento 2 Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?(Magento2) knockout.js:3012 Uncaught ReferenceError: Unable to process bindingUnable to process binding Knockout.js magento 2Cannot read property `scopeLabel` of undefined on Product Detail PageCan't get Customer Data on frontend in Magento 2Magento2 Order Summary - unable to process bindingKO templates are not loading in Magento 2.1 applicationgetting knockout js error magento 2Product grid not load -— Unable to process binding Knockout.js magento 2Product form not loaded in magento2Uncaught ReferenceError: Unable to process binding “if: function()return (isShowLegend()) ” magento 2