Magento热销产品(BestSeller Products)的核心SQL语句

取热销产品的前10名。

select order_items.product_id,
       sum(order_items.qty_ordered) as ordered_qty
  from sales_flat_order_item as order_items
          inner join sales_flat_order as `order`
    on `order`.entity_id = order_items.order_id and `order`.state <> 'canceled'
 where (order_items.parent_item_id is null)
 group by order_items.product_id having sum(order_items.qty_ordered) > 0
 order by ordered_qty desc limit 10

相关话题：

• Magento BestSeller Products
• Magento 热销产品
• sales_flat_order_item
• sales_flat_order