Report

  • Posts: 241
  • Thank you received: 5
9 years 11 months ago #213129

-- HikaShop version -- : latest
-- Joomla version -- : latest
-- PHP version -- : latest
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : na

We have a report to track the orders for a type of revenue we receive "scoring only" revenue and have a bug where the report is now double counting the orders as seen in the screenshots below of settings.

Do you know what might be causing this?



Attachments:

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

  • Posts: 26264
  • Thank you received: 4043
  • MODERATOR
9 years 11 months ago #213143

Hi,

Does that order contains several products ? Or maybe it is a variant product ?
Knowing more about the order and his content will help us to understand the issue.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 241
  • Thank you received: 5
9 years 11 months ago #213258

No the order only contained one product/variant.

I have included screenshots of the order and the product below.






Attachments:

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

  • Posts: 84233
  • Thank you received: 13674
  • MODERATOR
9 years 11 months ago #213277

Hi,

Could you provide a backend access so that we could check your HikaShop settings, the report and the order more in depth as we're not able to reproduce ?
www.hikashop.com/support/contact-us.html

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

  • Posts: 84233
  • Thank you received: 13674
  • MODERATOR
9 years 11 months ago #213334

Hi,

When I go to the /administrator of your website, I'm redirected to the index. So you seem to have a security extension which requires a specific key to access the backend.
Please also provide that so that we can access the backend.

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

  • Posts: 12953
  • Thank you received: 1778
9 years 11 months ago #213530

Hello,
I just tested it with exactly the same configuration and it worked fine on my end, can you download the last Hikashop version through our website, install it and test it again ?
If it still not working, can you also send us a temporary ftp access through our contact form ?
Thanks.

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

  • Posts: 241
  • Thank you received: 5
9 years 11 months ago #213649

I am sorry but I am confused. If you tested it on your end, the only difference would be the browsers.

We have tried various computers and cleared cache and the 2x counting continues.

To see the duplicates:

1. please login to our back end
2. go hikashop > orders > reports > "Scoring Only Orders"

There you will see the double entries for each order. Please confirm it is really working on your end.

Thanks.

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

  • Posts: 26264
  • Thank you received: 4043
  • MODERATOR
9 years 11 months ago #213724

Hi,

I think that Mohamed didn't have the right sample data for his test ; I reproduced the issue in my test website.
In the file "administrator/components/com_hikashop/classes/widget.php" please replace

		if($csv && ($widget->widget_params->content=='orders' || $widget->widget_params->content=='sales')){
			$leftjoin[]=' LEFT JOIN #__hikashop_address AS address1 ON a.order_billing_address_id=address1.address_id';
			$select.=',address1.*';
		}
By
		if($widget->widget_params->content=='orders'){
			$limit = ' GROUP BY a.order_id '.$limit;
		}
		if($csv && ($widget->widget_params->content=='orders' || $widget->widget_params->content=='sales')){
			$leftjoin[]=' LEFT JOIN #__hikashop_address AS address1 ON a.order_billing_address_id=address1.address_id';
			$select.=',address1.*';
		}
It should fix your issue.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 241
  • Thank you received: 5
9 years 11 months ago #214621

Ok. 1/2 way there. I replaced the code and everything looks good for "scoring only orders" but in "scoring only revenue" the bar graph (screenshot below) is still 2x counting. It is now 2x the corrected (due to the new code) the "scoring only orders" when exported to spreadsheet and summed.





Attachments:

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

  • Posts: 241
  • Thank you received: 5
9 years 10 months ago #216793

Sorry guys but now (this month) the scoring only orders are displaying orders from a totally different (not related) product.

The report we run has "Filters" "Categories" = "Billing Category" but for some unknown reason a bug happens where (for this month only) it is capturing a single product who has no product, variant, or option related to "Billing Category"

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

  • Posts: 241
  • Thank you received: 5
9 years 6 months ago #227507

I am still awaiting a fix/reply here and 2016 is the year to hopefully get these reports to stop double counting and including orders that are not associated with the "Billing Category"

Please help.

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

Time to create page: 0.155 seconds
Powered by Kunena Forum