price sort - can't figure it out

I've set the Categories/Products Display Sort Order to "5= Products Price+, Products Name".

I've set the Previous Next - Sort Order to "3= Price, Product Name".

In Store Manager I clicked the "Update ALL Products Price Sorter" button.

And the products displayed in any category are still not sorting by price. What am I doing wrong? And is the difference between the first two options above?

I am trying to do the exact same thing - but with no luck unless I force the product listing to default a particular product as the first on the list - which is no use as it means I'll have to update this every time a more expensive product is listed.

Have set everything above plus have set the default product set order to a product sort id - but then my next & previous is out of sorts...

Help - must be something v.v.v.obvious - cheers

ooops - sorted one wee bit, I forgot to amend the "next sort order" in product info to go through the list as I require.

From what I can tell the products_price_sorter does not include tax.. so if you have some products with tax and some without you will get unusual results.

I am looking into this at the moment but cant find anything on the forums...

I don't know if it will fix your problem but it fixed mine - this was to do with the tax rates not being added onto products_price_sorter.

I edited the function zen_update_products_price_sorter() in the file admin\includes\functions\general.php

The updated code is as follows (starts at roughly line 2510):

////
// set the products_price_sorter
function zen_update_products_price_sorter($product_id) {
global $db, $currencies;

$products_price_sorter = zen_get_products_actual_price($product_id);


# We now need to add tax onto this
$tax_class = $db->Execute('SELECT products_tax_class_id FROM ' . TABLE_PRODUCTS . ' WHERE products_id = ' . $product_id);
$tax_class_id = $tax_class->fields['products_tax_class_id'];

$tax_rate = zen_get_tax_rate_value($tax_class_id);
$products_price_sorter = zen_add_tax($products_price_sorter, $tax_rate);


$db->Execute("update " . TABLE_PRODUCTS . " set
     products_price_sorter='" . zen_db_prepare_input($products_price_sorter) . "'
     where products_id='" . $product_id . "'");

}

Please note I implemented this in version 1.3.7 and have not tested in any other.

I live in Ohio ... I don't pay tax to you ... now the products_price_sorter is all goobered up for me if I login as you have added Tax ... :unsure:

FYI I did figure it out -

"Display Product Listing Default Sort Order"

It should be set to "3a", meaning 3rd column (which is price), and 'a' for ascending.

Thanks for the update ...

Note: the columns can be arranged in any order so this can change depending on the order of the columns ... thanks for posting your solution ...

Hi, I'm preparing data to upload to database. What value(s) should go to the products_price_sorter field by default? I did some testing, but I'm getting a random results - some items show the same value as the price, other items show a random number (can't figure it out yet what this represents) - please advise, Thanks,

The products_price_sorter contains the lowest price that a product can be ...

This is calculated each time a product is edited or something to do with price has changed ...

Products require a master_categories_id to compute the products_price_sorter ... if this is set correctly, you can update the products_price_sorter after importing your files in the Tools ... Store Manager ...