How to Display Products Sorted by Data Added

Maybe I am just dumb or something, but I couldn't figure out how to sort products by date they were added?

Note that I disable displaying date to customer-end. In other words, customers cannot see when a product is added. However, in the MySQL database, all values in the Date column are properly entered.

Under Configuration - ALL Listings - Display Product Display - Default Sort Order
1= Products Name
2= Products Name Desc
3= Price low to high, Products Name
4= Price high to low, Products Name
5= Model
6= Date Added desc
7= Date Added
8= Product Sort Order

I put in 6, didn't work. 6a didn't work, either.

Under Configuration - Product Listings
Display Product Listing Default Sort Order
doesn't work, either

6= Date Added desc
7= Date Added

One of those two should be the order that you want ...

What version of Zen Cart are you running?

**v 1.3.6

putting in 6 or 7 both don't work
**

Have you an URL that we could peek at?

Hi, I am running it from localhost. Not available for preview.

Normally how do you sort products by date added and display them to customers?
where and which option do you use?

To sort the All Products listing by date you edit the:
Configuration ... All Listing ...

and select the radiobutton for 6 Date Added Descending

I'm having the exact same problem. I'm also using 1.3.6.

A good example of it not working can be found here: http://bishiharem.com/index.php?main_page=index&cPath=15_16

Thanks!

The Product Listing does not have a products_date_added sort to it ...

Only the fields in the listing can be used for the Sort Order ...

You would have to customize quite a bit of code to add the date ...

Note: the New Products, Featured Products and All Products do have a sort by date and the ability to default the sort order to that ...

Can you clarify for me when we see Product Listing versus All Listings? I have a client who wants to sort the manufacturer's product listings by date added, descending and says it was that way before we upgraded her from 1.3.1 to 1.3.7.

Thanks!

The Product Listing is used when you navigate a Category, as in get to the list via the cat box ... or when you do a search ...

There are, however, two different sections of code managing the select statement as one is performing a listing where as the other is performing a search ...

Okay, I have a client who says she used to be able to sort the items by date added when a manufacturer was chosen from the Drop Down Box. She said it was done in the Product Listing screen where she had 5a chosen as sort order, but she says now that we've upgraded to 1.3.7, it's not working. Does that make sense? If so, can I fix it?

Thanks, Linda!

It seems that no matter what I enter in that box, they are sorted alphabetically by the name of the item.

How about an URL where we can see this ... :smile:

Sure thing :)

http://www.daisiecompany.com/cart/index.php?main_page=index&manufacturers_id=6&sort=5&page=1

What is 5a suppose to represent?

I see up to 4 ...

NOTE: the products_price_sorter is not up to date ...

Make sure that your products all have master_categories_id settings ...

There is a reset in the Tools ... Store Manager ...

NOTE: if you need to reset your master_categories_id this sets it based on the first one found in the products_to_categories table ...

If the master_categories_id is not set, this should be run first ... then the products_price_sorter can be run ...

I like to think I know my way around Zen pretty well, Linda, but you just went straight over my head.

As for the first question, I thought earlier in your post, you listed up to 8...didn't you?

Each column represents a number ...

That number alters based on the order but is limited to the number of columns ...

If you have 4 columns then you should have 4 values ...

If Model was the 2nd column it would be 2 ... but if you rearrange the order and Modle is 3rd column it is now 3 ...

If you had 5 columns you would have 1 to 5 that could be used ...

But if you use 5 in the sort order then remove column 2 then 5 becomes 4 ... if you removed column 5 then not only is there no 5 there is nothing to match 5 in the sort ...

What do you "think" the default sort was suppose to be based on? Click on that title until sorted the right way ... what is its sort= in the URL?

This is the new Default sort order value ... easy, eh? :blink:

Note the settings in the first post were based on the dropdown for New, Featured and All listing ...

You said your problem was with the Product Listing ... this is the one from navigating the Categories sidebox or doing searches or picking a manufactuer, record company or music genre ...