cancel
Showing results for 
Search instead for 
Did you mean: 

Creating Specific Sales Reports

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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.

3 REPLIES 3

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'