How to modify the random order of new products in zen cart

The first step to modify the random ordering of new products in zencart: First, you can define the time period for new products: Store Settings - Maximum Value - Definition of New Products

Randomization of new products in zencart The second step of the sorting modification method:
Modify the new products on the homepage:
/includes/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. language_id = '1' and p.products_status = 1order by pd.products_name

The third step of modifying the random ordering of new products in zencart:
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);

zencart Step 4 of the random order modification method for new products:

Then change the /includes/modules /new_products.php file:
$db->ExecuteRandomMulti
to
$db->Execute

MoveNextRandom()
Changed to
MoveNext()

For more related articles on how to modify the random order of new zen cart products, please pay attention to PHP Chinese website!