Product Sort Order

[PGlad]

Hi Folks

In 'Configuration > All Listing > Display Product Display - Default Sort Order' I can apparently set my product listing to Date Added or Date Added Desc. But when I try this or any other option it has no affect. Can anyone help me understand why this is please? I want all products to display by Date Added Desc.

Thanks

[fairestcape]

Does your database (product data) contain values in the Date Added field(s)? Or are they empty?

[PGlad]

Aha the fields are empty, that explains a lot. I presumed that the date field would have been automatically filled when products were inserted but obviously not!

Thanks for that

[PGlad]

I'm a bit puzzled as to what has gone wrong here not being an expert on MySQL. Here are the fields from the database:

Field: products_date_added
Type: DATETIME
Length/Values:
Collation:
Attributes:
Null: not null
Default: 0001-01-01 00:00:00
Extra:
Comments:

Can anyone see what I've done wrong please?

[Ajeh]

How are you adding your Products?

Are you manually adding them via the Zen Cart Admin with the Add feature? Or, are you importing them?

[PGlad]

The products are being added manually through Admin. I've realised though that whatever sort method I choose in Configuration > All Listing is ignored?