Product Sort Order not working

04 Sep 2011, 08:59

#1

Zen Follower

Join Date:: Apr 2010
Posts:: 263
Plugin Contributions:: 0

Product Sort Order not working

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?

04 Sep 2011, 12:48

#2

stevesh

Black Belt

Join Date:: Feb 2005
Posts:: 19,793
Plugin Contributions:: 2

Re: Product Sort Order not working

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

04 Sep 2011, 15:27

#3

barendfaber

Zen Follower

Join Date:: Apr 2010
Posts:: 263
Plugin Contributions:: 0

Re: Product Sort Order not working

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?

04 Sep 2011, 23:44

#4

stevesh

Black Belt

Join Date:: Feb 2005
Posts:: 19,793
Plugin Contributions:: 2

Re: Product Sort Order not working

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.

07 Sep 2011, 09:51

#5

barendfaber

Zen Follower

Join Date:: Apr 2010
Posts:: 263
Plugin Contributions:: 0

Re: Product Sort Order not working

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! :shocking:

07 Sep 2011, 10:35

#6

stevesh

Black Belt

Join Date:: Feb 2005
Posts:: 19,793
Plugin Contributions:: 2

Re: Product Sort Order not working

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.

07 Sep 2011, 11:05

#7

barendfaber

Zen Follower

Join Date:: Apr 2010
Posts:: 263
Plugin Contributions:: 0

Re: Product Sort Order not working

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

07 Sep 2011, 13:23

#8

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Product Sort Order not working

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?

07 Sep 2011, 14:23

#9

barendfaber

Zen Follower

Join Date:: Apr 2010
Posts:: 263
Plugin Contributions:: 0

Re: Product Sort Order not working

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

07 Sep 2011, 15:34

#10

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Product Sort Order not working

What happens if you switch to the Classic Template? Does it fix the Sort Order on the Product Listing? :unsure:

07 Sep 2011, 15:35

#11

barendfaber

Zen Follower

Join Date:: Apr 2010
Posts:: 263
Plugin Contributions:: 0

Re: Product Sort Order not working

Yes, it works under the classic template

07 Sep 2011, 15:46

#12

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Product Sort Order not working

It has to be your template then ...

You need to do a comparison on what the template and override files are doing compared to the original files ...

Beyond Compare from scootersoftware.com is a good tool for this ...

There is definitely something wrong with the files, as if you click on one of the titles such as Name, you will see the SQL error ...

Does the same thing happen in the Classic Template or does it sort by Product Name?

07 Sep 2011, 15:52

#13

barendfaber

Zen Follower

Join Date:: Apr 2010
Posts:: 263
Plugin Contributions:: 0

Re: Product Sort Order not working

The classic template works perfect, it displays the products in the correct order. I have looked ta the files supplied with the template, the only one I could see that I think may have to do with this is product_listing under Modules. None of the other files has a name that suggests it may affect the product listing. Could this be the problem?

07 Sep 2011, 16:19

#14

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Product Sort Order not working

You would be better off comparing the files on your server to the original files and comparing anything that uses the templates and overrides as there are quite a few files that are used for the Product Listing ...

Anywhere you see a templates and overrides directory, you should compare those files to the originals and see what differences there are ...

07 Sep 2011, 17:00

#15

barendfaber

Zen Follower

Join Date:: Apr 2010
Posts:: 263
Plugin Contributions:: 0

Re: Product Sort Order not working

Must I look at just the files supplied with the template, or that and any other add ons I installed?

07 Sep 2011, 17:16

#16

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Product Sort Order not working

I would check any file that is not part of the original files ...

NOTE: It sounds like it is a templates and overrides file ... so I would start there ...