Orders by items sold

BigCommerce

 

BigCommerce is the leading e-commerce platform for running an online store.

A summary of all items sold for the selected date range

Query Text

SELECT OrderProducts.ProductId, OrderProducts.Sku, OrderProducts.Name, COUNT(OrderProducts.OrderId) AS Orders, SUM(OrderProducts.Quantity) AS "Unit Sold", SUM(OrderProducts.TotalIncTax) AS Revenue
  FROM OrderProducts
LEFT OUTER JOIN Orders AS OrderProducts_Orders ON OrderProducts.OrderId = OrderProducts_Orders.id
WHERE (OrderProducts_Orders.Status != 'Cancelled' AND OrderProducts_Orders.Status != 'Refunded' AND date(date(OrderProducts_Orders.DateCreated), 'start of month') = date('now', 'localtime', 'start of month'))
GROUP BY OrderProducts.ProductId, OrderProducts.Sku, OrderProducts.Name
ORDER BY OrderProducts.Name
  

Open Query