Kbase P136265: How do I create customized sort orders for products in select categories?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/10/2008 |
|
Status: Unverified
GOAL:
How do I create customized sort orders for products in specific categories?
GOAL:
How can I sort products in one category differently than in another category?
GOAL:
How can I sort products by a column that is not part of the product result set?
FACT(s) (Environment):
EasyAsk 9.7
EasyAsk 10.1
FIX:
The result set of a search is returned in the default sort order. This default sort order is defined in the dictionary and can be changed using Commerce Studio tabs Merchandising/Display/Products. The sort order can be changed for the entire category structure, a subset of the category structure or for a single category. All the columns in the Data Query are available to use for sorting. The sort can also be changed for a single search by specifying &defsortcols in a http request or a thin client program.
For example:
http://localhost:9100/EasyAsk/apps/Advisor.jsp?dct=ecomdemo&disp=html&indexed=1&oneshot=1&ResultsPerPage=25&RequestAction=advisor
&RequestData=CA_Search&CatPath=All+Products&defsortcols=Price,t,Description,f&q=red shoes
will sort the results by Price ascending and then Description descending. If, however, you want to determine the specific order that products are returned independent of the Data Query columns, you can define your own sequence. Modify the category query to include this new sequence number which you have defined and built into your database.
For example:
Category_Query: list Product Id, category number,sequence number
and then rebuild your index and reload on the server. Now if you go to Commerce Studio tab Merchandising/Display/Products, in addition to all the Data Query columns available to sort by, there will also be EACategorySequence to choose for sorting. This option will appear for any category for which sequence numbers have been added to the index.