Databases
StackOverflow2013
Postsdbo
POMagento: how to get the price of a product with catalog rules applied
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMagento: how to get the price of a product with catalog rules applied
    primarykey
    data
    text
    <p>I'm developing a script (external to Magento, not a module) which aims to output a text list of all available products, their prices and some other attributes. However, catalog price rules don't seem to be applied to product prices. If I use any of the following:</p> <pre><code>$_product-&gt;getPrice() $_product-&gt;getFinalPrice() </code></pre> <p>I get the normal price (without rules being applied).</p> <p>If I use:</p> <pre><code>$_product-&gt;getSpecialPrice() </code></pre> <p>I get <strong>null</strong> unless the product actually has a special price inserted in the product itself (i.e. if special price is not related with catalog rules).</p> <p>I also tried </p> <pre><code>Mage::getModel('catalogrule/rule')-&gt;calcProductPriceRule($product,$product-&gt;getPrice()) </code></pre> <p>as suggested in the answer given by Fabian Blechschmidt, but interestingly it returns the normal price only if the product is affected by any catalog rule, returning <strong>null</strong> otherwise.</p> <p>There was a similar question in <a href="https://stackoverflow.com/questions/9684964/how-can-get-final-price-with-applied-price-rule-in-magento">StackOverflow</a> and <a href="http://www.magentocommerce.com/boards/viewthread/210839/#t398210" rel="nofollow noreferrer">Magento Forums</a> some time ago, but the provided answer (which is to insert the code bellow) doesn't work for me (returned prices remain the same).</p> <pre><code>Mage::app()-&gt;loadAreaPart(Mage_Core_Model_App_Area::AREA_FRONTEND,Mage_Core_Model_App_Area::PART_EVENTS); </code></pre> <p>Does anybody have an idea of how to achieve this?</p> <p>I'm using Magento 1.6.2.0. Thanks in advance.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USfaken
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMagento: how to get the price of a product with catalog rules applied
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POMagento: how to get the price of a product with catalog rules applied
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POMagento: how to get the price of a product with catalog rules applied
      1. USyoupas
      1. VTFavorite
    1. COPerhaps there is something else going on involving your data or indexing. Does the discounted price display as you expect in the default theme with all custom modules disabled?
      singulars
      1. POMagento: how to get the price of a product with catalog rules applied
      1. USbenmarks
    2. COYes, the discounted prices display Ok in the frontend. The problem was that this was not a Magento module, but an "external" script. It seems Magento loads additional stuff which is required for everything to work properly. In other words, everything in Magento must really be a module...
      singulars
      1. POMagento: how to get the price of a product with catalog rules applied
      1. USfaken
    3. CO*"everything in Magento must really be a module"* - Not really. There are however many modules which interact in many ways when the app is executing. I would check that `Mage_CatalogRule_Model_Observer` is instantiating. Perhaps you should paste the relevant parts of the remote script (`Mage::app()` instantiation, `loadAreaPart()` call, product load, etc.)
      singulars
      1. POMagento: how to get the price of a product with catalog rules applied
      1. USbenmarks
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload