Sort Order for Products (not just categories/subcategories)?

[argentbeads]

Does anyone know of a contrib that gives a sort order field and initial sort order display to products and not just to categories and subcategories?

I did a search on sort order and saw the AJAX and ACA contribs highlighted, but I was hoping someone knew more than I could read in the contrib description.

I have several categories of products where there are similar products, with the variation between being a number: for example, "silver bead 4 mm" or "silver bead 20 mm". With the default alphabetic sortation on the product name, the "silver bead 20 mm" sorts ahead of "silver bead 4 mm". I'd like to be able to sort from small to large or from large to small without some weird product naming.

Thanks in advance.

Paul
OhioBeads.com - Bulk Jewelry Chain, Jewelry Making Supplies, Clasps, Toggles, Findings, Filigrees : Welcome to OhioBeads.com
argentbeads

[Autoegocrat]

This is something I would have liked to be included in osCommerce/osCMax as well, and something I am currently working on myself.

There is a good thread (which is unfortunately locked, so I am posting here) concerning product sorting here, and I have used this information to switch to sort by model number.

I cannot sort by product name because the names cannot be changed to suit a proper sort order.

My issues:

I have only added model numbers for sorting purpose, which I guess is a roundabout way of doing things, but it works. I do not want the model number to be displayed on the catalog, and even though I have set model number display = 0, it still shows up. Now the breadcrumb trail shows top>>catalog>>(category)>>(model number) and also has kind of defeated the purpose of seo urls for each specific product.

My question is, how do I fix this so that seo urls work properly, the breadcrumb trail shows the product name, and the model number does not show up in the product listing even though I have it turned off? Am I going about this the wrong way?

Thanks!

Auto

PS - Sorry for thread hijacking, and this thread should be located in customization/mods.

[Autoegocrat]

Solved...added a new field to the database called priority for sorting.

[Asgoroth]

Could you be a bit more specific about the fix?
Where did you add this data field?
Any other additions/changes?

[Autoegocrat]

Insert a new field into the "products" table in your database called "priority" or whatever you want, enter your desired values into that field, and use that for your sort order.