- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Creating Specific Sales Reports
LOL, It is done now.
Inform me if anyone needs the solution now
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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'