Report of Products Ordered

17.11.2013 13:24
#1
hpurdey
Joomshopping forum user no avatar
Name: Hamish
19.10.2013
Posts: 3
Quote
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

 
17.11.2013 13:36
#2
hpurdey
Joomshopping forum user no avatar
Name: Hamish
19.10.2013
Posts: 3
Quote
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

 
27.11.2013 16:50
#3
Stella
Joomshopping forum user no avatar
Name: Stella
24.03.2011
Posts: 42
Quote
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.

 
Copyrights MAXXmarketing GmbH. All Rights Reserved