Sort by price?

[kenlyle]

I want to sort my category listing by price. I have deduced that it's not in product_listing_col.php, because I put sort by price ASC in the $pg_query, and ran the query string through PHPMyAdmin, and it returned empty set, but my page shows products, so I know that the query must be passed from somewhere else but I don't know where.

I see in index.php that there are references to $HTTP_GET_VARS and whether sort by price has been 'requested' and I think I remember this in the Admin of another OSC version, and I don't know how to pass the variables to index.php to make the categories list sort by price.

Any tips appreciated.

Ken

[kenlyle]

I found that appending &sort=3a to my URL, like index.php?cPath=1_17&sort=3a
does what I want. Now, how to get that appended onto the URL produced by clicking on the category in the categories box or from the categories list?

[bgreenlee]

I am having the same issue. Any luck?

[bgreenlee]

Found this and it works great!

http://www.oscdox.com/index.php?name...pic&t=2435

[dead7]

Sorry to bump this but I thought it would be a good addition to the thread.

To sort by lowest first you would use ?sort=3a, to sort by highest to lowest it's ?sort=3d.

IF you want to do this in your product listings, apply the following examples. I'm running RC3 using product listing columns (product_listing_col.php).

You may style these links however you see fit.

PHP Code:

<?
$myfile = explode("?", basename($_SERVER['REQUEST_URI']));
$myfile = $myfile[0];
?>
<a href="http://www.foo.bar/catalog/<?=(!empty($myfile)) ? $myfile : ''?>?sort=3a">lowest price</a>
<br />
<a href="http://www.foo.bar/catalog/<?=(!empty($myfile)) ? $myfile : ''?>?sort=3d">highest price</a>

If you're a php guru feel free to make it better and let others know about it. I had a very good need for this function and came up with this, use it as you wish.

Hope it helps someone..

Regards

[sirsonic]

I used this code on index_products.tpl right after the normal category sort at about line 60

 // Additional Products Sort
	     echo '<td align="center" class="main">' . tep_draw_form('sort', FILENAME_DEFAULT, 'get') . '<b>Sort by:</b>&nbsp;&nbsp;';

	     if (isset($HTTP_GET_VARS['manufacturers_id'])) {
	         echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);
	     } else {
	         echo tep_draw_hidden_field('cPath', $cPath);
	     }

	     $sort_list = array('' => 'Select',
							'4a' => 'Price Low to High',
	                        '4d' => 'Price High to Low',
							'3a' => 'Products Name A to Z',
	                        '3d' => 'Products Name Z to A');
	     foreach($sort_list as $id=>$text) {
	      $sort_range[] = array('id' => $id, 'text' => $text);
	     }

	     echo tep_draw_pull_down_menu('sort', $sort_range, (isset($HTTP_GET_VARS['sort']) ? $HTTP_GET_VARS['sort'] : ''), 'onchange="this.form.submit()"');
	     echo tep_draw_hidden_field('filter_id', (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''));
	     echo '</form></td>' . "\n";
 // End Additional Products Sort