X-Cart forums

[cotc2001]

Ok this is probably something i've overlooked.

But is there a way with products_t.php to display the items with a higher productID first ???

for example productID 234,235,236 will display before 127,126,125 ???

Reason being is that those with a higher productID will always be newer products so i would want those to be displayed first.

[TelaFirma]

Ok, here is a quick little mod that will do that for you. This will give you a checkbox in Admin (in Appearance Options, right under the Display Order dropdown) that will allow you to check if you want the listing in revere order or not, and it will also change the "Default" order method to ProductID.

Open products.php and look for the lines:

if(!isset($sort))
	$sort = $config["Appearance"]["products_order"];
if(!isset($sort_direction))

Right under this add this code:

{
if ($config["Appearance"]["product_order_reversed"] == "Y") {
    $sort_direction = 1;
} else {
    $sort_direction = 0;}
}

Open /include/search.php and look for this block of code:

		# Sort the search results...

		$direction = ($data["sort_direction"] ? "DESC" : "ASC");
		switch ($data["sort_field"]) {
			case "productcode":
				$sort_string = "$sql_tbl[products].productcode $direction";
				break;
			case "title":
				$sort_string = "$sql_tbl[products].product $direction";
				break;
			case "orderby":
				$sort_string = "$sql_tbl[products_categories].orderby $direction";
				break;
			case "quantity":
				$sort_string = "$sql_tbl[products].avail $direction";
				break;
			case "price":
				if (!empty($active_modules["Special_Offers"]) && !empty($search_data["products"]["show_special_prices"])) {
					$sort_string = "x_special_price $direction, price $direction";
				}
				else {
					$sort_string = "price $direction";
				}
				break;
			default:
				$sort_string = "$sql_tbl[products].product";
		}

and replace the line

				$sort_string = "$sql_tbl[products].product";

with

				$sort_string = "$sql_tbl[products].productid";

Run this SQL patch in the Patch/Upgrade section

INSERT INTO `xcart_config` VALUES ('product_order_reversed', 'List products in reversed order', 'Y', 'Appearance', 100, 'checkbox', 'Y');

[cotc2001]

K thanks that worked a treat

[TelaFirma]

Great!

[CobaltCat]

I need something like this for 4.1.6. Anybody know of a way?

[david_ygao]

It works for me, but I have to change after following line:
case "title":