I Can't Sort By Price

[Corneloues]

Hi all,

 

I'm using contribution 4312 - Sort By Dropdown

http://www.oscommerce.com/community/contributions,4312

 

Hope someone can help. I'm having difficulty getting the sort price options to work. The sort by Name and Best Sellers work, but by price doesn't.

 

I also appeared to get the SQL error I have seen here where no order fields were specified. I solved this by changing the "Product Recent Sales" value to 4, which was the last column and appears to match the "Product Listing" setting.

 

However, I'll be damned if I can get the price sorting to work. Below are the values from my Admin/Config and the values in the $sort_list array. Any help would be appreciated.

 

Product Recent Sales 4

Display Product Image 1

Display Product Manufaturer Name 1

Display Product Model 0

Display Product Name 1

Display Product Price 2

Display Product Quantity 0

Display Product Weight 0

Display Buy Now column 3

Display Category/Manufacturer Filter (0=disable; 1=enable) 1

Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both) 3

 

$sort_list = array('4d' => 'Best Sellers',

'2a' => 'Products Name A to Z',

'2d' => 'Products Name Z to A',

'3a' => 'Price Low to High',

'3d' => 'Price High to Low');

 

Cheers,

 

Roy

Edited May 23, 2008 by Corneloues

[msmillk22]

Try this :

 

http://addons.oscommerce.com/info/2673

[milauskas]

Try this :

 

http://addons.oscommerce.com/info/2673

 

Hi,

 

I just tried that myself with no change. Products still aren't sorting by price. Did you have success with this?

 

Mike

[spooks]

Hi,

 

I just tried that myself with no change. Products still aren't sorting by price. Did you have success with this?

 

Mike

 

I`m not surprised that did`nt work, its for atributes, not what your after.

 

I covered this in this thread http://www.oscommerce.com/forums/index.php?sho...=306310&hl=