Jump to content

Add more details in "product sales"


Recommended Posts

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,



Link to comment
Share on other sites



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.



  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...