How to display full first and last name in orders list

[massycroft]

Hi,

I need to make display full first name and full last name in the 'Customer' column present in the section Orders>Orders. Currently, as default it shows me abbreviated first name and full last name, e.g.= M. Jackson instead of Michael Jackson.

 

How can I do to get it?

 

Thank you very much in advance.

Max.

 

[massycroft]

Solved, line 62 in controllers/admin/AdminOrdersController.php has to be rewrite as follows:

 

CONCAT(c.`firstname`, \' \', c.`lastname`) AS `customer`,

 

[Adeko.nl]

Hi Massycroft,

 

You need to edit AdminOrdersController.php to accomplish this.

This file can be found in controllers -> admin -> AdminOrdersController.php

 

Change:

CONCAT(LEFT(c.`firstname`, 1), \'. \', c.`lastname`) AS `customer`,

to:

CONCAT(c.`firstname`, \' \', c.`lastname`) AS `customer`,

Don't forget to empty your cache under Advanced parameters -> Performance.

[meclarn]

Just a follow up on this thread.

In Prestashop v. 1.6.1.18. I had to make the changes to both AdminOrdersController.php and AdminOutstandingController.php in order for this to work.

[N N]

Thank you. It was useful to me.

[CyberPepe]

Is working at PS 1.7.6.5 but I changed both files with this code, because an error occurred and a dot needed to be removed:

CONCAT(LEFT(c.`firstname`, 10), \' \', c.`lastname`) AS `customer`,

 

[safa]

Hello,

just a note for 1.7.7.x

search a lot time for find this almost all admin files chanced

src/Core/Grid/Query/OrderQueryBuilder.php

find

    private function getCustomerField()
    {
        return 'CONCAT(LEFT(cu.`firstname`, 1), \'. \', cu.`lastname`)';
    }

replace

    private function getCustomerField()
    {
        return 'CONCAT(cu.`firstname`, \'  \', cu.`lastname`)';
    }

bests...

[Skafander]

Hello, solution of @safa works in 1.7.7.x but you are unable to search by full name and surname. Does anyone have a clue how to get it work?

[pShark]

On 5/20/2022 at 1:04 PM, Skafander said:

Hello, solution of @safa works in 1.7.7.x but you are unable to search by full name and surname. Does anyone have a clue how to get it work?

I agree with the question, does anyone know how to make it searchable by firstname as well?

[pShark]

That solutions works for me, editing getCustomerField function, thanks all!!

[tayfun476]

On 6/9/2021 at 4:38 AM, safa said:

Hello,

just a note for 1.7.7.x

search a lot time for find this almost all admin files chanced

src/Core/Grid/Query/OrderQueryBuilder.php

find

   Hi,

 

In the getCustomerField() method, I have modified the CONCAT function to limit the lastname field to 20 characters using the LEFT() function. This change ensures that long customer names won't affect your list by cutting off the displayed name to a specified character count.