Sort items by model name on the order page.

[RepGard]

When I go to admin/customers/orders and then choose an order and then edit it or click invoice, I would like it to sort the items by the module name. I can't seem to sort them by anything nor does it appear to be sorted in any specific order.

How would I make it display the model name in apha numeric order?

[Ajeh]

You can customize the order class in the Admin around line 115 and change the order by to use the module:

      $orders_products = $db->Execute("select orders_products_id, products_id, products_name, products_model,
                                              products_price, products_tax, products_quantity,
                                              final_price, onetime_charges,
                                              product_is_free
                                       from " . TABLE_ORDERS_PRODUCTS . "
                                       where orders_id = '" . (int)$order_id . "'
                                       order by orders_products_id");

try using:

      $orders_products = $db->Execute("select orders_products_id, products_id, products_name, products_model,
                                              products_price, products_tax, products_quantity,
                                              final_price, onetime_charges,
                                              product_is_free
                                       from " . TABLE_ORDERS_PRODUCTS . "
                                       where orders_id = '" . (int)$order_id . "'
                                       order by products_model, orders_products_id");

and see if that gives the results that you are looking for ...

[RepGard]

In the admin? Do you mean admin.php?

[RepGard]

I went to admin/orders.php and did not find this code. I am using zencart version 1.3.9g. What file am I supposed to change?

[Ajeh]

This is in the order class file in:
/your_secret_admin_dir/includes/classes/order.php

[RepGard]

That appears to have done the trick. THANK YOU.