I am facing a problem, in store front end, when I click on any category and short it by timestamp and sort order desc (modified sorting code), it never shows newest product first, infect it shows old products first (migrated from CS 1.3 SP1).
After many hit and try, when I checked database, noticed that timestamp filed contains 0, that was causing products to be displayed at end.
to trace, I have created one product by simply clicking on “Add product” option under products menu. checked database entry in cscart_products table, it was showing timestamp value, and product was coming in sorting result at front end too
now i have used bulk product addition option and added 2 products, checked database entry and timestamp value was 0. So it is not saving timestamp value in bulk addition, that cause incorrect result at front end on sorting, all new products are are visible at last page and old products are visible at top. we have 800 products in one category,and 100 products a page, so new products are visible on 8th page.
Tested it on cs-cart 2.2.3 (a bit customized) and fresh installation of cs-cart 2.2.4, error is on both versions. So I am doing anything wrong is it really a error?
Got reply from cs-team, as per them this is not a bug, “working as designed”,
[quote][color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]Please let me explain. The value for timestamp setting is not created automatically, it is taken from the “Creation date” field of the product. This field is located in the “Availability” section of the product details page in the administration panel.[/size][/font][/color]
[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]If you use “Add product” feature, the field is automatically filled in with the current date.[/size][/font][/color]
[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]But this field is not used in the “Bulk product addition” functionality and default value (0) is saved to the database for the created product. So, in this case in order to set this value, you need to open the desired product in the administrator panel and fill in the “Creation date” field with the necessary value.[/size][/font][/color][/quote]
got temp solution, now after creating products using bulk product addition, i need to use bulk edit tool to apply a creation date for recently created products. Because when we edit any individual product that is recently added using bulk product addition option, it shows creation date as empty field and don;t save current time on updation, and it easy to skip this option while editing a product.