Delivered products monthly statistics

[ken12345]

I desperately need a module that can give me statistics (quantities only) of all delivered products (not ordered, but delivered!!!) for the last month.

 

Can anyone recommend me anything? All I could find myself was only for sales financial statistics. I dont need that atm.

 

Thank you!

[RyanSmith]

I desperately need a module that can give me statistics (quantities only) of all delivered products (not ordered, but delivered!!!) for the last month.

 

Can anyone recommend me anything? All I could find myself was only for sales financial statistics. I dont need that atm.

 

Thank you!

<{POST_SNAPBACK}>

 

 

Create a report using a SQL statement like

 

SELECT * FROM orders where orders_status = 3;

 

If you know SQL you will be able to get out any data you want, if you don't know SQL it's time to learn. The basics really aren't that hard.

[RyanSmith]

Also if you want the orders from a given date try

 

SELECT * FROM orders WHERE orders_status = 3 AND date_purchased > '2005-01-12';

 

You may have to join some tables if you want more data such as products attributes.

 

If you just want the quantity then try something like:

 

SELECT sum(products_quantity) FROM orders_products, orders WHERE orders_products.orders_id = orders.orders_id AND orders.orders_status = 3 AND date_purchased > '2005-01-12';

 

That should give you a quantity of products delivered