You can do it by setting up a view of product line items, adding both the product and order relationships, filtering by order state, turning on aggregation, grouping by Product ID and summing on the line item's quantity field.
Updated to add an attachment. Import the text of that file as a view, and you'll get a report of the number sold at admin/commerce/product_sales.
Comments
What do you mean by "the
What do you mean by "the number of sold" ?
Do you want to show the number of products sold on the site for visitors, or do you want administrators to be able to see this ?
hi, I want to display the
hi,
I want to display the info like what groupon or livingsocial does. Each product have info about the number of sold for each product.
Nobody can help on this?
Nobody can help on this?
You can do it by setting up a
You can do it by setting up a view of product line items, adding both the product and order relationships, filtering by order state, turning on aggregation, grouping by Product ID and summing on the line item's quantity field.
Updated to add an attachment. Import the text of that file as a view, and you'll get a report of the number sold at admin/commerce/product_sales.
THANKS!! your attached
THANKS!! your attached example really help me alot!
nice! is it possible to use
nice! is it possible to use this as a field?
Export?
That sounds like exactly what I need, too. Could you post your views export here?
Thanks,
Stephan
Attachment disappeared
It seems that the attachment is not available anymore?
I would like to see it too.
I would like to see it too.
I didn't understand what you
I didn't understand what you meant over there. And I don't see any attachment. Could you help?
Attachment missing
The views attachment is no longer available