How can we improve WooCommerce?

← WooCommerce

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.

319 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Adam shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

54 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Danny commented  ·   ·  Flag as inappropriate

    I really dont understand how this is not a thing. For this and only this reason, I am switching from Woocommerce to something else.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Charissa commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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??

  • Nar Sim commented  ·   ·  Flag as inappropriate

    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.

    https://www.crawlspider.com/woocommerce-reports

  • Chris Mundy commented  ·   ·  Flag as inappropriate

    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

  • Anonymous commented  ·   ·  Flag as inappropriate

    Quite strange that this is not part of woocommerce already, there seem to be enough people that need it, myself included.

  • Michael - ExecuServices commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    is there a valid plugin that can generate detailed sales reports with product variations?

  • Anonymous commented  ·   ·  Flag as inappropriate

    Running a report by product variation is inventory management 101...how can this still be missing from woo commerce reports?

  • Guy commented  ·   ·  Flag as inappropriate

    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.

← Previous 1 3

WooCommerce: Category - Core

Categories

Feedback and Knowledge Base

(thinking…)