Category

[sarawakian]

HI, How can I set the listing in a particular category by newest first and then older on the last page.

the default for listing on oscommerce is oldest on page 1 (when you hit the a particular catergory) , I check product listing in admin, doesn't seem like there is an option to switch.

[Guest]

So far from what I know, there isn't an easy way to do this. The product listing is pulled via code from a MySQL database. It works like a queue, first in, first out. You could go into the product listing code and change the loop around.

[Mary B.]

The query that retrieves the category listing from the database will display them in the categories box based on the sort order. You can change the sort order by editing the category in your admin area.

[sarawakian]

thank you all, it is not the category which I need to sort, but rather the listing inside each category. I need the newest listing to appear on the first page when someone click on specific category.

imagine if you have a website selling movies, and in category "action movie", you have 500 listing of action movie, when a user click on that category, they should see the newest listing of action movie in the website, rather then the oldest which I list about 5 years ago, and then they have to keep clicking next to get to newer movies

[Geotex]

You might want to check out this contribution.

 

http://www.oscommerce.com/community/contri...h,products+sort