How to export sales data into Excel

Hi,

There are 3 things you can do:
- For the VAT, if you go in the menu System>Taxes and click on the "manage tax rates" you can find the sales and tax amount for each tax rate and filter by order status and dates. There is also an export button.
So it should be easy like this to get the tax numbers you need. That's what I would recommend using.
- Regarding product sales, the reports system should still be able to do that. The configuration of reports though is a bit cluncky so it's not easy to get right for what you need.
- Alternatively to reports, you should be able to do the same with mass actions. You can use filters for the dates and order statuses, and then use an action "export CSV file" to get the data from the orders. We've added a while back an option to be able have one product line per order for each row instead of one order for each row.