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.
Adam
shared this idea
We’ve started the development of a new report for product variations ????
The new reports are being developed in a feature plugin, that’s currently in Alpha. You can view all the details here – https://github.com/woocommerce/wc-admin
We’d love anyone who’s expressed interest to follow the project along.
50 comments
-
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?
-
Kosta
commented
This feature is STILL missing
-
Guy
commented
Same here. I have a couple of products with 10 variations each. Right now I have to manually go over all orders to figure out how much each variation sold. I was already disappointed with the general uselessness and lack of flexibility in WooCommerce reports, and the completely absence of it for this otherwise useful plugin.
-
Anonymous
commented
Bit late but just wanted to share that you can do this with my app Metorik - https://metorik.com/blog/better-reports-for-woocommerce-product-variations :)
-
Pablo
commented
Must have default report!
-
Anna
commented
I purchased three! plug-ins already and none of them provide reports sorted by variation/payment gateway at the same time which I absolutely need for tax purposes. Would really appreciate advice...
-
J R
commented
It's absolutely absurd that there is no core support for reports by product variation. Variations are supported out-of-the-box, and the only way you allow any useful reporting is through paid plugins? Ridiculous.
This should have been an included feature since product variations were included in the product.
-
Joe
commented
I would love to see this. We offer books in physical and digital form. It would be great to see in a report which is preforming better.
-
Anonymous
commented
Our developer created a bunch of custom CSV exports for us, which a) don't blow up the Woo data cache, and b) provide multiple lines per order, one item per order. That allows easy Excel manipulation.