The first step to modify the random ordering of new products in zencart : First, new products can define their own time period: Store Settings - Maximum Value - Definition of New Products
The second step of modifying the random ordering of zencart's new products :
Modify the new products on the homepage:
/includes/modules/new_products.php
In $new_products_query Add the corresponding ORDER BY xxx
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.language_id = '1' and p.products_status = 1order by pd.products_name
The third step of the random sorting modification method of zencart new products:
Modify the new products in the border:
/includes/modules/sideboxes/whats_new.php
Change
$random_whats_new_sidebox_product =zen_random_select($random_whats_new_sidebox_product_query);
to
$ random_whats_new_sidebox_product =$db->Execute($random_whats_new_sidebox_product_query);
Step 4 of the random sorting modification method of zencart new products :
Then /includes/modules /new_products.php file:
$db->ExecuteRandomMulti
changed to
$db->Execute
MoveNextRandom()
changed to
MoveNext( )