List of products sold with customers who bought them

[kerrywales]

Hi all,

 

I may be using the wrong keywords in my search but in essence:

I have a product with a finite number being sold e.g. 800

 

At any point I would like to know:

1. How many of that product sold

2. List the customers who have bought that product and the quantity purchased

 

I am using prestashop cloud (so it's 1.6) using the default template

 

I can see all sorts of stats but nothing that would be able to get me what I want.

 

Can anyone advise please.

[kerrywales]

The site is on the PrestaShop Cloud.

 

I need to have a list of customers buying a product (the product to be selected).

 

PrestaCloud is showing version 1.6.1.0

 

I am surprised it is not in the standard product. I don't mind if this report is in a Module (but I cannot find one using my search terms(, of if someone can provide me with instruction how to set it up on my shop, or if someone can do it for me (message me what you would charge).

 

I am guessing a simple SQL call would do it, if I knew the structure.

 

Any help gratefully received.