Article HFN - Classer par marque et référence les produits dans le BL et la facture Prestashop - https://hotfirenet.com/blog/2689-classer-par-marque-et-reference-les-produits-dans-le-bl-et-la-facture-prestasop/

OrderInvoice.php

<?php 
class OrderInvoice extends OrderInvoiceCore { 
    public function getProductsDetail() { 
        return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(' SELECT od.*, p.*, ps.* 
            FROM `'._DB_PREFIX_.'order_detail` od 
                LEFT JOIN `'._DB_PREFIX_.'product` p ON p.id_product = od.product_id 
                LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (ps.id_product = p.id_product AND ps.id_shop = od.id_shop) 
                LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer`= p.`id_manufacturer`
            WHERE od.`id_order` = '.(int)$this->id_order.' 
                AND od.`id_order_invoice` = '.(int)$this->id .' 
            ORDER BY m.name, p.reference'); 
    } 
}