Sales Report Via Sql Query Help

[eugeneworldwide]

Hi,

 

due to Presta not having a strong reporting kit for product sales, i am trying to create a simple single sales report that shows products sold within a period. This is a simple table to export and prep in Excel further. All the info is in Presta already.

 

I am struggling with SQL and not to clued up on the database structure of Presta.

 

Can anyone advise of an existing query I can use or alternatively just help me create one.

 

The basic report is to choose your dates, Start and end, or even all order as i can filter it in Excel.

Fields must start with products, and then contain info similar to the Orders grid in Presta.

 

Thus fields are simply:

Product name/code

Customer

Total amount

Payment

Status

Date

 

I hope someone can help.

 

Thanks