Full service web hosting, great prices and support. Starts at $1.99/month!
Results 1 to 4 of 4

Thread: Sort by Reference

  1. #1
    Results
    Guest


    Question Sort by Reference

    I have looked here, Wiki, and the manual, BUT might be blind as I can not find the answer.

    I have a number of products that appear in sequence in the back office, but online appear in a different order.

    Mono Printer Toners : Better Cartridges

    Tk-17, Tk-18 TK-19 etc in order, yet TK-144 appears first.

    I may get around it by renaming Tk-017 etc but my customers would be confused.

    Any simple answers?

    Thanks in advance!

    Bruce

  2. #2
    osCMax Development Team

    Sort by Reference

    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    4,164
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    ridexbuilder     $ 15.00
    Rep Power
    99


    Lightbulb Re: Sort by Reference

    Non-simple answer:

    The order in which products are displayed in the admin/database are of no consequence as to how they are displayed to the end-user. It is the SQL query on the data that determines the sort order.

    If you set Product Listing|Product Display Type to 0 in Admin, you'll notice that there is an option to sort by Product Name or Price. This is done via a change to the sort order in the SQL query. You could have an additional column with Product Reference and a suitable query to sort by that column. So, in Admin, Product Listing, select an appropriate display order (including Product Model) to allow sorting by that column.

    Notice: Case is important, also model numbers should have the same number of digits for the sort to be consistent. Example CLK-TK-17 should be CLK-TK-017, if you are using a maximum of 3 numerical designators. Product name could remain as is, to avoid possible confusion?

    EJ
    Last edited by ridexbuilder; 06-01-2010 at 12:11 AM.

    Developers resource at bitbucket
    *** *** ***
    oscmax.co.uk / ejsolutions.co.uk
    Hosting plans with installation, configuration, contributions, support and maintenance.
    *** FREE osCmax hosting available ***
    oscmaxtemplates.com

  3. #3
    Results
    Guest


    Default Re: Sort by Reference

    Thanks for the prompt repy!

    Will try your sugestion.

    Thanks Again.
    Bruce

  4. #4
    Results
    Guest


    Default Re: Sort by Reference

    All working well now.

    Thanks again for the help.
    Bruce

Similar Threads

  1. Reference Attributes
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 11-26-2008, 03:00 PM
  2. Reference Attributes
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 10-20-2008, 04:00 AM
  3. Reference Attributes
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 07-04-2008, 04:43 PM
  4. Reference Attributes
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 07-03-2008, 04:31 AM
  5. Reference Attributes
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 07-02-2008, 01:22 PM

Bookmarks

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
  •