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.
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
Run this following query in your database, Adjust the dates accordingly.
SELECT sku, name, qty_ordered, `sales_flat_order_item`.created_at
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'