Ordered products total

This message was sent from: Suggestions and Proposals
http://forums.oscommerce.com/viewtopic.php?p=199540#199540
----------------------------------------------------------------

Hi all,

I was looking for a admin module, that count the number of products ordered from orders with status 'pending'.

So that after a day i can print out a page with all the product that are ordered that day so i can fax it to my distibuter ...

So i don't have to print out all orders and sum all the product up manually ...

If there is not such a module, can someone tell me in which DB Table i have to look for the ordered quantities, product code and the status of orders.

Best regards,
Onno.