cancel
Showing results for 
Search instead for 
Did you mean: 

Creating Specific Sales Reports

Creating Specific Sales Reports

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.

Tags (1)
3 REPLIES

Re: Creating Specific Sales Reports

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

Re: Creating Specific Sales Reports

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

Re: Creating Specific Sales Reports

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'