X-Cart forums

[amy2203]

Is there a way to change the sort order of the packing slip?

It would be much easier for us to pick.pack if it was sorted by SKU. It seems quite random at the moment

[cflsystems]

I think the default sorting is by item id which is the order products were added to cart. So it is not random but yes makes no sense most of the time.
It could be also product title, can't remember.


You will have to modify the way items are selected within the order and set sorting by whatever you need it to be. It will be a sql query either in func.order.php or func.product.php
But you need to find the starting point that calls the "select orders" for the packing slip.

[amy2203]

the packing slip is difficult as it's not a page in the browser to investigate

[amy2203]

I'm still struggling with this, I can't even find func.order.php or func.product.php!

[Ed B.]

I would take a look into /skins/admin/order/packing_slip/parts/body/items.twig classes/XLite/View/PackingSlip.php (these are the files responsible for outputting packing slips) and classes/Model/Repo/Order.php, classes/Model/Repo/Product.php (these are the places where the details of sorting are defined), and maybe classes/Model/Order.php classes/Model/Product.php (these classes should contain sorting methods). Well, I know, this is kind of lots of places to look...

[Ed B.]

OK, here is something that might be more useful. the twig file gives

  {% for index, item in this.orderItems %}
  <tr>{{ widget_list('packing_slip.item', item=item) }}</tr>
  {% endfor %}

And, it doesn't seem that the array $this->getOrderItems() is given any specific sorting order (maybe I have simply been unable to spot the place where it is done). So basically it is your sql server orders that fetches order items by ascending order of product id (which is logic since that is the index column). So I guess you can either decorate the function getOrderItems() in the view class, or you can use php array sorting function to sort the array $this->getOrderItems() once fed to the twig file.