Product Sort order - descending

[SarahL]

Hiya

For some odd reason I seem to have our products in descending order - ie each product has its own sort value and its showing them 800 first to 0 last - when its usually the other way round!

I cannot see where I might have done this to switch it back - as I would like 0 & 1 shown before 800 (product sort value)

(I know that you can change the sort to name and / or price etc using 1a 1d, 2a 2d etc etc but we really would like to have it as 0-800 and there is no value to change from ascending to descending - in that area that I can see)

Any ideas??

(I thought that you could default to 20a or 20d but then realised that it ignores that and gives me the 800-1 sort ...)

(http://www.maximonsolutions.com/shop...-mobile-radios shows the discontinued ones first when we need them last)

Thank you
Sarah

[mc12345678]

Have you tried removing any sort order by leaving as blank instead of 20a? A default install will sort by sort number if there is no sort order "designation" provided.

This is controlled by the filters in includes/index_filters

[SarahL]

Have you tried removing any sort order by leaving as blank instead of 20a? A default install will sort by sort number if there is no sort order "designation" provided.

This is controlled by the filters in includes/index_filters

Yes its currently blank already and seems to sort it backwards to normal!

[mc12345678]

Yes its currently blank already and seems to sort it backwards to normal!

Just looked through the code and there is a place where the "normal" sort order could be reversed, don't know if that is what happened for/to you...

If you only have three files in the includes/index_filters directory, then take a look at default_filter.php

Towards the "bottom" lines 104 and 105 read like this in a vanilla install:

//       $listing_sql .= " order by p.products_sort_order desc, pd.products_name"; 
          $listing_sql .= " order by p.products_sort_order, pd.products_name";

With a comment above that reads:

// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER is left blank 
// for reverse, descending order use:

And so perhaps, the first line has been uncommented and the second commented? (swapping of // from the first line to the second)

[SarahL]

thank you! I will certainly go take a look at that code

[SarahL]

THANK YOU!

That sorted it - I had swapped it previously using that code and totally forgot in in my notes!!

thank you so much

[mc12345678]

THANK YOU!

That sorted it - I had swapped it previously using that code and totally forgot in in my notes!!

thank you so much

Glad that's all it was. :) happy zenning!