Magento: Get daily sales order counts
This simple MySQL query gets the daily order counts from Magento in Jan 2014.
SELECT DATE(created_at) AS DATE, count(DATE(created_at)) AS order_count FROM sales_flat_order WHERE created_at BETWEEN '2014-01-01' AND '2014-02-01' GROUP BY DATE(created_at);
Search within Codexpedia
Search the entire web