Can't Find How To Print Simple 2015 Activity Reports

[mudshark]

Need to do taxes and need to see some reports for 2015:

 

sales,

fees

sold inventory cost

 

etc 

 

How do I get to the reports screen?

 

Thx

RG

[tuk66]

You can export all records from the ps_order_detail table as CSV.

 

You can also print all orders as a tax report - one example is at http://www.presta-addons.com/pdf/Tax report.pdf

[mudshark]

I knew there had to be a way! 

So, how do I "export all records from the ps_order_detail table as CSV"?

Thanks,

RG

[tuk66]

Using this SQL query in Advanced Parameters > SQL Manager:

SELECT * FROM ps_order_detail;

[mudshark]

That's almost it..  Still that output does not include the shipping cost or order date for each item...

I am really surprised there is not a canned report function for sales for previous x days or months!