Product Listing Default Sort Order

Hi

I am trying to sort the order my products are been displayed in. My products go up in 10's (eg. 10, 20, 30....) but my items dont start at 10. The order they go in is 10, 100, 110, 120...... 190, 20, 30, 40.

Is there a way to sort them so they go 10, 20, 30 and not 10, 100, 110

Thanks
Niall

I cannot reproduce this problem ... what version of Zen Cart are you using?

Clean install or an Upgrade?

Also check the setting on the Configuration ... Product Info ... that this is set for 0, for Sort Order, Option Name ...

Products Info - Products Option Name Sort Order
Sort order of Option Names for Products Info
0= Sort Order, Option Name
1= Option Name

Thanks for the reply... i am using zen cart v1.3.9d and "Products Info - Products Option Name Sort Order" is set to 0 already so its not that.

Could it be the fact that i have it like 10mm, 110mm, 120mm.... but i have tried putting spaces between the number and the mm(10 mm) and that didnt work.

Here is a link to one of the pages that it is happening in just so you can exactly see the problem

http://mauricedoodysales.com/index.php?main_page=index&cPath=589_591_672

If you look at the numbers, it starts at 10 and goes to 13 and then goes back to 2(which i want it to start with).

Any ideas?

Thanks again

Are you using Sort Order for your Product Listing or Product Name?

Sort Order are numbers, and will sort based on numeric rules ...

Product Names are characters, and will sort based on alpha/numeric rules ...

Check the setting on the Configuration ... Product Listing ... and see what setting you have for:

Display Product Listing Default Sort Order
Product Listing Default sort order?
NOTE: Leave Blank for Product Sort Order. Sort the Product Listing in the order you wish for the default display to start in to get the sort order setting. Example: 2a

When i checked it, it was blank so it is sort order that is being used at the moment(as default). Should I change this from sort order?

No, it is just weird that it is not functioning as written ...

If you switch to the Classic Template does the sort order change on your listing to be by the Products' settings for their Sort Order?

how do you cant back to the classic template?

never mind that last question... changed it :)

when i changed to the classic settings nothing changed

If you look at your Product Listing for the category you posted: 589_591_672

and look at the Sort Orders are these all numbered properly using the numbers 10, 20, 30 etc. for all of the Products in categories_id 672 ...

Are you using Linked Products and this might be a mixed Category?

all the products are listed the exact same 4.0mm 4.2mm 4.4mm etc. and no, there are no linked products with these. They are number 4.2mm (with no space between the 4.2 and the mm). But i have previously tried to put spaces between the number and the letters but nothing changed

In the Product Sort Order ... are you using numbers or alpha/numeric?

The Product Sort Order field is for numbers only ...

Are you entering in the Product Sort Order:
4.2

or are you entering:
4.2mm

oh sorry, i miss understood the question you where asking me. i have not entered anything in the product sort order field yet. i will have over 6000 items on the site so i dont want too have to enter the sort order for each individual item for them to be ordered correctly

Well then the Sort Order will not work very well ... :blink:

Enter the numbers either by 10s or use the numbers of the values to keep things clear such as:
10.5
11.0
11.5
2.5
12.0
12.2
etc. etc. etc.

not a very good listing system so if you have to enter every order to get it the way you want:frusty:

Thanks for the help anyway :smile:

Afraid we did not create the way alpha sort works ... that is the reason for the numeric Sort Order for those who need it ... :smile:

Hello! I'm having a little trouble getting my Product Listing page to show the correct sort order, BUT product info is displaying the correct order.

First I put in manual sort numbers via Easy Populate (these numbers flowed through to the database).

My Product Listing -> Display Product Listing Default Sort Order is blank

Under Product Info -> Previous Next Sort Order = 6

Do I have to change or uncomment any code? I've spent many hours trying to research/figure this out but no luck. I've tried setting my Column Grid to rows to see if the changes flowed through- but nope.

Thank you very much in advance!!

The way zen cart is set up, if I establish a sort # for any given item, that is the # I am stuck with throughout the entire site. This does not work for me because in one category I may want the item to show first and then in another category I may want it to show half way down. Therefore I have a field in the product_to_categories table named sort_id that I want to use for sorting the items in a given category. Here's where the professionals will hopefully come in, how and where do I add the

p2c.sort_id into /includes/index_filters/default_filter.php so that my category will sort by this field and not the sort id field located in the products table.

Thanks

There is a mod to provide multiple sort options in the categories which may be of interest:
http://www.zen-cart.com/showthread.php?205606-Product-Listing-Sorter-Drop-Down

This is the closest subject title I could find for posting my question about product listing and sorting.

How can I add an option to the "Sort By" drop down select in the products_all, products_new, and featured products listing pages?

I've made the changes to Admin/Config files like this:

Configuration key = PRODUCT_ALL_LIST_SORT_DEFAULT
Added: 9= Weight (Free Shipping)" to configuration description
Changed set_function to zen_cfg_select_option(array('1', '2', '3', '4', '5', '6', '7', '8', '9'),
Added an option to line 35 in tpl_modules_listing_display_order.php: <option value="9" <?php echo ($disp_order == '9' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_WEIGHT; ?></option>

EDIT INFO: Oh, I also updated the languages file to include TEXT_INFO_SORT_BY_PRODUCTS_WEIGHT = Free Shipping (Weight).

With that being done, I am able to see the new option in the drop down for all 3 listings. However, it is not sorting by WEIGHT. (Zero weight is what determines my free shipping).

I tried using adding &sort_4a to the link address (while in all products) to see if it would work like the category product listing but that did not work. Category product listings use &sort_#a whereas these other 3 listings use disp_order=#.

I used the developers tools to try and find where disp_order is defined but I can't find anything.

So, what code do I need to change to make this work?

Thanks in advance.