In Sales Reports (admin/store/reports/sales), the sales data for "yesterday" and "today" do not accurately represent the sales for that day. With two orders today, the number of orders displayed is zero. When "yesterday" is clicked, it shows orders from yesterday and the day prior.

The time zone is one hour offset from my own, but orders occurred outside the 11pm-1am range.

I suspect the date range calculation is slightly skewed or does not account for time zone.

Comments

rszrama’s picture

rszrama commented
Status: Active » Postponed (maintainer needs more info)
Issue tags: +reports

Can you update to the latest version and let us know if the problem is still there? cha0s worked on reports a bit to nail these timezone issues down a while ago.

willvincent’s picture

willvincent commented
Version: 6.x-2.0-beta5 » 6.x-2.0-rc7
Status: Postponed (maintainer needs more info) » Active

I've changed the status of this back to active as I am having a similar issue with RC7.

I have my default site timezone set to local time (Central, GMT -5), and the server is also running on the same timezone.

Sales reports seem they are being calculated based on GMT, as well as custom reports. Changing the gmmktime() to mktime() in the _uc_reports_end_interval has fixed the custom reports, but I'm not seeing where I can make a change for the other reports.

tr’s picture

tr commented
Version: 6.x-2.0-rc7 » 6.x-2.x-dev

Try the patch in #740296: Sales & Product Reports - big problem with dates causing incorrect & inaccurate data and let me know if that works.

tr’s picture

tr commented
Status: Active » Closed (duplicate)

Marking this as duplicate of #740296: Sales & Product Reports - big problem with dates causing incorrect & inaccurate data. Although that issue is newer, it contains fixes and discussion absent from this thread.