No correlation between orders and reports

Start
Prev
1
Next
End

theguy
Topic Author
Offline

Posts: 228
Thank you received: 8

6 years 2 weeks ago #300243

-- url of the page with the problem -- : aradtextile.com
-- HikaShop version -- : 3.5.1
-- Joomla version -- : 3.8.12

Hello,

We are trying to generate a sales report but no matter what setting we try, the reports are wrong and with no correlation to the actual sales when exported from the orders. The total amount is off, the orders number is off.

Please advice,

Guy.

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

nicolas
Away

Posts: 82863
Thank you received: 13372
MODERATOR

6 years 2 weeks ago #300246

Hi,

Well, everything matches on our end. So we would need more information on how you configure your reports, like screenshots of their settings.
Also, a backend access would help so that we could look at the mysql query generated for the report.

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

theguy
Topic Author
Offline

Posts: 228
Thank you received: 8

6 years 1 week ago #300368

Hello Nicolas,

I've made several attempts and managed to understand the issue on our end. I'm trying to generate a sales report for a single day. No matter what I select from the settings, the day is broken into two days. This causes disorder when we try to generate a report for several days or a week report.

Please see attached screen shot.

Much appreciated,

Guy.

Attachments:

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

nicolas
Away

Posts: 82863
Thank you received: 13372
MODERATOR

6 years 1 week ago #300394

Hi,

This indicates an issue with the timezones. Can you check that the timezone of your server, in your Joomla configuration and in your Joomla user account all match up ?

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

theguy
Topic Author
Offline

Posts: 228
Thank you received: 8

6 years 1 week ago #300412

Hi,

That was the first thing I suspected off. Checked the time zone and it was correct, as well as the Joomla configuration time zone. In addition, orders arrive at the right time.

Guy.

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

Jerome
Away
HikaShop core developer

Posts: 26158
Thank you received: 4028
MODERATOR

6 years 6 days ago #300614

Hello,

What are your time zone settings ?
HikaShop store the timestamp in the database to avoid timezone issues ; the display is then made via Joomla and its timezone.
Regarding the reports ; maybe an important timezone could generate an issue in your side and, before we only have 2 hours in our end, the issues are not visible.
So, knowing more about your timezone setting would help us to see where we should take a look.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

theguy
Topic Author
Offline

Posts: 228
Thank you received: 8

6 years 4 days ago #300653

Hello,

The time zone i set to Jerusalem (Israel Time).

Thank you,

Guy.

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

Jerome
Away
HikaShop core developer

Posts: 26158
Thank you received: 4028
MODERATOR

6 years 2 days ago #300734

Hello,

I reproduced your configuration and was able to see a small timestamp sliding regarding the timezone.
I worked on a patch, unfortunately that patch have too many modifications in the widget system to be listed in the forum here.
So I prefer to include it in a future package of HikaShop 4.0.1

But the main idea of the patch is the same system that we have for the new dashboard system ; get the timezone value and process the dates using "gmmktime" and subtract the timezone value.

Regards,