Skip to content

Instantly share code, notes, and snippets.

@steverobbins
Last active August 1, 2018 10:34
Show Gist options
  • Save steverobbins/a448f4a05ba59a7b8597 to your computer and use it in GitHub Desktop.
Save steverobbins/a448f4a05ba59a7b8597 to your computer and use it in GitHub Desktop.
select sfoi.sku, sum(sfoi.qty_ordered) sold, sum(sfoi.base_price) dollaramount
from sales_flat_order_item sfoi
group by sfoi.sku
order by sold desc
@Jeeva-Rathinam
Copy link

Jeeva-Rathinam commented Aug 1, 2018

How can i get Level 2 Category wise Top Seling Products Report by MYSQL Query?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment