Add more details in "product sales"

[warzoux]

Hello everybody !

I use prestashop to sell workshop tickets (virtual product) then I have to merge two informations to get who buy this product, and what is his name. (to check when people comes to the workshop)

 

I would like to know how can I replace in "the product detail sale" the column "Customer" (which is an ID) by the real client name ?

 

 

Thank you in advance,

Sébastien
 

[elenzel]

Hi,

 

You can solve this issue making a view / query on the database joining the sales and customer table like this:

 

select s.*, a.firstname, a.lastname

from ps_orders s

join ps_customer a

on s.id_customer =  a.id_customer

 

Probably you will need some other orders tables to get the orders details......

 

Hope you find this info useful.

 

Regards