1. Two different operating places in the background.
  2. Choose the same time (one day) for testing.
  3. The output is different.
  4. SALES Order count is same as my database query result.

This is SALES Orders enter image description here

This is REPORTS Orders enter image description here

The results of the query after time conversion. enter image description here

2 Answers 2

  1. check if the statistics data is up to date. Data for the report needs to be rebuilt by cron or manually

  2. check your timezone settings. I had issues with this in magento 1 when my timezone was not UTC, and orders where placed around 0am +/- a few hours This might also be an issue for the results of the db query in comparison to any other data, because the date in the database is actually stored in UTC, but shown converted to your timezone in the backend


I'm glad the problem has been solved. https://github.com/magento/magento2/issues/14500

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.