peterberkenbosch/count_complete_orders_by_sku.rb

Created August 12, 2014 20:39

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

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

Download ZIP

Count number of sold products

Raw

count_complete_orders_by_sku.rb

Spree::LineItem.joins(:variant).merge(Spree::Variant.where(sku: "ROR-00011")).joins(:order).merge(Spree::Order.where(state: 'complete')).count

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