How to show products in order list

[zimmer-media]

copy your AdminOrdersController.php from /controllers/admin to the folder /override/controllers/admin/

After changing you can see the ordered products with variants on order list. Don´t forget to clear the cache!

change this os.`color`, IF((SELECT so.id_order FROM `'._DB_PREFIX_.'orders` so WHERE so.id_customer = a.id_customer AND so.id_order < a.id_order LIMIT 1) > 0, 0, 1) as new, country_lang.name as cname,

to os.`color`, (SELECT GROUP_CONCAT(odd.product_name SEPARATOR ", ") FROM `'._DB_PREFIX_.'order_detail` odd WHERE odd.id_order = a.id_order) as products, IF((SELECT so.id_order FROM `'._DB_PREFIX_.'orders` so WHERE so.id_customer = a.id_customer AND so.id_order < a.id_order LIMIT 1) > 0, 0, 1) as new, country_lang.name as cname,

and change this $this->fields_list = array_merge( $this->fields_list, [ 'total_paid_tax_incl' => [ 'title' => $this->l('Total'), 'align' => 'text-right', 'type' => 'price', 'currency' => true, 'callback' => 'setOrderCurrency', 'badge_success' => true, ], 'payment' => [ 'title' => $this->l('Payment'), ],

to ``` $this->fieldslist = arraymerge( $this->fieldslist, [ 'totalpaidtaxincl' => [ 'title' => $this->l('Total'), 'align' => 'text-right', 'type' => 'price', 'currency' => true, 'callback' => 'setOrderCurrency', 'badgesuccess' => true, ], 'products' => [ 'title' => $this->l('Products'), 'havingFilter' => true, 'filterkey' => 'products',

        ],
            'payment'             => [
                'title' => $this->l('Payment'),
            ],

```

---

before

---

after changing

[israelans]

How beautiful! Congratulations @zimmer-media

Is there a way to create a line break between products when there is more than one product per purchase?

[indigo2018]

@israelans : here I found many useful information

[wakabayashi]

@israelans Maybe you can try SEPARATOR '\n'

[israelans]

@wakabayashi I've already tried putting ‘\n’. I have this doubt since I used Prestashop: /