Skip to main content

Report

More
11 years 1 month ago #213129 by cberry1971
Report was created by cberry1971
-- 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?



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

More
11 years 1 month ago #213143 by Jerome
Replied by Jerome on topic Report
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.

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

More
11 years 1 month ago #213258 by cberry1971
Replied by cberry1971 on topic Report
No the order only contained one product/variant.

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






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

More
11 years 1 month ago #213277 by nicolas
Replied by nicolas on topic Report
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.

More
11 years 1 month ago #213334 by nicolas
Replied by nicolas on topic Report
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.

More
11 years 3 weeks ago #213530 by Mohamed Thelji
Replied by Mohamed Thelji on topic Report
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.

More
11 years 3 weeks ago #213649 by cberry1971
Replied by cberry1971 on topic Report
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.

More
11 years 3 weeks ago #213724 by Jerome
Replied by Jerome on topic Report
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
Code:
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
Code:
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.

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

More
11 years 2 weeks ago #214621 by cberry1971
Replied by cberry1971 on topic Report
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.





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

More
10 years 11 months ago #216793 by cberry1971
Replied by cberry1971 on topic Report
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.

More
10 years 8 months ago #227507 by cberry1971
Replied by cberry1971 on topic Report
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.202 seconds
Powered by Kunena Forum