Sorting products in categories

[yellowaircraft]

Hi there,
I've been reading posts for some time now. They are really helpful. Thanks for that.

I am opening a web based stamp store with Zen-Cart.

http://www.sariucak.com/store/

I installed it a couple of days ago. I played with the appearance a little. Installed some add ons. Now I am quite happy with the results.
But I have 1 question for you guys.

This is one of my categories: http://www.sariucak.com/store/index....ndex&cPath=1_2
the problem when you lok at it is that the sorting. As you see First item is "Scott 111" then 113 and then comes "Scott 14". Same thing happens with the items in 20s & 200s, 30s & 300s. How can I make this sorting starting from the lowest number?

Thanks in advance
Cenk

[gjh42]

The easiest way to make them sort in alpha/numerical order would be to make all the numbers three digit, beginning with 0 where appropriate. E.G. Scott 015, Scott 123, etc.

Modifying the sorting code would be a custom job for an expert PHP coder.

As I see an item named Scott 2055a, you may need to use four digits for the numbers to get total consistency.

[yellowaircraft]

The easiest way to make them sort in alpha/numerical order would be to make all the numbers three digit, beginning with 0 where appropriate. E.G. Scott 015, Scott 123, etc.

Modifying the sorting code would be a custom job for an expert PHP coder.

As I see an item named Scott 2055a, you may need to use four digits for the numbers to get total consistency.

Thanks for the reply gjh42.
I thought about that but these numbers are Special Stamp Catalogue numbers & I need them to be exactly as per the catalogue so the customer can find it out in that catologue they own,

[Ajeh]

If you set a Sort Order on the Products ... and then set the default Sort Order for the Product Listing to blank, for display by Sort Order ... does that fix the display?

[gjh42]

If all of the products (or all of them in any given category) will have a Scott number, that should do the job. Assign the Scott number as the sort order (if there is a ### and a ###a, those should fall into alphabetical order even though they have the same sort order).

[yellowaircraft]

If you set a Sort Order on the Products ... and then set the default Sort Order for the Product Listing to blank, for display by Sort Order ... does that fix the display?

If all of the products (or all of them in any given category) will have a Scott number, that should do the job. Assign the Scott number as the sort order (if there is a ### and a ###a, those should fall into alphabetical order even though they have the same sort order).

Thanks again for the reply guys.
If we're talking about Configuration/Product Listing/Display Product Listing Sort Order
It was blank already by default. I put the word "Scott" but no luck.

By the way gjh42 yes all items start with "Scott" then a number. eg

Scott 123, Or Scott B12, or Scott 1234a

Thanks
Cenk

[gjh42]

Then give all of the products a numerical sort order equal to their Scott number.
This is not a text field but a number (presumably integer) field.

If the number can start with a letter like Scott B12, you will have to figure out where in the sort order that kind of number would go. Is it related to 12, or related to B?

[yellowaircraft]

Then give all of the products a numerical sort order equal to their Scott number.
This is not a text field but a number (presumably integer) field.

Can you please describe this a little detailed ?

If the number can start with a letter like Scott B12, you will have to figure out where in the sort order that kind of number would go. Is it related to 12, or related to B?

It is related to letter "B". Products Start with letters should come after products start with numbers. eg: My last item with numbers is "Scott 2765" Then I continue with "Scott B1" & so on

Thanks Cenk

[gjh42]

What's to detail? Scott 2765 gets sort order 2765. Scott 1234a gets order 1234, and it will fall almost if not precisely in order with Scott 1234 and Scott 1235 when displayed. Since the sort order number is not displayed to the customer, the letters can all be translated into numbers starting with 10000 for A. Scott B1 could have sort order 20001, Scott B23 gets 20023, Scott C1 gets 30001, Scott K1 gets 110001, etc.

[yellowaircraft]

What's to detail? Scott 2765 gets sort order 2765. Scott 1234a gets order 1234, and it will fall almost if not precisely in order with Scott 1234 and Scott 1235 when displayed. Since the sort order number is not displayed to the customer, the letters can all be translated into numbers starting with 10000 for A. Scott B1 could have sort order 20001, Scott B23 gets 20023, Scott C1 gets 30001, Scott K1 gets 110001, etc.

Never mind. :) I was asking where the sort order is.:) Anyways I found it. It looks OK now. Thanks gjh42