How to modify the random sorting of new zencart products

Because the number of new products may be more than the number displayed on the page, it is displayed randomly. If you want to display the data in chronological order, you can modify it according to the method provided by radnows. (Remember to use file substitution) Step 1 of the method for modifying the random sorting of new zencart products: First, you can define the time period for new products: shop settings-maximum value-new product definitions

Step 2 of the method for modifying the random sorting of new zencart products:
Modify the new product on the home page:
/Shortdes/modules/new_products.php

Add the corresponding order by xxx in $ new_products_query.

Example: select distinct p. products_id, p. products_image, p. products_tax_class_id, pd. products_name, p. products_date_added, p. products_price, p. products_type, p. master_categories_id fromzen_products p, zen_products_description pd where p. products_id = pd. products_id and pd. required age_id = '1' and p. products_status = 1 order by pd. products_name

Step 3 of the method for modifying the random sorting of new zencart products:
Modify the new product in the border:
/Shortdes/modules/sideboxes/whats_new.php
Set
$ Random_whats_new_sidebox_product = zen_random_select ($ random_whats_new_sidebox_product_query );
Change
$ Random_whats_new_sidebox_product = $ db-> Execute ($ random_whats_new_sidebox_product_query );

Step 4 of the method for modifying the random sorting of new zencart products:

Then, in the/shortdes/modules/new_products.php file:
$ Db-> ExecuteRandomMulti
Change
$ Db-> Execute

MoveNextRandom ()
Change
MoveNext ()