X-Cart forums

[mcpilot]

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

[qualiteam]

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.

[masada3336]

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

[qualiteam]

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.

[nmartin]

Is there a way to sort by SKU?

[qualiteam]

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"); 


[nmartin]

Perfect, thanks for your help.