Report of Products Ordered

Report of Products Ordered

Hi

Is there a function to report on the products ordered. Ie I would like to select a product (or all products) and then get a list of how many of that has been ordered and by whom.

And perhaps a dashboard showing how many orders for each product

I'm happy to write it myself accessing the database but wanted to check if there was something there already

Thanks for a great product

Aw: Report of Products Ordered

Hi,

I'm basically looking to see if this exists within the software:

SELECT oi.product_name, oi.product_quantity, o.`order_id` , o.`f_name` , o.`l_name` , o.`email` , o.`order_add_info`
FROM `joom_jshopping_orders` AS o, `joom_jshopping_order_item` AS oi
WHERE o.order_id = oi.order_id
AND o.order_status =6
ORDER BY oi.product_id

Aw: Report of Products Ordered

I support any endeavour to make the statistics better. The free version is very downplayed and "rustic" on the verge of useless.