search

HotcakesCommerce / hotcakes-commerce-core

The core of the e-commerce part of the overall solution. This is an ecommerce shopping cart solution built on top of the DNN (DotNetNuke) CMS. Anyone can do commerce online now!
https://mmmcommerce.com
MIT License
70 stars 55 forks source link

Dashboard "Sales over time" output seems incorrect #242

Open puresystems opened 4 years ago

puresystems commented 4 years ago

On the eCommerce dashboard page, the "sales over time" bar chart seems to be a day out. It appears to be showing a day ahead but i am not sure where the data is coming from for the current day. But on ours it's definately a day wrong.

Has anyone else experienced this?

Thanks! Dan

WillStrohl commented 4 years ago

Can you provide a more specific example? Any steps to reproduce and examples of what you expected to see versus what you saw would be key to figuring out what to do and how to proceed.

puresystems commented 4 years ago

Would it help if we got you access to the site in question so you can see for yourself? It's probably easier than trying to demonstrate it on another system.

From: Will Strohl notifications@github.com Sent: Friday, May 15, 2020 8:19:56 AM To: HotcakesCommerce/hotcakes-commerce-core hotcakes-commerce-core@noreply.github.com Cc: puresystems daniel.rice@outlook.com; Author author@noreply.github.com Subject: Re: [HotcakesCommerce/hotcakes-commerce-core] Dashboard "Sales over time" output seems incorrect (#242)

Can you provide a more specific example? Any steps to reproduce and examples of what you expected to see versus what you saw would be key to figuring out what to do and how to proceed.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/HotcakesCommerce/hotcakes-commerce-core/issues/242#issuecomment-629074281, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABFSBAYWSSVDGVDWVWA5EY3RRTUJZANCNFSM4L2UXGAA.

WillStrohl commented 4 years ago

It would be best to have specific steps to reproduce that others can verify and/or test the use case and related updates.

puresystems commented 4 years ago

I can only go on what we're seeing on a particular instance and so I can't supply steps to repeat. As per my opening issue, it would appear that the dashboard sales graph is a day off. I will reconfirm with the customer and post back results.

From: Will Strohl notifications@github.com Sent: Tuesday, May 19, 2020 9:04:49 PM To: HotcakesCommerce/hotcakes-commerce-core hotcakes-commerce-core@noreply.github.com Cc: puresystems daniel.rice@outlook.com; Author author@noreply.github.com Subject: Re: [HotcakesCommerce/hotcakes-commerce-core] Dashboard "Sales over time" output seems incorrect (#242)

It would be best to have specific steps to reproduce that others can verify and/or test the use case and related updates.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/HotcakesCommerce/hotcakes-commerce-core/issues/242#issuecomment-631052237, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABFSBAZA4TOCBIMMPATHE4TRSLQ6DANCNFSM4L2UXGAA.

WillStrohl commented 4 years ago

Thanks, @puresystems . In order for anyone to properly troubleshoot and resolve any issue, we'll need to have specific steps for another person to reproduce the issue in another environment. As you may know, sometimes issues like this can be influenced by things that may be unique to the implementation. :)

puresystems commented 4 years ago

Describe the bug

On the Dashboard, the Year Sales and Week Sales graphs are showing incorrect data. (See screen shots below showing Week and Year graphs)

The Week view shows the wrong value for the current day (which is the last bar in the graph). It's showing approx. £750 but the value via the Reports->Summary Report for 12/06/2020 (en-GB format) is £122.06. The Week view seems to be a day ahead. On the Week view for Thursday, it appears to be Fridays sales, Wednesday is Thursdays sales, etc. This has been verified by viewing the sales via the "Reports->Summary report" for each day and comparing.

The "Sales Over Time - Year" graph appears to be displaying wrong June data. The June bar is showing approx £28,000 but via the "Reports - summary report" view for "This Month" it's showing £12,307.52. The other month values appear to be correct in the bar graph when comparing to the "Reports - summary report" for each month.

Software Versions

To Reproduce

Steps to reproduce the behavior:

  1. In Dnn Site Settings->Languages add "English (United Kingdom)" language and set as Site Default.
  2. In Dnn Site Settings->Languages disable "English (United States)" language.
  3. In HC Settings->Geo Location, set Time Zone to "(UTC+00:00) Dublin, Edinburgh, Lisbon, London" and "Culture / Currency" to "United Kingdom £1.23"
  4. Set Dashboard "sales over time" to "Week" and note graph values and comapare to Reports->Summary Report for the same period of time.
  5. Set Dashboard "sales over time" to "Year" and note graph values and comapare to Reports->Summary Report for the same period of time.

Expected behavior

Dashboard and Reports should be showing the same values.

Actual behavior

Dashboard and Reports are not showing the same values.

Screenshots

Week sales Dashboard Week Sales

Year sales Dashboard Year Sales

Error log

None

Additional context

None

WillStrohl commented 4 years ago

Interesting. Do you think this is specific to localized stores?

puresystems commented 4 years ago

We've just set everything back to en-US across Dnn and HC but the results are still the same.