Ascending Dynamic Products

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   OK, I need to find out how to change the order of the products on the dynamic list pages.  Currently it's based on product number (order in which products were entered into the database), but we need it to be alphabetical instead.  I assumed that it would involve creating a new list query in the database, but since the original arrangement is not based on any queries, I don't think that will work.  

Thanks in advance to anyone who can tell me the steps necessary in this process!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Monomni Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: May/06/04 Status: Offline Points: 18	Post Options Post Reply Quote Monomni Report Post Thanks(0) Quote Reply Topic: Ascending Dynamic Products Posted: May/12/04 at 9:31pm
	OK, I need to find out how to change the order of the products on the dynamic list pages. Currently it's based on product number (order in which products were entered into the database), but we need it to be alphabetical instead. I assumed that it would involve creating a new list query in the database, but since the original arrangement is not based on any queries, I don't think that will work. Thanks in advance to anyone who can tell me the steps necessary in this process!

Monomni Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: May/06/04 Status: Offline Points: 18	Post Options Post Reply Quote Monomni Report Post Thanks(0) Quote Reply Posted: May/15/04 at 8:16am
	Never mind. I decided to just add an "Order by" sort to the SQL tag, and it worked without having to create a new query list. :^)