Best selling products in current month



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

Best selling products (along with total revenue per product) in current month

Query Text

SELECT OrderProducts."Name" AS "Product", SUM(OrderProducts."Quantity") AS "Number Sold", SUM(OrderProducts."TotalIncTax") AS "Revenue"
  FROM "OrderProducts"
INNER 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."Name"

Open Query