Nar Sim

My feedback

  1. 297 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    47 comments  ·  WooCommerce » Category - Core  ·  Flag idea as inappropriate…  ·  Admin →
    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.

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

  2. 7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    needs research  ·  3 comments  ·  WooCommerce » Category - Core  ·  Flag idea as inappropriate…  ·  Admin →
    Nar Sim commented  · 

    Is this asking to record all customer queries on the ecommerce site and report on that?

    Or

    Is it asking for admin dashboard feature where you can search by SKU and get reports?

  3. 119 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Nar Sim commented  · 

    I believe this can be part of wordpress admin or infocaptor custom reports. I am not fond of pie charts but KPI style reporting should work too

  4. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Nar Sim shared this idea  · 

Feedback and Knowledge Base