Product Sort Order not working

[barendfaber]

Hi,

Hope someone can help, could not find the answer on the forum. This is the site: www.housetechsolutions.co.uk. Under Househeat Wireless Controls, I want the products to de displayed in a certain order. I have added a Sort Order to each product as below in Admin:

Househeat The Ultimate Bundle 1
HouseHeat Pro set 2
HouseHeat Non-Pro set 3
HouseHeat Valve Motor 4
HouseHeat Boiler Box 5
Window Sensor hws 6
HouseHeat Pro Thermostat 7
HouseTech TRV set (angled) 8
Thermostat Protection Cover 9
HouseTech’s Dry heating Control 10
Radiator reflector panels 11
HouseTech's Space Paint 12

Yet on the site, the order is all mixed up. Can someone help so I can display my products in the right order please?

[stevesh]

In a stock Zencart installation, if sort order isn't specified, the products are sorted alphabetically. If a sort order is specified, they are sorted by those numbers.

Yours seem to be sorted by product id. What happens if you switch temporarily to the Classic template ?

Also check your setting in Admin - Configuration - Product Listing - Display Product Listing Default Sort Order

[barendfaber]

Hi,

When I switch the standard template, everything works. Is this the template then? Is there anything I can do to fix it?

In Admin - Product Listing - Display Product Listing Default Sort Order, there is nothing. Should I add something there?

[stevesh]

There's a support thread for 12leaves templates here:

http://www.zen-cart.com/forum/showthread.php?t=162997

Blank is the default value for that setting, so that's OK.

[barendfaber]

Hi,

I finally heard back from them, but this is not a 12leaves product, the designers zen-cart-power.net does not offer support. So I am back asking for help from anyone who knows how I can fix this please!

[stevesh]

Only thing I can think of would be to look through the files provided in the template and replace them with stock copies one by one until the sorting process works properly.

[barendfaber]

Thanks so far, still not working. I will create a new post and see if someone else has another recommendation.

[Ajeh]

Try this in phpMySQL and see what order your products come up in:

select p.products_id, p.products_sort_order, pd.products_name from products p, products_description pd
where pd.products_id = p.products_id and p.master_categories_id = 1
order by p.products_sort_order;

Are they in the right order? Do the products_sort_order look like what you have set on them in the Admin?

[barendfaber]

Hi Ajeh, good to hear from you! Yes, they are in the right order in phpMySQL:

products_id products_sort_order products_name
17 1 Househeat The Ultimate Bundle
7 2 HouseHeat Pro set
19 3 HouseHeat Non-Pro set
16 4 HouseHeat Valve Motor
8 5 HouseHeat Boiler Box
2 6 Window Sensor
23 7 HouseHeat Pro Thermostat
5 8 HouseTech TRV set (angled)
22 9 Thermostat Protection Cover
20 10 HouseTech’s Dry heating Control
3 11 Radiator reflector panels
10 12 HouseTech's Space Paint
4 13 The Housemaster
6 14 HouseTech’s Standalone Radiator Control

[barendfaber]

Yes, it works under the classic template