I've tried it on my version 4.0.17. There is no such file as include/func/func.products.php as indicated:
Quote:
Edit $xcart_dir/include/func/func.product.php
FIND (approx line 363):
$fields[] = "$sql_tbl[products].productcode";
$fields[] = "$sql_tbl[products].avail";
Add AFTER:
// newproducts .. needed for quantity to work on newproducts module
$fields[] = "$sql_tbl[products].min_amount";
|
So I located /include/func.php and added red line:
#
# Generate products availability condition
#
if ($config["General"]["unlimited_products"]=="N" && (($current_area == "C" || $current_area == "B") && $config["General"]["disable_outofstock_products"] == "Y"))
$avail_condition = " AND $sql_tbl[products].avail>0 ";
else
$avail_condition = "";
$select_query = "SELECT $sql_tbl[products].productid, $sql_tbl[products].product, $sql_tbl[products].productcode,
$sql_tbl[products].avail, $sql_tbl[products].min_amount, MIN($sql_tbl[pricing].price) AS price";
I followed all other installation instructions, which seem universal to x-cart then opened /newproducts.php url in browser to see what would return and the newest products page was blank nothing delivered.
I cannot figure out what is missing to have a query and get of new product data. Not ready to upgrade store to latest version as it is actively patronized in current state and can't afford to be down for maintenance for longer than a couple of hours. Any coding ideas?