enable sales reports broken down by variation for each product.
Sales reports by product are fine for simple products, but for people with lots of variations that effect price, or manage their own stock counts, having reports that show how many of each variation were sold is very important.

We shipped a brand new product variations report in WooCommerce 4.8, so I’m going to close this idea.
https://developer.woocommerce.com/2020/12/08/woocommerce-4-8-is-now-available/
58 comments
-
Tommy Hansen commented
Hi, this plugin has sales reports for variations: https://woocommerce.com/products/calculate-your-price-for-woocommerce/
-
Anonymous commented
This plugin works well and gives the reports per variations https://imaginate-solutions.com/downloads/woocommerce-variations-reports/
-
Anonymous commented
Really don't know how this is happening. but i am shifting from this..
http://fescobill.com/ -
Chrisko commented
Product Sales Report Pro does a good job of Variation Reporting
-
Danny commented
I really dont understand how this is not a thing. For this and only this reason, I am switching from Woocommerce to something else.
-
Natalka80 commented
Is this function happening anytime soon?
-
Anonymous commented
Any update on this ability? In November 2018 it was in Alpha, surely it's gotten to Beta and beyond by now. This is something that is really needed by shop owners/managers.
-
Anonymous commented
Is there any update? How hard can this actually be?
-
Charissa commented
I really need this feature for my clients, I'm considering moving them to an entirely different platform since every product they sell is a variation of a parent product and there is NO decent or quick way to filter them in the WC dashboard.
-
Anonymous commented
When can we expect reporting to show individual product variations sold, like a T-shirt product where you can see the qty of each variation sold?
-
John commented
how can a shopping cart not do sales reports with product variations... a report that says you sold 10-TeeShirt A is basic BUT it also needs to report 2 - TeeShirtA - BLK - LG ; 5 - TeeShirtA - WHT - XL ; 3 TeeShirtA - BLK - MD. is there a reason this is a problem??
-
Jesus commented
Any update on this?
-
Nar Sim commented
Here is a sample SQL for fetching the product and variation id
SELECT
`woi`.`order_item_name` AS `order_item_name`,
`woi`.`order_item_type` AS `order_item_type`,
`woi`.`order_id` AS `order_id`,
`woim`.`order_item_id` AS `order_item_id`,
MAX((CASE
WHEN (`woim`.`meta_key` = '_product_id') THEN `woim`.`meta_value`
ELSE NULL
END)) AS `product_id`,
MAX((CASE
WHEN (`woim`.`meta_key` = '_variation_id') THEN `woim`.`meta_value`
ELSE NULL
END)) AS `variation_id`,
MAX((CASE
WHEN (`woim`.`meta_key` = '_qty') THEN `woim`.`meta_value`
ELSE NULL
END)) AS `qty`,
.....
....
FROM
(`wp_woocommerce_order_itemmeta` `woim`
JOIN `wp_woocommerce_order_items` `woi`)
WHERE
(`woim`.`order_item_id` = `woi`.`order_item_id`)This is not the complete SQL but just to provide idea.
-
Chris Mundy commented
I have a client who needs this ASAP. They would like a report on Product Variations and Sales Dates and include the details of the variations, e.g. they have size and colour for their product lines
-
Kevin Nguyen commented
We also need to filter by tag
-
Phil Donaldson commented
Any progress to report?
My clients are screaming at me for this. -
Anonymous commented
Quite strange that this is not part of woocommerce already, there seem to be enough people that need it, myself included.
-
Michael - ExecuServices commented
I'm shocked that this doesn't exist... Makes me have to rethink what I recommend to my ecommerce clients... Guess I'm back to Magento and drupal commerce. Ugh
-
Jennifer commented
is there a valid plugin that can generate detailed sales reports with product variations?
-
Anonymous commented
Running a report by product variation is inventory management 101...how can this still be missing from woo commerce reports?