Product Sort Order

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

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

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 :smile:

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?

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?

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 ...

It's when visitors are viewing the products be category that the problem occurs Ajeh e.g.

http://www.divatoys.com/index.php?main_page=index&cPath=72_134_135

These pages always appear in aphabetical order rather than Date Added as chosen in Configuration > All Listing > Default Sort Order

First, that is not the All Listing ... that is the Index Listing ...

As such, the Date field is not even used in this listing so it would need to have the code customized ...

I once wrote this up on how to do the customization of the Index Listing to use Sort Orders not originally designed for this ...

It may be awhile before I find that or someone else happens to recall where I did that ...

Or ... perhaps someone would like to redo all of the work to make this happen, as it can be custom coded ...

Ah well, looks like I'll have to leave it as it is for now then. Thanks for trying to help Ajeh.

Patrick

Hello, I'm new here and with the Zen cart, I would like my products appear on store in descending order according to when they were added at the store but did not understand very well what has been explained, someone could tell me Where can I find the database (product data)?

Thanks,
Drika

By default, the Product Listing does not have an option for the default display order to be by date as there is already a New Products listing that has that available ...

You would need to custom code this option as a method of default display ...

Could you tell me how can I do that?
If some instruction in the record book of Zen Cart would be great because I already bought the book.

Thanks,
Drika

I would have to sit down and write all of the code for making the products_date_added work as a default setting for the Product Listing ...

You can look at how this is managed in the:
/includes/index_filters/default_filter.php

The sorting for the default is set around the section that starts with:

// set the default sort order setting from the Admin when not defined by customer

Hello Ajeh, thank you for your help, I put it the way I wanted. :clap:

Drika

Thanks for the update that this was able to help you sort the products in a different manner on the default sort order ...

Drika:

Hello Ajeh, thank you for your help, I put it the way I wanted. :clap:

Drika

I've been trying to do this without success for ages. Please could you let us know what it was that you did?

Thanks
Patrick