[SOLVED] How to show customer name using first name in Admin order list

[cayrol272]

Hi,

 

I'm still new using prestashop. Attached picture was an order list on Admin side. My problem is customer's names show second name instead first name. It give me difficult to look for my customer because in my country we address people using first name.  

 

Could someone help me, how to show customer name using first name? Which template should I looking for? or I need to modify controller?

 

Thank you.

[NemoPS]

You have to edit AdminOrdersController.php

 

At line 45, you'll find part of a query

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

Change it to

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

[cayrol272]

It great! That had solved my problem.

 

Thank you nemo1.

[vekia]

I marked this thread as [sOLVED]

@cayrol272 you can also mark own threads as solved, here is the instruction:

 

 

 

[sOLVED] Topic
If, after posting a topic, you find a solution to your problem, please indicate it in your post and describe the solution.
Furthermore if you are the author of the topic for which a solution has been found, please edit your topic title to mark it as [sOLVED].

To mark a topic as [solved] :
- Edit the first post of your topic by clicking on the "Edit" button,
- Click on the "Use full editor" button,
- Add the "[solved]" string at the beginning of your topic title and click on the "Submit Modified Post" button.

 

 

btw. welcome on board!

[Liliana M]

Hi Guys, 

 

I need your help  

 

How I can show the full costumer name in Admin order list. I'm using P.S. 1.6.0.11

 

Thank you very much. 

 

Liliana

[NemoPS]

Change the following line

 

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

 

to

 

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

 

In AdminOrdersController.php

[Liliana M]

Hi Nemo1,

 

It worked. Thank you very much. 

[subaru4wd]

Thank you for this fix!!!    I can't believe prestashop hides customer information...   do you have any idea how many L. Garcia, and J. Martinez there are that live in california and order from us???  

 

This will help a lot!

[marketingphenom]

Change the following line

 

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

 

to

 

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

 

In AdminOrdersController.php

 

I'm using ps version 1.5.6.2. I tried using this suggestion but it did not change anything. Hoping to be able to display the complete first and last name. Any ideas why it didn't work?

[NemoPS]

You might have an override then, that has to work if you modify the core file

[nikmagnus]

Thanks for this, it works for me in PS 1.6.1.4

[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.

[razvan.socolov]

Hi!

Please, help me to solve this situation:

I need to swap firstname with lastname on customer details, because we send the orders directly on our billing program, and the rule is that lastname to be the first.

Ex. Doe John, NOT John Doe. 

Contry template is Lastname / Firstname.

Thank you!!!