X-Cart forums - Sort order on order

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - Sort order on order_data.tpl (https://forum.x-cart.com/showthread.php?t=61524)

Sort order on order_data.tpl

I'd like to sort my products alphabetically in the invoice that gets emailed out

Is this possible in 4.1.8? I am looking at order_data.tpl

Thanks

Re: Sort order on order_data.tpl

Yes, but you should modify the "include/func/func.order.php" script "func_order_data" function.

Replace this code fragment:

PHP Code:


		
			
$products = func_query("SELECT $sql_tbl[order_details].itemid, $sql_tbl[products].*, $sql_tbl[order_details].*, IF($sql_tbl[products].productid IS NULL, 'Y', '') as is_deleted, IF($sql_tbl[order_details].product = '', $sql_tbl[products].product, $sql_tbl[order_details].product) as product $fields FROM $sql_tbl[order_details] LEFT JOIN $sql_tbl[products] ON $sql_tbl[order_details].productid = $sql_tbl[products].productid $join WHERE $sql_tbl[order_details].orderid='$orderid'");

with this one:

PHP Code:


		
			
$products = func_query("SELECT $sql_tbl[order_details].itemid, $sql_tbl[products].*, $sql_tbl[order_details].*, IF($sql_tbl[products].productid IS NULL, 'Y', '') as is_deleted, IF($sql_tbl[order_details].product = '', $sql_tbl[products].product, $sql_tbl[order_details].product) as product $fields FROM $sql_tbl[order_details] LEFT JOIN $sql_tbl[products] ON $sql_tbl[order_details].productid = $sql_tbl[products].productid $join WHERE $sql_tbl[order_details].orderid='$orderid' ORDER BY $sql_tbl[products].product");

Note: the products sort order will be changed in all the places where this function is used.

Re: Sort order on order_data.tpl

Is there a way to order it alphabetically also by category?
Thanks Alex!

Re: Sort order on order_data.tpl

Yes, you should alter the same function and change the SQL query.
I suppose it will slow down the query, depending on the category number in the store.

Re: Sort order on order_data.tpl

Is there a way to sort by SKU?

Re: Sort order on order_data.tpl

Yes, sure. You should change the order by statement in SQL to productcode:

PHP Code:


		
			
$products = func_query("SELECT $sql_tbl[order_details].itemid, $sql_tbl[products].*, $sql_tbl[order_details].*, IF($sql_tbl[products].productid IS NULL, 'Y', '') as is_deleted, IF($sql_tbl[order_details].product = '', $sql_tbl[products].product, $sql_tbl[order_details].product) as product $fields FROM $sql_tbl[order_details] LEFT JOIN $sql_tbl[products] ON $sql_tbl[order_details].productid = $sql_tbl[products].productid $join WHERE $sql_tbl[order_details].orderid='$orderid' ORDER BY $sql_tbl[products].productcode");

Re: Sort order on order_data.tpl

Perfect, thanks for your help.