- Posts: 241
- Thank you received: 5
Report
- cberry1971
-
Topic Author
- Offline
Less
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?
-- 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.
11 years 1 month ago #213143
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
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,
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.
- cberry1971
-
Topic Author
- Offline
Less
More
- Posts: 241
- Thank you received: 5
11 years 1 month ago #213258
by cberry1971
Replied by cberry1971 on topic Report
Please Log in or Create an account to join the conversation.
11 years 1 month ago #213277
by nicolas
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
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.
11 years 1 month ago #213334
by nicolas
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.
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.
Less
More
- Posts: 12953
- Thank you received: 1778
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.
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.
- cberry1971
-
Topic Author
- Offline
Less
More
- Posts: 241
- Thank you received: 5
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.
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.
11 years 3 weeks ago #213724
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
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
By
It should fix your issue.
Regards,
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.*';
}
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.*';
}
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Please Log in or Create an account to join the conversation.
- cberry1971
-
Topic Author
- Offline
Less
More
- Posts: 241
- Thank you received: 5
11 years 2 weeks ago #214621
by cberry1971
Replied by cberry1971 on topic Report
Please Log in or Create an account to join the conversation.
- cberry1971
-
Topic Author
- Offline
Less
More
- Posts: 241
- Thank you received: 5
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"
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.
- cberry1971
-
Topic Author
- Offline
Less
More
- Posts: 241
- Thank you received: 5
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 help.
Please Log in or Create an account to join the conversation.
Time to create page: 0.202 seconds