Get Configurable Product Price from Simple Product in Magento OrderConfigurable product tax class from simple productFilter simple products by priceMagento Configurable Product Price Overriding Simple Product PriceIs there any way to determine Simple products that are not associated with a configurable?Ways of keeping Configurable product pricing consistent with Simple product pricingPlacing an order with configurable product weird issuemagento “erasing” simple products from configurable associationConfigurable product creates simple product as out of stock even if quantity givenhow to display configurable product price of default selected in product list instead of Zero?Magento use associated simple product image for configurable product

What does "Four-F." mean?

Is there a term for accumulated dirt on the outside of your hands and feet?

How to define limit operations in general topological spaces? Are nets able to do this?

Could Sinn Fein swing any Brexit vote in Parliament?

How are passwords stolen from companies if they only store hashes?

How to terminate ping <dest> &

Constant Current LED Circuit

What is the term when voters “dishonestly” choose something that they do not want to choose?

Why is indicated airspeed rather than ground speed used during the takeoff roll?

Why didn't Héctor fade away after this character died in the movie Coco?

I got the following comment from a reputed math journal. What does it mean?

Probably overheated black color SMD pads

Print last inputted byte

Existence of a celestial body big enough for early civilization to be thought of as a second moon

Light propagating through a sound wave

Should I use acronyms in dialogues before telling the readers what it stands for in fiction?

How to generate binary array whose elements with values 1 are randomly drawn

Loading the leaflet Map in Lightning Web Component

Why are there no stars visible in cislunar space?

How does 取材で訪れた integrate into this sentence?

What is the significance behind "40 days" that often appears in the Bible?

How can an organ that provides biological immortality be unable to regenerate?

Relation between independence and correlation of uniform random variables

Hausdorff dimension of the boundary of fibres of Lipschitz maps



Get Configurable Product Price from Simple Product in Magento Order


Configurable product tax class from simple productFilter simple products by priceMagento Configurable Product Price Overriding Simple Product PriceIs there any way to determine Simple products that are not associated with a configurable?Ways of keeping Configurable product pricing consistent with Simple product pricingPlacing an order with configurable product weird issuemagento “erasing” simple products from configurable associationConfigurable product creates simple product as out of stock even if quantity givenhow to display configurable product price of default selected in product list instead of Zero?Magento use associated simple product image for configurable product













1















We are writing synchronization of Magento and MAS90 ERP system. We are transferring Orders from Magento to ERP system. We have added observer for order_save_after.



Each of Magento Simple product has UPC code that needed to add item in ERP system.
Simple products are automatically added to Magento Order based on configurable item, but problem is that simple product's real price, quantity, tax amount...are stored in configurable product, but UPC is stored in simple product.
For resolving this problem, we decide to get simple products from Magento Order ( to get right UPC ).



Our question is, how to get RIGHT price, quantity, tax amount of automatically added simple product. ( How in Magento order are linked configurable product and automatically added simple product. )



Here is snippet of Code that is getting products.



 foreach ($order->getAllItems() as $orderItem)
 $tmpMAS90OrderItem = NULL; 
 if($orderItem->getProductType() == 'simple')
 $tmpMAS90OrderItem = $orderItem -> getUpc();
 
 if($tmpMAS90OrderItem != NULL) 
 $setChildValuesArray = array(
 'ItemCode' => $tmpMAS90OrderItem,
 'UnitPrice' => $orderItem -> getPrice(), // THIS IS WRONG PRICE, right price is in configurable item
 'QuantityOrdered' => $orderItem -> getQtyToInvoice() 
 );
 $querySO->setChildFieldValues($setChildValuesArray,$childSequence); //child sequence ( line sequence )
 $childSequence++;
 $linesTaxAmountSum += $orderItem->getTaxAmount(); // THIS IS WRONG TAX AMOUNT, right amount is in configurable item





configurable-product event-observer simple-product







share|improve this question




























    1















    We are writing synchronization of Magento and MAS90 ERP system. We are transferring Orders from Magento to ERP system. We have added observer for order_save_after.



    Each of Magento Simple product has UPC code that needed to add item in ERP system.
    Simple products are automatically added to Magento Order based on configurable item, but problem is that simple product's real price, quantity, tax amount...are stored in configurable product, but UPC is stored in simple product.
    For resolving this problem, we decide to get simple products from Magento Order ( to get right UPC ).



    Our question is, how to get RIGHT price, quantity, tax amount of automatically added simple product. ( How in Magento order are linked configurable product and automatically added simple product. )



    Here is snippet of Code that is getting products.



     foreach ($order->getAllItems() as $orderItem)
     $tmpMAS90OrderItem = NULL; 
     if($orderItem->getProductType() == 'simple')
     $tmpMAS90OrderItem = $orderItem -> getUpc();
     
     if($tmpMAS90OrderItem != NULL) 
     $setChildValuesArray = array(
     'ItemCode' => $tmpMAS90OrderItem,
     'UnitPrice' => $orderItem -> getPrice(), // THIS IS WRONG PRICE, right price is in configurable item
     'QuantityOrdered' => $orderItem -> getQtyToInvoice() 
     );
     $querySO->setChildFieldValues($setChildValuesArray,$childSequence); //child sequence ( line sequence )
     $childSequence++;
     $linesTaxAmountSum += $orderItem->getTaxAmount(); // THIS IS WRONG TAX AMOUNT, right amount is in configurable item





    configurable-product event-observer simple-product







    share|improve this question


























      1












      1








      1








      We are writing synchronization of Magento and MAS90 ERP system. We are transferring Orders from Magento to ERP system. We have added observer for order_save_after.



      Each of Magento Simple product has UPC code that needed to add item in ERP system.
      Simple products are automatically added to Magento Order based on configurable item, but problem is that simple product's real price, quantity, tax amount...are stored in configurable product, but UPC is stored in simple product.
      For resolving this problem, we decide to get simple products from Magento Order ( to get right UPC ).



      Our question is, how to get RIGHT price, quantity, tax amount of automatically added simple product. ( How in Magento order are linked configurable product and automatically added simple product. )



      Here is snippet of Code that is getting products.



       foreach ($order->getAllItems() as $orderItem)
       $tmpMAS90OrderItem = NULL; 
       if($orderItem->getProductType() == 'simple')
       $tmpMAS90OrderItem = $orderItem -> getUpc();
       
       if($tmpMAS90OrderItem != NULL) 
       $setChildValuesArray = array(
       'ItemCode' => $tmpMAS90OrderItem,
       'UnitPrice' => $orderItem -> getPrice(), // THIS IS WRONG PRICE, right price is in configurable item
       'QuantityOrdered' => $orderItem -> getQtyToInvoice() 
       );
       $querySO->setChildFieldValues($setChildValuesArray,$childSequence); //child sequence ( line sequence )
       $childSequence++;
       $linesTaxAmountSum += $orderItem->getTaxAmount(); // THIS IS WRONG TAX AMOUNT, right amount is in configurable item





      configurable-product event-observer simple-product







      share|improve this question
















      We are writing synchronization of Magento and MAS90 ERP system. We are transferring Orders from Magento to ERP system. We have added observer for order_save_after.



      Each of Magento Simple product has UPC code that needed to add item in ERP system.
      Simple products are automatically added to Magento Order based on configurable item, but problem is that simple product's real price, quantity, tax amount...are stored in configurable product, but UPC is stored in simple product.
      For resolving this problem, we decide to get simple products from Magento Order ( to get right UPC ).



      Our question is, how to get RIGHT price, quantity, tax amount of automatically added simple product. ( How in Magento order are linked configurable product and automatically added simple product. )



      Here is snippet of Code that is getting products.



       foreach ($order->getAllItems() as $orderItem)
       $tmpMAS90OrderItem = NULL; 
       if($orderItem->getProductType() == 'simple')
       $tmpMAS90OrderItem = $orderItem -> getUpc();
       
       if($tmpMAS90OrderItem != NULL) 
       $setChildValuesArray = array(
       'ItemCode' => $tmpMAS90OrderItem,
       'UnitPrice' => $orderItem -> getPrice(), // THIS IS WRONG PRICE, right price is in configurable item
       'QuantityOrdered' => $orderItem -> getQtyToInvoice() 
       );
       $querySO->setChildFieldValues($setChildValuesArray,$childSequence); //child sequence ( line sequence )
       $childSequence++;
       $linesTaxAmountSum += $orderItem->getTaxAmount(); // THIS IS WRONG TAX AMOUNT, right amount is in configurable item





      configurable-product event-observer simple-product




      configurable-product event-observer simple-product






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 39 mins ago









      Teja Bhagavan Kollepara

      3,00641949




      3,00641949










      asked May 7 '15 at 7:27









      Aram KocharyanAram Kocharyan

      1086




      1086




















          1 Answer
          1






          active

          oldest

          votes


















          1














          In this case you need to use call parent item's row().As per magento when a configurable product is ordered,then there are two rows has been saved at sales_flat_order_item.One is configurable product data product_id and order item prices and another is simple products details.So need data fetch data from Configurable products.



          So need to change 



          'UnitPrice'=> $orderItem->getParentItem()?$orderItem->getParentItem()-> getPrice():$orderItem-> getPrice(),


          From



          UnitPrice' => $orderItem -> getPrice(),


          Also To:



          $linesTaxAmountSum += $orderItem->getParentItem()?$orderItem->getParentItem()->getTaxAmount():$orderItem->getTaxAmount();


          From:



          $linesTaxAmountSum += $orderItem->getTaxAmount();





          share|improve this answer

























          • Thank you for answer. It mean that each parent(up) row of simple product is configurable item ? ( In case that we ordered configurable product ) First I need to get product data from configurable item, and put it in next row? ( Is there any way that when a configurable product will be ordered no second row will be added ? )

            – Aram Kocharyan
            May 7 '15 at 7:42











          • may use getAllVisibleItems() instead getAllItems() better idea

            – Amit Bera♦
            May 7 '15 at 7:49










          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%2f66982%2fget-configurable-product-price-from-simple-product-in-magento-order%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









          1














          In this case you need to use call parent item's row().As per magento when a configurable product is ordered,then there are two rows has been saved at sales_flat_order_item.One is configurable product data product_id and order item prices and another is simple products details.So need data fetch data from Configurable products.



          So need to change 



          'UnitPrice'=> $orderItem->getParentItem()?$orderItem->getParentItem()-> getPrice():$orderItem-> getPrice(),


          From



          UnitPrice' => $orderItem -> getPrice(),


          Also To:



          $linesTaxAmountSum += $orderItem->getParentItem()?$orderItem->getParentItem()->getTaxAmount():$orderItem->getTaxAmount();


          From:



          $linesTaxAmountSum += $orderItem->getTaxAmount();





          share|improve this answer

























          • Thank you for answer. It mean that each parent(up) row of simple product is configurable item ? ( In case that we ordered configurable product ) First I need to get product data from configurable item, and put it in next row? ( Is there any way that when a configurable product will be ordered no second row will be added ? )

            – Aram Kocharyan
            May 7 '15 at 7:42











          • may use getAllVisibleItems() instead getAllItems() better idea

            – Amit Bera♦
            May 7 '15 at 7:49















          1














          In this case you need to use call parent item's row().As per magento when a configurable product is ordered,then there are two rows has been saved at sales_flat_order_item.One is configurable product data product_id and order item prices and another is simple products details.So need data fetch data from Configurable products.



          So need to change 



          'UnitPrice'=> $orderItem->getParentItem()?$orderItem->getParentItem()-> getPrice():$orderItem-> getPrice(),


          From



          UnitPrice' => $orderItem -> getPrice(),


          Also To:



          $linesTaxAmountSum += $orderItem->getParentItem()?$orderItem->getParentItem()->getTaxAmount():$orderItem->getTaxAmount();


          From:



          $linesTaxAmountSum += $orderItem->getTaxAmount();





          share|improve this answer

























          • Thank you for answer. It mean that each parent(up) row of simple product is configurable item ? ( In case that we ordered configurable product ) First I need to get product data from configurable item, and put it in next row? ( Is there any way that when a configurable product will be ordered no second row will be added ? )

            – Aram Kocharyan
            May 7 '15 at 7:42











          • may use getAllVisibleItems() instead getAllItems() better idea

            – Amit Bera♦
            May 7 '15 at 7:49













          1












          1








          1







          In this case you need to use call parent item's row().As per magento when a configurable product is ordered,then there are two rows has been saved at sales_flat_order_item.One is configurable product data product_id and order item prices and another is simple products details.So need data fetch data from Configurable products.



          So need to change 



          'UnitPrice'=> $orderItem->getParentItem()?$orderItem->getParentItem()-> getPrice():$orderItem-> getPrice(),


          From



          UnitPrice' => $orderItem -> getPrice(),


          Also To:



          $linesTaxAmountSum += $orderItem->getParentItem()?$orderItem->getParentItem()->getTaxAmount():$orderItem->getTaxAmount();


          From:



          $linesTaxAmountSum += $orderItem->getTaxAmount();





          share|improve this answer















          In this case you need to use call parent item's row().As per magento when a configurable product is ordered,then there are two rows has been saved at sales_flat_order_item.One is configurable product data product_id and order item prices and another is simple products details.So need data fetch data from Configurable products.



          So need to change 



          'UnitPrice'=> $orderItem->getParentItem()?$orderItem->getParentItem()-> getPrice():$orderItem-> getPrice(),


          From



          UnitPrice' => $orderItem -> getPrice(),


          Also To:



          $linesTaxAmountSum += $orderItem->getParentItem()?$orderItem->getParentItem()->getTaxAmount():$orderItem->getTaxAmount();


          From:



          $linesTaxAmountSum += $orderItem->getTaxAmount();






          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited May 7 '15 at 7:44

























          answered May 7 '15 at 7:37









          Amit Bera♦Amit Bera

          59.2k1575176




          59.2k1575176












          • Thank you for answer. It mean that each parent(up) row of simple product is configurable item ? ( In case that we ordered configurable product ) First I need to get product data from configurable item, and put it in next row? ( Is there any way that when a configurable product will be ordered no second row will be added ? )

            – Aram Kocharyan
            May 7 '15 at 7:42











          • may use getAllVisibleItems() instead getAllItems() better idea

            – Amit Bera♦
            May 7 '15 at 7:49

















          • Thank you for answer. It mean that each parent(up) row of simple product is configurable item ? ( In case that we ordered configurable product ) First I need to get product data from configurable item, and put it in next row? ( Is there any way that when a configurable product will be ordered no second row will be added ? )

            – Aram Kocharyan
            May 7 '15 at 7:42











          • may use getAllVisibleItems() instead getAllItems() better idea

            – Amit Bera♦
            May 7 '15 at 7:49
















          Thank you for answer. It mean that each parent(up) row of simple product is configurable item ? ( In case that we ordered configurable product ) First I need to get product data from configurable item, and put it in next row? ( Is there any way that when a configurable product will be ordered no second row will be added ? )

          – Aram Kocharyan
          May 7 '15 at 7:42





          Thank you for answer. It mean that each parent(up) row of simple product is configurable item ? ( In case that we ordered configurable product ) First I need to get product data from configurable item, and put it in next row? ( Is there any way that when a configurable product will be ordered no second row will be added ? )

          – Aram Kocharyan
          May 7 '15 at 7:42













          may use getAllVisibleItems() instead getAllItems() better idea

          – Amit Bera♦
          May 7 '15 at 7:49





          may use getAllVisibleItems() instead getAllItems() better idea

          – Amit Bera♦
          May 7 '15 at 7:49

















          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%2f66982%2fget-configurable-product-price-from-simple-product-in-magento-order%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

          Nidaros erkebispedøme

          Image
          For det lutherske bispedømet, sjå Nidaros bispedøme. Nidaros erkebispedøme var eit katolsk erkebispedøme med sete i Nidaros. Det vart oppretta av kong Olav Kyrre mellom 1070 og 1080 som bispedøme. Bispedømet vart opphøgd til erkebispedøme i 1153. Erkebispedømet vart innstifta av pave Anastasius IV i 1154, og var i funksjon fram til reformasjonen i 1537. Erkebiskopen sitt hovudsete var Erkebispegarden, rett ved domkyrkja Nidarosdomen. Frå 1152 til 1154 var Nicholas Breakspear i Skandinavia som paveleg utsending, og organiserte opprettinga av erkesetet. Innhaldsliste 1 Utbreiing og jurisdiksjon 2 Overhyrdar 2.1 Lydbiskopar 3 Biskopar 3.1 Biskopar 3.2 Erkebiskopar Utbreiing og jurisdiksjon | Kart over den nordiske kyrkjeprovinsen (1153-1387) Erkebispedømet omfatta i tillegg til Noreg øyane i vest i Noregsveldet. Nidaros var eit metropolitanerkebispedøme med fylgjande underliggjande bispedøme suffraganar: Bj...
          Read more

          Birsay

          Image
          Tettstaden Birsay på Orknøyane. Ruinane av jarleplasset om lag midt i biletet. (Fotografi frå 2012) Utsikt mot Birsay og Brough of Brisay (fotografi frå 2009) Birsay er ein tettstad i eit sokn (parish) med same namn, nordvest på øya Mainland [Note 1] på Orknøyane, om lag 31 km frå Kirkwall. Staden er omtala fleire stader i Orknøyingasoga [1] , der han er kalla «Byrgesherad» (norrønt: Birgisherað ). Namnet skriv seg truleg frå elvenamnet Birgisá [2] . Innhaldsliste 1 Den gamle hovudstaden 2 Bispesetet 3 Jarlepalasset 4 Kjelder og utfyllande opplysningar 4.1 Notar 4.2 Fotnotar 4.3 Bakgrunnsstoff Den gamle hovudstaden | Hovudartikkelen for dette emnet er Torfinn Sigurdsson . Soknet er i dag i hovudsak ei jordbrukskommune men er mest kjend for dei mange kulturminna i området. Tettstaden Birsay blir gjerne omtala som «den gamle hovudstaden på Orknøyane» [3] , og ein viser d...
          Read more

          Was Woodrow Wilson really a Liberal?Was World War I a war of liberals against authoritarians?Founding Fathers...

          Image
          Do VLANs within a subnet need to have their own subnet for router on a stick? What are the differences between the usage of 'it' and 'they'? Dragon forelimb placement How do we improve the relationship with a client software team that performs poorly and is becoming less collaborative? What typically incentivizes a professor to change jobs to a lower ranking university? How to write a macro that is braces sensitive? Modeling an IPv4 Address Writing rule stating superpower from different root cause is bad writing Can I ask the recruiters in my resume to put the reason why I am rejected? Approximately how much travel t...
          Read more