Jump to content

Edit History

monicaamb

monicaamb

10 minutes ago, prestashopfree.com said:

Hi,
I would like to help you, but it is still not clear to me what you need.
There can be multiple products in the order, so there would be multiple lines in the CSV with the same id and order reference. The order detail is in the order_detal table and there is also the name + attributes of the purchased product.

Thank you for the reply.

What I would like is to export somehow the orders with the product or product the client has bought. 

I realised I can do that by making a query in the DB but the columns of SKU and TITLE OF THE PRODUCT didn't appear. So I already put the column of the SKU although I don't khow how is going to show if the client buy more than one product in an order. On the other hand I am looking for the query to obtain the title of the product.

monicaamb

monicaamb

6 minutes ago, prestashopfree.com said:

Hi,
I would like to help you, but it is still not clear to me what you need.
There can be multiple products in the order, so there would be multiple lines in the CSV with the same id and order reference. The order detail is in the order_detal table and there is also the name + attributes of the purchased product.

Thank you for the reply.

What I would like is to export some how the orders with the product or product the client has bought. 

I realised I can do that making a query in the DB but the columns of SKU and TITLE OF THE PRODUCT didn't appear. So I already put the column of the SKU although I don't how is going to show if the client buy more than one product in an order. On the other hand I am looking for the query to obtain the title of the product.

×
×
  • Create New...