steverobbins/magento-best-sellers.sql

Last active August 1, 2018 10:34

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/steverobbins/a448f4a05ba59a7b8597.js"></script>
Save steverobbins/a448f4a05ba59a7b8597 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

magento-best-sellers.sql

	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 commented Aug 1, 2018 •

edited

Loading

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