How to sort products by model number in shopping cart and on invoice

[14Steve14]

I asked this question many years ago when I was updating my current store but the code has changed since then and the old way of doing it no longer seems to work.

We sort similar products in the same area of the store room, so when we use the invoice or packing slip as a picking list it saves time to have the products listed on the invoice and packing slips in model number order. I think last time it ewas decided to save the items in the basket in the correct order, that then showed them in the right order on the invoice/packing slip.

Before I had to create a new copy of the shopping cart file which is now in includes/versioned/1.0.8.7/shopping_cart.php and add to that file. That now produces a blank page.

What would be the best way to sort the products in the shopping basket, packing slip and invoice by model number?

[burt]

I've had a quick glance at the code and can see where to make a change so the Admin side works as you want, but I am not able to find a hook call that would be suitable. In the meantime, until someone else can find a hook (and write the hook)...or someone finds a different solution;

Make a copy of;
/includes/system/versioned/1.0.7.10/database_order_builder.php

To (note that you might need to create the override folder and that it has nothing to do with the override tmplate);
/includes/system/override/database_order_builder.php

Change L119 in that NEW file to:

Code: Select all

$order_products_query = $GLOBALS['db']->query("SELECT * FROM orders_products WHERE orders_id = " . (int)$this->order->get_id() . " ORDER BY products_model");

Save. Invoice and Packing Slip should now be ordered by model.

-

Note that if someone comes up with a better solution that does not involve overriding the database_order_builder file, all you need to do is delete that NEW database_order_builder.php file and you are back to normal. Then follow their instructions to a better solution.

[14Steve14]

Thanks @burt Gary. Works like a charm with the test products so hopefully should be alright when there are more items in an order.

Another change ticked off the very long list.

[ecartz]

until someone else can find a hook

Code: Select all

      $GLOBALS['all_hooks']->cat('constructOrder', $this);

https://github.com/CE-PhoenixCart/Phoen ... 1C1-L31C59

Something like

Code: Select all

public function listen_constructOrder($order) {
  usort($order->products, function ($a, $b) { return $a['model'] <=> $b['model']; });
}

But if you want the products sorted in the cart, that should also sort in the order for future products. You can sort the cart with any hook that runs before the display.

[burt]

I missed that Hook. So to test it, try (and note that I have not tested this);

1. Delete that new override file you made.

2.
New File:
/includes/hooks/admin/siteWide/sortProducts.php

Content:

Code: Select all

class hook_admin_siteWide_sortProducts {
  
  public function listen_constructOrder($order) {
    usort($order->products, function ($a, $b) { return $a['model'] <=> $b['model']; });
  }

}

As it's sitewide that Hook should work for both invoice and packingslip.
Be sure to check for unwanted gremlins elsewhere - if any appear let us know.

[14Steve14]

This hook seems to work as expected. Not found anything wrong elsewhere yet.