<?xml version="1.0" encoding="utf-8" ?>
<rss version="2.0"
    xmlns:dc="http://purl.org/dc/elements/1.1/"
    xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
    xmlns:admin="http://webns.net/mvcb/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:content="http://purl.org/rss/1.0/modules/content/">
    
    <channel>
    
    <title>Programming Questions</title>
    <link>http://www.magentocommerce.com/boards/</link>
    <description>Magento Forums</description>
    <dc:language>en</dc:language>
    <dc:rights>Copyright 2012</dc:rights>
    <dc:date>2012-05-26T20:47:18-08:00</dc:date>
    <admin:generatorAgent rdf:resource="http://expressionengine.com/" />
    

    <item>
      <title>https set to Yes in admin not showing on frontend.</title>
      <link>http://www.magentocommerce.com/boards/viewthread/282104/</link>
      <guid>http://www.magentocommerce.com/boards/viewthread/282104/#When:20:47:18Z</guid>
      <description><![CDATA[<p>The only way for me to get https to show on the frontend is to set UNSECURE section to https.&nbsp; Please see attached.
</p>]]></description>
      <dc:date>2012-05-26T20:47:18-08:00</dc:date>
    </item>

    <item>
      <title>https 500 Internal Server Error</title>
      <link>http://www.magentocommerce.com/boards/viewthread/282103/</link>
      <guid>http://www.magentocommerce.com/boards/viewthread/282103/#When:20:45:05Z</guid>
      <description><![CDATA[<p>When https is set to YES in admin, video on form on the frontend do not upload.&nbsp; It shows 500 Error:&nbsp; Internal Server Error.&nbsp; Please see attached.
</p>]]></description>
      <dc:date>2012-05-26T20:45:05-08:00</dc:date>
    </item>

    <item>
      <title>$product&#45;&amp;gt;getDescription() return blank string</title>
      <link>http://www.magentocommerce.com/boards/viewthread/282055/</link>
      <guid>http://www.magentocommerce.com/boards/viewthread/282055/#When:11:10:37Z</guid>
      <description><![CDATA[<p>Hi,
<br />
I have this code (on an external cronjob):
</p>
<p>
<div class="codeblock"><code>
<span style="color: #0000BB">&lt;?php<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">require(</span><span style="color: #DD0000">'../app/Mage.php'</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Mage</span><span style="color: #007700">::</span><span style="color: #0000BB">app</span><span style="color: #007700">(</span><span style="color: #DD0000">"default"</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$product&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">Mage</span><span style="color: #007700">::</span><span style="color: #0000BB">getModel</span><span style="color: #007700">(</span><span style="color: #DD0000">'catalog/product'</span><span style="color: #007700">)-&gt;</span><span style="color: #0000BB">load</span><span style="color: #007700">(</span><span style="color: #0000BB">4257</span><span style="color: #007700">);&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;</span><span style="color: #DD0000">'description&nbsp;:'</span><span style="color: #007700">.</span><span style="color: #0000BB">$product</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">description</span><span style="color: #007700">.</span><span style="color: #DD0000">'&lt;br&gt;'</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$products&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">Mage</span><span style="color: #007700">::</span><span style="color: #0000BB">getModel</span><span style="color: #007700">(</span><span style="color: #DD0000">'catalog/product'</span><span style="color: #007700">)-&gt;</span><span style="color: #0000BB">getCollection</span><span style="color: #007700">();<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$products</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">addAttributeToSelect</span><span style="color: #007700">(</span><span style="color: #DD0000">'description'</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$products</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">addAttributeToSelect</span><span style="color: #007700">(</span><span style="color: #DD0000">'name'</span><span style="color: #007700">);&nbsp;&nbsp;&nbsp;&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$products</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">addAttributeToFilter</span><span style="color: #007700">(</span><span style="color: #DD0000">'entity_id'</span><span style="color: #007700">,&nbsp;array(</span><span style="color: #DD0000">'eq'&nbsp;</span><span style="color: #007700">=&gt;&nbsp;</span><span style="color: #DD0000">'4257'</span><span style="color: #007700">));<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$cont</span><span style="color: #007700">=</span><span style="color: #0000BB">1</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;foreach(</span><span style="color: #0000BB">$products&nbsp;</span><span style="color: #007700">as&nbsp;</span><span style="color: #0000BB">$product</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">&#123;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #DD0000">'Name:&nbsp;'</span><span style="color: #007700">.</span><span style="color: #0000BB">$product</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">getName</span><span style="color: #007700">().</span><span style="color: #DD0000">',&nbsp;description:'</span><span style="color: #007700">.</span><span style="color: #0000BB">$product</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">getDescription</span><span style="color: #007700">();<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">&#125;<br /><br />?&gt;</span>
</code></div>
</p>
<p>
The first method work fine: I see html description of product with id 4257.
<br />
The second method don&#8217;t work: I see name (I tried other attributes, every attribute works fine) but not description!
</p>
<p>
Can you help me? Thanks!
</p>]]></description>
      <dc:date>2012-05-26T11:10:37-08:00</dc:date>
    </item>

    <item>
      <title>Delay sales order creation when redirecting to 3rd party payment gateway until gateway returns success/failure</title>
      <link>http://www.magentocommerce.com/boards/viewthread/265077/</link>
      <guid>http://www.magentocommerce.com/boards/viewthread/265077/#When:08:29:35Z</guid>
      <description><![CDATA[<p>Hi,
</p>
<p>
Magento 1.4.1.1
</p>
<p>
I&#8217;ve implemented a payment method which redirects to a 3rd party gateway using the standard Magento method of implementing getOrderPlaceRedirectUrl()  in my payment method &amp; implementing the success &amp; failure controller actions.
</p>
<p>
The problem I&#8217;ve found with this is that the sales order gets created <b>before</b> the redirect happens.&nbsp; From my point of view, it would be preferable if the quote just remains active in the session &amp; the sales order only gets created if a successful payment callback is received.&nbsp; This means no false orders clogging up the queue &amp; no wasted order increment id&#8217;s for orders which would need to be deleted anyway.
</p>
<p>
It doesn&#8217;t look like there&#8217;s any way to do this without overriding &amp; changing the behavour of the Onepage controller.&nbsp; The saveOrderAction() function makes the call which creates the order ($this-&gt;getOnepage()-&gt;saveOrder()) &amp; this call is necessary for the redirect to the Gateway to happen, as it&#8217;s where the redirect url is set.
</p>
<p>
Annoyingly, in the OnepageController at the end of the saveOrderAction() method there&#8217;s a comment that states &#8221;<i>when there is redirect to third party, we don&#8217;t want to save order yet. we will save the order in return action</i>.&#8221;...but the order has already been saved at this point.
</p>
<p>
So, is anybody aware of an alternative way to implement the gateway redirect which will delay sales order creation *without* having to override the controller (this just seems wrong, as I&#8217;m writing a payment method so shouldn&#8217;t need to touch the controller).
</p>
<p>
Thanks
</p>
<p>
Steve
</p>]]></description>
      <dc:date>2011-11-04T08:29:35-08:00</dc:date>
    </item>

    <item>
      <title>$product&#45;&amp;gt;Save(); Unchecks &#8220;Use Default Values&#8221; For all attributes in store.</title>
      <link>http://www.magentocommerce.com/boards/viewthread/264363/</link>
      <guid>http://www.magentocommerce.com/boards/viewthread/264363/#When:12:14:45Z</guid>
      <description><![CDATA[<p>When updating a single attribute value for a product for a specific store id, all of the attributes &#8220;Use Default Values&#8221; become unchecked.
</p>
<p>
<div class="codeblock"><code>
<span style="color: #0000BB">$product</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">setStoreId</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">)-&gt;</span><span style="color: #0000BB">setData</span><span style="color: #007700">(</span><span style="color: #DD0000">'visibility'</span><span style="color: #007700">,</span><span style="color: #0000BB">1</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$product</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">save</span><span style="color: #007700">();</span>
</code></div>
</p>
<p>
I can manually set an attribute to &#8220;Use Default Values&#8221; with:
</p>
<p>
<div class="codeblock"><code>
<span style="color: #0000BB">$product</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">setStoreId</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">)-&gt;</span><span style="color: #0000BB">setData</span><span style="color: #007700">(</span><span style="color: #DD0000">'visibility'</span><span style="color: #007700">,</span><span style="color: #0000BB">false</span><span style="color: #007700">);</span>
</code></div>
</p>
<p>
But saving all of the attributes for a product this way wouldn&#8217;t help me. There may be times when they need to be unchecked.
<br />
How can I programaticaly leave those attributes &#8220;Use Default Values&#8221; check boxes untouched if they are already checked?
</p>
<p>
I&#8217;ve tried it via the API with the same results.
</p>
<p>
<div class="codeblock"><code>
//&nbsp;this&nbsp;still&nbsp;unchecks&nbsp;all&nbsp;of&nbsp;the&nbsp;attributes&nbsp;Use&nbsp;Default&nbsp;Values&nbsp;checkboxes.<br /></span><span style="color: #0000BB">$client</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">call</span><span style="color: #007700">(</span><span style="color: #0000BB">$sessionId</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'catalog_product.update'</span><span style="color: #007700">,&nbsp;array(</span><span style="color: #0000BB">1977</span><span style="color: #007700">,&nbsp;array(</span><span style="color: #DD0000">'visibility'</span><span style="color: #007700">=&gt;</span><span style="color: #0000BB">1</span><span style="color: #007700">),&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">));</span>
</code></div>
</p>
<p>
Any ideas?
</p>]]></description>
      <dc:date>2011-10-27T12:14:45-08:00</dc:date>
    </item>

    <item>
      <title>Price actualization when I choose a custom option (simple Product)</title>
      <link>http://www.magentocommerce.com/boards/viewthread/282045/</link>
      <guid>http://www.magentocommerce.com/boards/viewthread/282045/#When:06:36:03Z</guid>
      <description><![CDATA[<p>Hi to all!
</p>
<p>
i have a little problem and don\\\\\\\\\\\\\\\&#8217;t know how exactly to solve it.
</p>
<p>
Problem: I have a simple Product with 2 individual options. Size and color. There are about 4 size options with different prices. the color has no price change when selected.
</p>
<p>
At the moment, the higher prices of the size options are shown with \\\\\\\\\\\\\\\"+15 €\\\\\\\\\\\\\\\&#8221;. This is not the best solution, but i read much about the absolute price etc....
</p>
<p>
My problem is the price that is shown on the product site. If I select a higher price option (for example: \\\\\\\\\\\\\\\"+15 €\\\\\\\\\\\\\\\") the main price which was for example 40 € won\\\\\\\\\\\\\\\&#8217;t update automatically. Normally there should be an update when the individual option is selected. the price should then be 55 €. When I add the product to the cart, the correct price with the option (55 €) is in the cart.
</p>
<p>
But unfortunately the price shown on the product page won\\\\\\\\\\\\\\\&#8217;t be updated when i select an option with a higher price. I use my own template, build by a friend. 
</p>
<p>
Can you 1. tell me whether normally magentp updates the price in the base template that comes with the basic installation?
</p>
<p>
and 2. how i can bring magenta to update the price when i select an option?
</p>
<p>
I read much about it, but the solution wasn\\\\\\\\\\\\\\\&#8217;t really shown so I would appreciate it if you can tell me the solution. Just a first step to the way would also be great! <img src="http://www.magentocommerce.com/images/smileys/smile.gif" width="19" height="19" alt="smile" style="border:0;padding:0;" />
</p>
<p>
Best regards
<br />
andi
</p>]]></description>
      <dc:date>2012-05-26T06:36:03-08:00</dc:date>
    </item>

    <item>
      <title>Product Type Strategy</title>
      <link>http://www.magentocommerce.com/boards/viewthread/282039/</link>
      <guid>http://www.magentocommerce.com/boards/viewthread/282039/#When:04:46:56Z</guid>
      <description><![CDATA[<p>Greetings,
</p>
<p>
I struggling to come up with a good product type strategy in order to properly list our products in magento. Our products must maintain the following characteristics:-
</p>
<p>
- The product is effectively a collection of simple and/or grouped products in order to allow magento to effectively manage stock levels
<br />
- The product lists a fixed set price however there will be certain sub-products which can be swapped out for others in our inventory which maybe similar or greater in price
<br />
- On the product page if the user chooses to &#8220;customise&#8221; any of these specific sub-products within it. the price should be recalculated &amp; update the displayed price on the page
</p>
<p>
I considered using a bundle product type however it doesn&#8217;t seem to support adding sub-products which are fixed &amp; cannot be customised. Also the configurable product doesn&#8217;t seem to support price-modification based on the configured sub-products within it.
</p>
<p>
What would be the best way to get this to work? Would I need to add a new product type based on either the configurable or bundle type &amp; modify the code to suit?
</p>
<p>
I&#8217;m comfortable with coding this should it be required however I am very new to magento programming so any help/direction would be very much appreciated.
</p>]]></description>
      <dc:date>2012-05-26T04:46:56-08:00</dc:date>
    </item>

    <item>
      <title>magento bestsellers not working &#45; seeking fix or workaround</title>
      <link>http://www.magentocommerce.com/boards/viewthread/273400/</link>
      <guid>http://www.magentocommerce.com/boards/viewthread/273400/#When:05:07:24Z</guid>
      <description><![CDATA[<p>I&#8217;m new to Magento and these forums (Hello all by the way) and I was wondering if anyone could help me....
</p>
<p>
I&#8217;m working on a magento site (Magento ver. 1.5.1.0) (built by someone else) which seems to be in a bit of a state - I don&#8217;t have much experience with magento so appreciate any help I can get (and I need a lot).
</p>
<p>
I am currently trying to get an option to sort by bestsellers I have managed to do this by adding local files to override the core files as follows:
</p>
<p>
httpdocs/app/code/local/Mage/Catalog/Block/Product/List/Toolbar.php:
</p>
<p>
 <div class="codeblock"><code>
<span style="color: #007700">public&nbsp;function&nbsp;</span><span style="color: #0000BB">getAvailableOrders</span><span style="color: #007700">()<br /></span><span style="color: #0000BB">&#123;<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #FF8000">//return&nbsp;$this-&gt;_availableOrder;<br />&nbsp;&nbsp;&nbsp;&nbsp;//Custom&nbsp;Order&nbsp;list&nbsp;Edit<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">_availableOrder&nbsp;</span><span style="color: #007700">=&nbsp;array(<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #DD0000">'qty_ordered'&nbsp;</span><span style="color: #007700">=&gt;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">__</span><span style="color: #007700">(</span><span style="color: #DD0000">'Best&nbsp;Sellers'</span><span style="color: #007700">),<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #DD0000">'entity_id'&nbsp;</span><span style="color: #007700">=&gt;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">__</span><span style="color: #007700">(</span><span style="color: #DD0000">'Latest&nbsp;arrivals'</span><span style="color: #007700">),<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #DD0000">'name'&nbsp;</span><span style="color: #007700">=&gt;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">__</span><span style="color: #007700">(</span><span style="color: #DD0000">'Name'</span><span style="color: #007700">),<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #DD0000">'price'&nbsp;</span><span style="color: #007700">=&gt;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">__</span><span style="color: #007700">(</span><span style="color: #DD0000">'Price'</span><span style="color: #007700">)<br />&nbsp;&nbsp;&nbsp;&nbsp;);<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #FF8000">//Custom&nbsp;Available&nbsp;Order&nbsp;-Edit&nbsp;finish<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">return&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">_availableOrder</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">&#125;</span>
</code></div>
</p>
<p>
And httpdocs/app/design/frontend/default/localsite/template/catalog/product/list/toolbar.phmtl:
</p>
<p>
<div class="codeblock"><code>
<span style="color: #007700">&lt;</span><span style="color: #0000BB">fieldset&nbsp;</span><span style="color: #007700">class=</span><span style="color: #DD0000">"sort-by"</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">label</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">__</span><span style="color: #007700">(</span><span style="color: #DD0000">'Sort&nbsp;by'</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">?&gt;</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">label</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">select&nbsp;onchange</span><span style="color: #007700">=</span><span style="color: #DD0000">"setLocation(this.value)"</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">option&nbsp;value</span><span style="color: #007700">=</span><span style="color: #DD0000">"&lt;?php&nbsp;echo&nbsp;$this-&gt;getOrderUrl('entity_id',&nbsp;'desc')&nbsp;?&gt;"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">if(</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">isOrderCurrent</span><span style="color: #007700">(</span><span style="color: #DD0000">'entity_id'</span><span style="color: #007700">)&nbsp;&amp;&amp;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">getCurrentDirection</span><span style="color: #007700">()&nbsp;==&nbsp;</span><span style="color: #DD0000">'desc'</span><span style="color: #007700">):&nbsp;</span><span style="color: #0000BB">?&gt;&nbsp;selected</span><span style="color: #007700">=</span><span style="color: #DD0000">"selected"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">endif;&nbsp;</span><span style="color: #0000BB">?&gt;</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Newest&nbsp;Products<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">option</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">option&nbsp;value</span><span style="color: #007700">=</span><span style="color: #DD0000">"&lt;?php&nbsp;echo&nbsp;$this-&gt;getOrderUrl('qty_ordered',&nbsp;'desc')&nbsp;?&gt;"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">if(</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">isOrderCurrent</span><span style="color: #007700">(</span><span style="color: #DD0000">'qty_ordered'</span><span style="color: #007700">)&nbsp;&amp;&amp;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">getCurrentDirection</span><span style="color: #007700">()&nbsp;==&nbsp;</span><span style="color: #DD0000">'desc'</span><span style="color: #007700">):&nbsp;</span><span style="color: #0000BB">?&gt;&nbsp;selected</span><span style="color: #007700">=</span><span style="color: #DD0000">"selected"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">endif;&nbsp;</span><span style="color: #0000BB">?&gt;</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Best&nbsp;Sellers<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">option</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">option&nbsp;value</span><span style="color: #007700">=</span><span style="color: #DD0000">"&lt;?php&nbsp;echo&nbsp;$this-&gt;getOrderUrl('price',&nbsp;'asc')&nbsp;?&gt;"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">if(</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">isOrderCurrent</span><span style="color: #007700">(</span><span style="color: #DD0000">'price'</span><span style="color: #007700">)&nbsp;&amp;&amp;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">getCurrentDirection</span><span style="color: #007700">()&nbsp;==&nbsp;</span><span style="color: #DD0000">'asc'</span><span style="color: #007700">):&nbsp;</span><span style="color: #0000BB">?&gt;&nbsp;selected</span><span style="color: #007700">=</span><span style="color: #DD0000">"selected"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">endif;&nbsp;</span><span style="color: #0000BB">?&gt;</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Lowest&nbsp;Price<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">option</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">option&nbsp;value</span><span style="color: #007700">=</span><span style="color: #DD0000">"&lt;?php&nbsp;echo&nbsp;$this-&gt;getOrderUrl('price',&nbsp;'desc')&nbsp;?&gt;"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">if(</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">isOrderCurrent</span><span style="color: #007700">(</span><span style="color: #DD0000">'price'</span><span style="color: #007700">)&nbsp;&amp;&amp;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">getCurrentDirection</span><span style="color: #007700">()&nbsp;==&nbsp;</span><span style="color: #DD0000">'desc'</span><span style="color: #007700">):&nbsp;</span><span style="color: #0000BB">?&gt;&nbsp;selected</span><span style="color: #007700">=</span><span style="color: #DD0000">"selected"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">endif;&nbsp;</span><span style="color: #0000BB">?&gt;</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Highest&nbsp;Price<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">option</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">option&nbsp;value</span><span style="color: #007700">=</span><span style="color: #DD0000">"&lt;?php&nbsp;echo&nbsp;$this-&gt;getOrderUrl('name',&nbsp;'asc')&nbsp;?&gt;"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">if(</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">isOrderCurrent</span><span style="color: #007700">(</span><span style="color: #DD0000">'name'</span><span style="color: #007700">)&nbsp;&amp;&amp;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">getCurrentDirection</span><span style="color: #007700">()&nbsp;==&nbsp;</span><span style="color: #DD0000">'asc'</span><span style="color: #007700">):&nbsp;</span><span style="color: #0000BB">?&gt;&nbsp;selected</span><span style="color: #007700">=</span><span style="color: #DD0000">"selected"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">endif;&nbsp;</span><span style="color: #0000BB">?&gt;</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Name&nbsp;A</span><span style="color: #007700">-</span><span style="color: #0000BB">Z<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">option</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">option&nbsp;value</span><span style="color: #007700">=</span><span style="color: #DD0000">"&lt;?php&nbsp;echo&nbsp;$this-&gt;getOrderUrl('name',&nbsp;'desc')&nbsp;?&gt;"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">if(</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">isOrderCurrent</span><span style="color: #007700">(</span><span style="color: #DD0000">'name'</span><span style="color: #007700">)&nbsp;&amp;&amp;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">getCurrentDirection</span><span style="color: #007700">()&nbsp;==&nbsp;</span><span style="color: #DD0000">'desc'</span><span style="color: #007700">):&nbsp;</span><span style="color: #0000BB">?&gt;&nbsp;selected</span><span style="color: #007700">=</span><span style="color: #DD0000">"selected"</span><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">endif;&nbsp;</span><span style="color: #0000BB">?&gt;</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Name&nbsp;Z</span><span style="color: #007700">-</span><span style="color: #0000BB">A<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">option</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/</span><span style="color: #0000BB">select</span><span style="color: #007700">&gt;<br />&lt;/</span><span style="color: #0000BB">fieldset</span><span style="color: #007700">&gt;</span>
</code></div>
</p>
<p>
This works in the sense that I now have a bestsellers sort option which sorts in the same way as the bestsellers on the dashboard. Unfortunately the bestsellers section of the dashboard and consequently my sort list is entirely wrong and I dont know why, a Google search has suggested the only way to fix this is to rebuild the products database and essentially delete everything contained within -this is not an option as the site is live.
</p>
<p>
Does anyone know how to fix this or failing that does anyone know another attribute I can sort by to achieve the same result - if I go to Dashboard&gt;reports&gt;products&gt;Products Ordered I can get the order I want with a wide date range - any way to recreate this in the sort options. Is there a list of available sort options out there somewhere? I have tried sorting by qty_ordered, ordered_qty, qty_invoiced, total_ordered_qty and all seem to do the same thing despite resetting and flushing the cache in between - what is happening here?
</p>
<p>
In addition to this the a to z category seems to break about half way through for some reason having looked through the database I am wondering if this has something to do with store_id - what is this and why are there two of them?
</p>
<p>
To be honest I am not entirely sure I have gone about this the right way as I know it has broken the dashboard available sort options but nothing else seemed to work - I am open to any suggestions here. If I need to provide any more info I am happy to do so - I would really appreciate any info on how magento produces its aggregate bestsellers tables in the database - cause it aint working!
</p>
<p>
Any tips, advice, help much appreciated.
</p>]]></description>
      <dc:date>2012-02-17T05:07:24-08:00</dc:date>
    </item>

    <item>
      <title>Please help me</title>
      <link>http://www.magentocommerce.com/boards/viewthread/278477/</link>
      <guid>http://www.magentocommerce.com/boards/viewthread/278477/#When:05:44:31Z</guid>
      <description><![CDATA[<p>Does Anybody know the how to get best seller product
</p>]]></description>
      <dc:date>2012-04-19T05:44:31-08:00</dc:date>
    </item>

    <item>
      <title>GET PRODUCT</title>
      <link>http://www.magentocommerce.com/boards/viewthread/278478/</link>
      <guid>http://www.magentocommerce.com/boards/viewthread/278478/#When:05:50:18Z</guid>
      <description><![CDATA[<p>Does Anybody know the how to get best seller product
</p>]]></description>
      <dc:date>2012-04-19T05:50:18-08:00</dc:date>
    </item>

    
    </channel>
</rss>
