Creating Specific Sales Reports

[ugk1990]

How could I create CSV file for  total sales report for a year which shows these i.e (Name, sku, qty sold) of a specific manufacturer.

Thanks.

[ugk1990]

LOL, It is done now.
Inform me if anyone needs the solution now

[ac12]

Hi

How did you do this?

I'm on Enterprise Edition, and I want to run a report that shows me my sales by product/SKU by time period.

I would have thought this is a very basic, standard report to run (what products are my best sellers?) but I cannot for the life of me figure out how to do it within Magento.

Any help appreciated

Cheers

[ugk1990]

Run this following query in your database, Adjust the dates accordingly.

SELECT sku, name, qty_ordered, `sales_flat_order_item`.created_at
FROM `sales_flat_order_item`
JOIN `sales_flat_order` ON `sales_flat_order_item`.order_id = `sales_flat_order`.entity_id
WHERE `sales_flat_order`.status = 'complete'
AND `sales_flat_order`.created_at > '2014-1-1 00:00:00'
AND `sales_flat_order`.created_at < '2015-1-1 00:00:00'