Packing Sheet Product Display Order

[bigpedro]

Have a client who would like to display the products on the packing sheet in numerical order sorted by the product code.

 

Does anybody have any idea how I would do this?  I assume it would be in the templates/print.receipt file?

[bsmither]

There are two ways to do this:

Modify the query used to pull the items for an order to sort the resulting recordset.

Build a complex Smarty plugin function as a modifier to sort the array of items that was given to the template engine.

 

In the admin file /sources/orders.index.inc.php, at around line 423, find:

if (($inventory = $GLOBALS['db']->select('CubeCart_order_inventory', false, array('cart_order_id' => $summary['cart_order_id']))) !== false) {

add the new part:

if (($inventory = $GLOBALS['db']->select('CubeCart_order_inventory', false, array('cart_order_id' => $summary['cart_order_id']), array('product_code'=>'ASC'))) !== false) {

 

There is no single PHP function that will sort an array based on the k^th-dimension value. So we will skip that effort.