Getting reports for all orders

src

2006-10-25 19:18

Has anyone come up with a way to print out a report of all orders from the admin area? Right now I can see a summary of orders showing name and date of order, but I'd like something with a bit more detail.

It would be nice if we could sort by Customer or Product etc, and group the various items together. What I was thinking of is something like:

Product Name
Attribute 1
Attribute 2
order 1 name qty price
order 2 name qty price
Attribute 3
order 3 name qty price
order 4 name qty price
subtotal
subtotal
Total

I'm using QCL 1.4 and so am using the Order Statistics plugin, which seems part the way there, but doesn't give any quantities, just percentages.

Or maybe there's a way to open the DB files in Excel and simulate the report above? Anything that could give a summary of the sales for a month-end report or something like that.

Thanks!

src

2006-10-25 19:20

Posting stripped my indents. Not sure if this is easier to visualize:

src

2006-11-01 00:29

I see that Excel has an option to Data > Import External Data. You can then link the DB files into Excel and work with them there. The data is essentially live (you can choose how often to update).

Anyone thinking about trying this?