Dashboard (new) Order This Month wroing after upgrade to 3.2.2

  • Posts: 229
  • Thank you received: 21
  • Hikashop Business Hikashop Essential
6 years 3 months ago #285810

-- HikaShop version -- : 3.2.2
-- Joomla version -- : 3.8.3
-- PHP version -- : 5.6.32

Across multiple sites using the new Dashboard, "Order This Month" totals are all wrong.

This went from the last month (to date) to...well I don't know what it is calculating off of.
The numbers are so low and match nothing that I can see.

And yes, I know it calculates it from the last ~month to date (which you really should change to "Last 30 days" to be clearer.

But regardless way lower and not counting orders. Legacy report is still working fine however.

Before the upgrade, they were reporting just fine.
Afterward, it just isn't even close.

For example, one site went from ~$15,000 before the update to $2.65.
And there is no order for $2.65 so no idea what it is pulling that from.

Again the Legacy Dashboard reports still calculate fine, this is just with the new Dashboard.

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

  • Posts: 229
  • Thank you received: 21
  • Hikashop Business Hikashop Essential
6 years 3 months ago #285812

Additional Note

This is regarding the text dollar amount under "Order This Month" in the upper left corner.

The graph below "Orders" shows the correct amounts.

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

  • Posts: 81481
  • Thank you received: 13062
  • MODERATOR
6 years 3 months ago #285813

Hi,

We've done two changes recently.
This one:
www.hikashop.com/forum/install-update/89...nts-menu.html#283380
And this one:
www.hikashop.com/forum/reports-statistic...fference.html#285093

You say it was fine before the update. Which version did you use before ? If it was the 3.2.1, then these are the only 2 changes we made between HikaShop 3.2.1 and 3.2.2 on the new dashboard.

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

  • Posts: 229
  • Thank you received: 21
  • Hikashop Business Hikashop Essential
6 years 3 months ago #285935

I upgraded all the sites from HikaShop 3.2.1.

And all have the same exact issue now.

At a glance, my guess is the timing windows is now off for some reason because of one of those two changes; most likely related to www.hikashop.com/forum/reports-statistic...fference.html#285093 .

But if that is the only thing, I cannot figure out where the dates .
They don't match anything even close to any numbers I can identify where it be 30 days, 3 days, 1 day, etc.

The numbers don't match up for any kind of combination of the actual orders.
If I had to take a guess, I'd say it might adding up shipping/taxes only.
But I'd have to go manually add up all those to check that.

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

  • Posts: 229
  • Thank you received: 21
  • Hikashop Business Hikashop Essential
6 years 3 months ago #285937

FYI I looked at the shipping & sales tax calculations on one of the lower volume sites, and it is close but not exact.

So no idea where these numbers are coming from still.

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

  • Posts: 81481
  • Thank you received: 13062
  • MODERATOR
6 years 3 months ago #285940

Hi,

So could you try reverting that code change and see if that helps ?

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

  • Posts: 229
  • Thank you received: 21
  • Hikashop Business Hikashop Essential
6 years 3 months ago #286033

I rolled it back on a test site and it goes back to expected.

But I found out some things on the test site because we don't touch it often.
So there were 0 test orders since August 2017.

Under 3.2.2, it read correctly $0.00.
Then we placed an new order and it read correctly (once we marked it shipped) at $10.84.

Then we decided to change a couple of the older created orders to shipped, one from July ($845.55) and one from Aug. ($65.27). This is when the Orders This Month numbers went wrong.

It now only gives us the July order in the total ($845.55).
It completely ignores the January new order for $10.84 and the August $65.27 order.

But the Total Orders shows 3 as well as the Current Orders.

I got no guess as what is causing this at this point.

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

  • Posts: 81481
  • Thank you received: 13062
  • MODERATOR
6 years 3 months ago #286056

Hi,

So wouldn't that mean that you have a timezone wrongly configured in your Joomla configuration/joomla user account or php ?
Could you check these ?
Also, since it would be a timezone issue, it should only vary a little (max 24h of orders).
And it's not really that the amount is wrong in either version, it's just that the new version is now using a different range for the orders (normally the correct one compared to before).

Also, note that the date taken into account can either be the invoice creation date or the order creation date based on whether you have the "created" status added in the "statistics" column of the System>Order Statuses menu. So you need to take that into account as well when comparing the orders with the results of the dashboard calculations.

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

  • Posts: 229
  • Thank you received: 21
  • Hikashop Business Hikashop Essential
6 years 3 months ago #286089

Actually timezone was the first thing I checked even before posting.

It is set to the correct zone in Joomla.

Server PHP doesn't adjust the timezone (it uses what ever the server passes through)

Besides, that wouldn't explain why orders touched on the same day or within 30 days are not registering.

It isn't varying a little, it is varying a lot and not even including some.

I haven't touched the System -> Order Status defaults (didn't even know they existed).

I have sites that are missing 10,000+, not just a day or two of sales.

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

  • Posts: 45
  • Thank you received: 0
  • Hikashop Business
6 years 3 months ago #286102

Hi,

I've the same problem. After update from Hikashop 3.2.1 to 3.2.2 (Joomla 3.8.3) the amount from orders from last month isn't correct.

Best regards

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

  • Posts: 81481
  • Thank you received: 13062
  • MODERATOR
6 years 3 months ago #286090

Hi,

We would need a super admin access to one of these then so that we can look at the situation.
A FTP access would be great too so that we could try reverting the timzone fix or not and see what happens.
Could you provide these via our contact form along with a link to this thread ?
www.hikashop.com/support/contact-us.html

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

  • Posts: 81481
  • Thank you received: 13062
  • MODERATOR
6 years 2 months ago #286228

Hi,

Thank you for the access.
After debugging, it appears that the issue comes from this modification:
www.hikashop.com/forum/install-update/89...nts-menu.html#283380
The modification should actually be:
,'group' => 'hk_order.order_currency_id'
instead of:
,'group' => 'hk_order.order_id'
We've done the change on your website and it looks like it's working.
We'll add that patch on our end.

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

Time to create page: 0.091 seconds
Powered by Kunena Forum