Skip to main content

How to config report?

7 years 8 months ago #304071 by kyratn
How to config report? was created by kyratn
Hi,

We use legacy dashboard and would like to have some sale report from one category only. Seems we can't configure it...
Report generates nothing but we are sure that we have some product sales from that category this month.

Any advise?


  • Please Log in or Create an account to join the conversation.

    7 years 8 months ago - 7 years 8 months ago #304119 by Philip
    Replied by Philip on topic How to config report?
    Hello,

    In order to help you can you provide a complete report configuration screenshot, and order statuses screenshot as well.
    Check another point that show your screenshot, your order status because maybe order with "shipped" status don't exist ?
    Just a question that can explain a lot.

    Awaiting more element to go more far on your subject.
    Regards
    Last edit: 7 years 8 months ago by Philip.

    Please Log in or Create an account to join the conversation.

    7 years 8 months ago - 7 years 8 months ago #304144 by kyratn
    Replied by kyratn on topic How to config report?
    Hi,

    Here they are.



    Seems filtering by category just doesn't want to work...

    Thanks
    Last edit: 7 years 8 months ago by kyratn.

    Please Log in or Create an account to join the conversation.

    7 years 8 months ago - 7 years 8 months ago #304218 by Philip
    Replied by Philip on topic How to config report?
    Hello

    Can you provide via our Contact us form backend reference with complete access in order to see it by ourself and process some tests
    don't forget to add an url link to this topic.
    Awaiting news from you

    Regards
    Last edit: 7 years 8 months ago by Philip.

    Please Log in or Create an account to join the conversation.

    7 years 1 month ago #311006 by kyratn
    Replied by kyratn on topic How to config report?
    Hi,

    It seems we accidently found what is causing the issue here.

    As topic first message states, we want to see sale report for products from one category only....

    1. As example, if product is in categories "shoes" and "new products", trying to set filter by category "shoes" will generate nothing. If that product is only in one category "shoes" the filtering works.

    So basically for filtering to work, in time the product was sold, it should be only in one category "shoes" else report will generate nothing...

    Would you able to reproduce the issue?

    2. Any update on new dashboard? It has been releases with Hikashop 3 but nothing improved for almost 2 years. It would be great if we could use our own settings as with legacy dashboard and not just have those presets which doesn't give any options at all... Please consider to improve it for at least with Joomla 4.

    Right now we try to send all data to google analytics but there are some thing we want to keep only in back-end and see the report there.

    Please Log in or Create an account to join the conversation.

    7 years 1 month ago #311073 by Mohamed Thelji
    Hello,

    1. Thanks for these informations we successfully reproduced it on our end, so we'll send you a fix as soon as possible !

    2. It's actually on our TODO list but we actually have projects of highest priority so we can't five you any ETA for the moment.

    Thanks for your return !
    Kind regards,
    Mohamed Thelji.
    The following user(s) said Thank You: kyratn

    Please Log in or Create an account to join the conversation.

    7 years 1 month ago #311082 by kyratn
    Replied by kyratn on topic How to config report?
    Hi,

    1. Thanks. It would be great if you could update this topic with the fix.

    2. I know it's on your todo list but this is one of the core things in ecommerce. This should have high priority tho...

    Thank you

    Please Log in or Create an account to join the conversation.

    7 years 1 month ago #311139 by Mohamed Thelji
    Hello,

    1. To fix your issue you'll just have to edit the file, and change these lines :
    Code:
    $leftjoin['product_category_filter'] = ' LEFT JOIN '.hikashop_table('product_category').' AS cat_filter ON cat.product_id = cat_filter.product_id AND cat_filter.category_id < cat.category_id'; $filters[] = 'cat_filter.product_category_id IS NULL';

    By:
    Code:
    if ($widget->widget_params->content != 'products') { $leftjoin['product_category_filter'] = ' LEFT JOIN '.hikashop_table('product_category').' AS cat_filter ON cat.product_id = cat_filter.product_id AND cat_filter.category_id < cat.category_id'; $filters[] = 'cat_filter.product_category_id IS NULL'; }

    2. Sure we'll increase the priority of that project in that case.

    Kind regards,
    Mohamed Thelji.

    Please Log in or Create an account to join the conversation.

    7 years 1 month ago - 7 years 1 month ago #311152 by kyratn
    Replied by kyratn on topic How to config report?
    Hi,

    1. The file should be changed is the widget.php inside administrator->components>com_hikashop->classes folder?
    As this is there i found your code provided.

    I have changed it but it made no difference. The report numbers were same - wrong one....

    So i have changed this line:
    Code:
    if ($widget->widget_params->content != 'products') {

    To this:
    Code:
    if ($widget->widget_params->content == 'products') {

    Generated numbers seems correct now.

    So what code should be used?


    2. I know how much time it takes to develop something.. So it would be great if you could add few new features to dashboard with every new Hikashop release.


    Thank you
    Last edit: 7 years 1 month ago by kyratn.

    Please Log in or Create an account to join the conversation.

    7 years 1 month ago #311220 by Mohamed Thelji
    Hello,

    We'll do more research on our end !
    If it fixed your issue you can let it like for the moment, we'll need some screenshots of how you configured every fields of your report, so that we can directly reproduce it on our end.

    Kind regards,
    Mohamed Thelji.

    Please Log in or Create an account to join the conversation.

    7 years 1 month ago #311228 by kyratn
    Replied by kyratn on topic How to config report?
    Hi,

    Well you can find screenshot in this topic previous answers: www.hikashop.com/forum/reports-statistic...g-report.html#304144

    Unless you need something else?

    Thank you

    Please Log in or Create an account to join the conversation.

    7 years 1 month ago #311242 by Mohamed Thelji
    Hello,

    Sure, I'll need the right part of the configuration page of your report, especially the "Display" tab section.

    Kind regards,
    Mohamed Thelji.

    Please Log in or Create an account to join the conversation.

    7 years 1 month ago #311260 by kyratn
    Replied by kyratn on topic How to config report?
    Hi,

    Here it is:



    Thanks
    The following user(s) said Thank You: Mohamed Thelji

    Please Log in or Create an account to join the conversation.

    Time to create page: 0.096 seconds
    Powered by Kunena Forum