How to config report?

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?

Hi,

Here they are.

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.

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.

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

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';

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';
}

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') {

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

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.

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

Hello,

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

Kind regards,
Mohamed Thelji.

Hi,

Here it is: