New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Average price in ecommerce product view's total row shows sum instead of average (bug related to tracking product views) #16441
Comments
Thanks for reporting this @RaphaelBergmann I tried to reproduce this in various of our sites but couldn't. It also seems to work in our public demo https://demo.matomo.org/index.php?module=CoreHome&action=index&idSite=62&period=day&date=yesterday#?idSite=62&period=day&date=yesterday&segment=&category=Goals_Ecommerce&subcategory=Goals_Products Can you maybe sort by average price and check if there are some high priced items in one of the 622 entries? |
I sorted the table, but there're no high priced items... We also have this issue here with sorting, which could refer to values being stored incorrectly in the DB (sth about number formatting, 12.345,67 €?). We have a very basic installation with just two plugins (FormAnalytics and MarketingCampaignsReporting) but disabling both of them doesn't fix our two issues. Or maybe it has something to do with MariaDB handling things slightly differently? |
@RaphaelBergmann can you reproduce the issue on our demo? https://demo.matomo.org/index.php?module=CoreHome&action=index&idSite=62&period=day&date=yesterday#?idSite=62&period=day&date=yesterday&segment=&category=Goals_Ecommerce&subcategory=Goals_Products If the sorting is an issue to not show the high prices maybe try to select in the bottom right "500 rows" and then you should be able to see all prices over two pages so it might be easier to find any high prices (if there are any). |
Your demo is running fine, I can't reproduce my issue there. |
@RaphaelBergmann how are you tracking the ecommerce data? Are you viewing the "Ecommerce orders" view there? Is there any segment applied? I checked... generally the price is divided by the number of orders and I'm seeing a lot of products there but barely any orders so I'm assuming the problem is maybe that the average should only sum prices of products with orders vs in your case it might also sum products without orders. Might be related to tracking "product views". |
@RaphaelBergmann is there any chance we could get view access to this site to try and understand things better? It's still not quite clear to me how this happens. The tracking requests itself look good to me and shouldn't cause an issue. If that's possible, could you create a log in for us for hello at matomo.org and send the details to that email address? |
@tsteur yes, there is a chance - I just sent an email regarding this... Thanks so far :) |
@tsteur I just sent you the credentials :) |
Thanks @RaphaelBergmann it appears to me that it is related to tracking product views. Like Matomo would some up all the product prices then device it by the number of orders. And it would also sum the price of products that had no order for example. |
This should be the average average price, not the sum of all average prices.
Matomo-Version: 3.14.1
MySQL-Version: 10.1.45-MariaDB-0+deb9u1
PHP-Version: 7.4.10
The text was updated successfully, but these errors were encountered: