Number of large shirts sold
-
Is there a way of seeing how many items where sold in a certain size for a product?
I’ve looked around can’t seem to find anything, I also tried to make a sql query however my SQL skills are too sharp.
Any help is appreciated or just a point in the right direction.
Thanks.
P.S. This the query I came up with,
SELECT
order_item_id
,
IF(meta_key=’_product_id’, meta_value, NULL) AS product_id,
IF(meta_key=’_qty’, meta_value, NULL) AS quantity FROMwp_woocommerce_order_itemmeta
GROUP BYorder_item_id
,product_id,quantityThis will return the relevant data however it’s in separate rows.
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘Number of large shirts sold’ is closed to new replies.