[Magento SQL] 获取每个客户历史总计订单数量和金额

最新推荐文章于 2021-11-25 16:23:03 发布

原创最新推荐文章于 2021-11-25 16:23:03 发布 · 1.9k 阅读

1 ·

CC 4.0 BY-SA版权

Magento 专栏收录该内容

133 篇文章

订阅专栏

本文介绍了一种使用SQL查询来统计已完成订单的数量及总金额的方法。通过联接`sales_flat_order_grid`和`customer_entity`表，并筛选出状态为已完成的订单，按客户ID分组以获取每位客户的订单总数及总金额。

SELECT customer_id,email,SUM(grand_total) AS total_amount,COUNT(*) AS orders_num FROM sales_flat_order_grid
LEFT JOIN customer_entity  ON customer_entity.entity_id = sales_flat_order_grid.customer_id
WHERE `status`='complete' AND customer_id IS NOT NULL
GROUP BY customer_id
ORDER BY orders_num DESC