StoreFront Ecommerce News for FrontPage & Dreamweaver
Press CTRL+D to Bookmark StoreFrontGoodies.com
Click Here to sign up for our Monthly Newsletter.

| Home | New Forum! | StoreFront 6 | StoreFront 6 Add Ons | Search Engine Optimization | Essential Tools | StoreFront 5 | StoreFront 2000 | SFG Partners | Participate | Suggestion Box | Security |

home > storefront 2000 > storefront 2000 knowledge base

| StoreFront 2000 Knowledge Base |


Changing the Order of the Search Results in StoreFront 2000
 

Posted Friday, April 23, 2004

Merchants who make use of the StoreFront Search Engine in their web stores may at times wish to change the way that the results of a search are organized. By default, the search results are ordered by Product ID in descending order.

To change the criteria the search results are organized by, open search_results.asp ( this file is located in the root of the web) in NotePad. Around line 95 are the following lines:

& "AND ((" & CATEGORY & ") AND (" & MANUFACTURER & ")) " _

& "AND (INVSWITCH = '1' AND INV <> '0' OR INVSWITCH = '0')) " _

& "ORDER BY PRODUCT_ID DESC "

End If

To order the search results by Product ID ascending, change this line as follows:

& "ORDER BY PRODUCT_ID ASC"

Search results can also be organized by other criteria than the product ID, such as product Description. To order the search results by the product Description, change this line as follows:

& "ORDER BY DESCRIPTION DESC "

As with any customization, test as you proceed and make backups of your files.

Browse more...
StoreFront 2000 Knowledge Base