Sort on Reference number in admin Order

[Hans Wolf]

Prestashop 1.7.7.2

How can you set this up so it is sorted by Reference number?
It is a multishop

Edited March 18, 2021 by Hans Wolf (see edit history)

[Hans Wolf]

52 minutes ago, ndiaga said:

Hi,

If  you  are talking  about  ordered  products  then  you  should  do it  in the  code.

Do you also know how to do that. I have now adjusted this(see photo). But how should you sort by Reference?

[Guest]

./classes/order/OrderDetail.php

find:

public static function getList($id_order)
    {
        return Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'order_detail` WHERE `id_order` = ' . (int) $id_order);
    }

replace to:

public static function getList($id_order)
    {
        return Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'order_detail` WHERE `id_order` = ' . (int) $id_order.' ORDER BY product_reference ASC');
    }

 

[Hans Wolf]

15 hours ago, Guest said:

./classes/order/OrderDetail.php

find:

public static function getList($id_order)
    {
        return Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'order_detail` WHERE `id_order` = ' . (int) $id_order);
    }

replace to:

public static function getList($id_order)
    {
        return Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'order_detail` WHERE `id_order` = ' . (int) $id_order.' ORDER BY product_reference ASC');
    }

 

have now adjusted this (see photo) and deleted the cache on the server but it remains the same. It just doesn't want to sort by Product reference. What is going wrong
What I forgot to mention that it is a multishop

[Hans Wolf]

What I forgot to mention that it is a multishop

[Guest]

And isn't it by chance OrderDetail.php already rewritten in ./override / ....?

[Hans Wolf]

1 hour ago, Guest said:

And isn't it by chance OrderDetail.php already rewritten in ./override / ....?

No this is not there. It only says Order.php for the order reference number

[adlmr]

May be this would help you? 😁