• Resolved MykolaSenechyn

    (@mykolasenechyn)


    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 FROM wp_woocommerce_order_itemmeta
    GROUP BY order_item_id,product_id,quantity

    This 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.