osCmax v2.5 User Manual
Results 1 to 5 of 5

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

This is a discussion on Sort Order for Products (not just categories/subcategories)? within the osCmax v2 Customization/Mods forums, part of the osCmax v2.0 Forums category; Does anyone know of a contrib that gives a sort order field and initial sort order display to products and ...

      
  1. #1
    Member
    Join Date
    May 2005
    Posts
    43
    Rep Power
    0


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

    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

  2. #2
    Member
    Join Date
    Feb 2007
    Posts
    31
    Rep Power
    0


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

    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.
    Last edited by Autoegocrat; 06-15-2007 at 08:29 AM. Reason: Afterthoughts

  3. #3
    Member
    Join Date
    Feb 2007
    Posts
    31
    Rep Power
    0


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

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

  4. #4
    New Member
    Join Date
    Nov 2004
    Posts
    10
    Rep Power
    0


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

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

  5. #5
    Member
    Join Date
    Feb 2007
    Posts
    31
    Rep Power
    0


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

    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.

Similar Threads

  1. categories and subcategories
    By Lara Croft in forum osCmax v2 Customization/Mods
    Replies: 7
    Last Post: 01-05-2007, 07:25 AM
  2. Change sort order on new products
    By Lord in forum osCommerce 2.2 Modification Help
    Replies: 2
    Last Post: 03-23-2005, 02:05 AM
  3. Categories and SubCategories as Boxes
    By w424637 in forum osCommerce 2.2 Modification Help
    Replies: 1
    Last Post: 11-11-2004, 08:13 AM
  4. Categories with other Subcategories and Products
    By ReginaStelling in forum osCommerce 2.2 Modification Help
    Replies: 3
    Last Post: 07-29-2004, 06:17 PM
  5. Setting Sort Order for Products?
    By sheikyerbouti in forum osCommerce 2.2 Installation Help
    Replies: 6
    Last Post: 11-12-2003, 10:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •