Totals on dashboard still off.

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4

I have reported this earlier on and hoped it would be fixed but totals in table reports we setup are still way off.

They only reasons I can think off that Hika has issues with comma separation for decimals?

When I export the totals and do a check in excel I get completely different numbers. Very frustrating for our managers.
Its also not a little off:
Hika total for this year: around 20.000 than excel comes around 14.000
Simpel setting for the totals: this year, tax excluded and only confirmed payments. Tried to set it to fixed date to get around an earlier bug but that does not change anything. It's also the same for all websites.

Besides that I constantly loose my widgets with all setup totals. More frustration. We want to use Hika as a professional tool but this is not good.

Hi Jerome, I have always test sites/copies of the current sites so you are always more than welcome to have a look there:

In general: setup is in Euro's no other currencies.
When I do a simple test like trying to show all completed orders from 1/1/70 to 1/1/2025, no VAT and nothing else selected, basically showing the total of all complete orders I get in the dashboard: 39.405,78 as total ( yes note the comma, )

When I export the completed orders (love that mass action option) and run a total in Excel, I get: 32263,10997
When I check the amount of orders in the dashboard versus excel, I get the exact same amount. In this case 207.

Other test: Set the order total for this month (5 orders confirmed), dashboard shows 6 orders for this month and the total but there are only 5 confirmed. Total in excel is 594 and dashboard shows 1720.66. Doesn't matter if I set the date fixed or choose the preset for this month. Een when I add a sixth order it still does not add up to that total.

This is consistent through multiple sites.
I have checked for wrong entries but there are no refunds (yet) on that site, all incomplete orders are removed, no shipping so all pretty straight forward.

Let me know if you want access to one of the sites and where I can mail the details or if I can do any additional checks.

Bastiaan

Hi Jerome, thanks for checking.

I am full aware how I set the reports. Normal companies work with netto (no tax) totals, so I have set it properly. Of course the same with my checks. Nothing I don't understand there. I have also installed invoice manager and there the totals are also correct.

And yes I am aware that the time periods are not what they seem to be, thats why I also tested with fixed date periods to make sure I was covering the same period. This was already mentioned in my previous messages.

Pity you did not find a cause for the issues. I will also run some more test and see if I can find out where it goes wrong. Most logical if the queries are right, is that it is missing some filters. Could be discount or VAT related.

Did some more tests on the following setup:
1 order 347 euro 100% discount - total 0 confirmed
2 order 347 euro no discount - total 347 confirmed
3 order 347 euro 100% discount - total 0 confirmed
4 order 347 euro 100% discount - total 0 confirmed
5 order 347 euro 100eur discount - total 247 confirmed
6 order 347 euro no discount - total 347 created
7 order 347 euro no discount - total 347 created

Setting this in a widget setting including tax and only confirmed gives 2082 as result.
Of course the result should be 347+247= 594

So it turns out Hika seems to skip the fact that I only want confirmed orders and also skips the 100% discounts. On top of that it ignores the 100 euro discount number it seems and forgets about the amount completely.
if we do 6x 347 it equals 2082.
This is a major issue I can't solve and definitely needs a serieus check.

Hi Nicolas, back from the Joomla party

Sorry you went for testing while I had the website on PHP5.5 to find the reason why Hika is not working on our servers with 5.5.
Its back to 5.4 now and than all is fine to access the orders.

Guys, this is still pretty important, and need to be solved asap. It's been going on for too long now. It's nice that the queries look good but it's the totals that count and they are way off.
This is an issue for a long time with first the wrong periods and now the wrong totals. It's really important for all the managers and accounting people here.Some sites do now 200.000 to 500.000 a year. Than financial planning is crucial.

Nicolas, great that you found the time to look at this. I have added your widget to a few sites and will test them in different settings.
Officially I am on holiday so I work a bit less than the regular 18 hour days but will also let the users check it.
a quick check still showed some differences but I want to make absolutely sure it was not my fault and that takes time.
I will let you know the results in a while.

Thanks so far!

Bastiaan

We are experiencing the same issue with the Dashboard totals. Using table reports does not show the correct totals for some reason. Was this fix applied to the latest version of HikaShop? Thank you for your support.