Sort products by Newest first tried everything still not working
I have been trying to get sort by newest product, to work on my system for days and I cannot get it to work. I am on EE 1.12 and my site doesn’t use flat product data. I have tried a whole bunch of ways to try to get this to work. I always can get the sort option to show up in the sort by drop down, but it seems to order the products by entity_id. This would be fine but it is always ascending, so oldest first, and won't reverse the direction like it will on the other sort by options.
The programming approach:
I have tried to use suggestions from stack overflow and had no luck. After trying their solutions if I put chickens in instead created_at I still get the same result. Note: I was re-indexing after my attempts. My issue seems to be that the sort doesn't have access to the created_at field on the products.
The Database approach:
I reset all my code and tried looking into the database. I found the created_at product attribute in eav_attribute and matched it with the attribute_id in the catalog_eav_attribute table. I tried setting used_for_sort_by to 1 and some other combinations, like set is_visible and is_searchable to 1, while re-indexing after each change and got the same results. Appears in drop down, but doesn’t reverse, displays as oldest first, with no reverse.
I found a note online that said that the created_at attribute data should be in the catalog_product_entity_datetime table all that’s in mine is is news_from_date and news_to_date rows and these were all are null. Can anyone confirm that the create_at values should be in catalog_product_entity_datetime. If so how can I get them from the products into this table?
2. Any other suggestions on things to look at or ways to test what the query is using in the Order By?