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

Custom Search

Search the entire web

Custom Search