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![]()
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![]()
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?
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?
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
The products are being added manually through Admin. I've realised though that whatever sort method I choose in Configuration > All Listing is ignored?
The Sort Order on the All Listing only applies to the All Products Listing ...
There are many custom Sort Orders available ...
What is the URL to what isn't sorting properly?
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
What I want is to have the default setting for all listed products to be in date order descending, but nothing I do changes the current setting of alphabetical ordering.
The URL is www.divatoys.com
Thanks
Patrick
If you mean on the home page, from what I am seeing you have all random displays of the centerboxes ...
If you mean on a given URL ... please let me know what URL you are not in order on ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!