How to config report?

  • Posts: 1119
  • Thank you received: 114
5 years 1 month ago #304071

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?


  • Attachments:

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

    • Posts: 4486
    • Thank you received: 609
    • MODERATOR
    5 years 1 month ago #304119

    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: 5 years 1 month ago by Philip.

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

    • Posts: 1119
    • Thank you received: 114
    5 years 1 month ago #304144

    Hi,

    Here they are.



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

    Thanks

    Attachments:
    Last edit: 5 years 1 month ago by kyratn.

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

    • Posts: 4486
    • Thank you received: 609
    • MODERATOR
    5 years 1 month ago #304218

    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: 5 years 1 month ago by Philip.

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

    • Posts: 1119
    • Thank you received: 114
    4 years 6 months ago #311006

    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.

    • Posts: 12953
    • Thank you received: 1778
    4 years 6 months ago #311073

    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.

    • Posts: 1119
    • Thank you received: 114
    4 years 6 months ago #311082

    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.

    • Posts: 12953
    • Thank you received: 1778
    4 years 6 months ago #311139

    Hello,

    1. To fix your issue you'll just have to edit the file, and change these lines :

    $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:
    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.

    • Posts: 1119
    • Thank you received: 114
    4 years 6 months ago #311152

    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:

    if ($widget->widget_params->content != 'products') {

    To this:
    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: 4 years 6 months ago by kyratn.

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

    • Posts: 12953
    • Thank you received: 1778
    4 years 6 months ago #311220

    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.

    • Posts: 1119
    • Thank you received: 114
    4 years 6 months ago #311228

    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.

    • Posts: 12953
    • Thank you received: 1778
    4 years 6 months ago #311242

    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.

    • Posts: 1119
    • Thank you received: 114
    4 years 6 months ago #311260

    Hi,

    Here it is:



    Thanks

    Attachments:
    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.108 seconds
    Powered by Kunena Forum