cancel
Showing results for 
Search instead for 
Did you mean: 

Some orders not displaying on the admin when filtering by date

SOLVED

Some orders not displaying on the admin when filtering by date

Hi everyone,

Having set the Magento timezone to Greece/Athens I can view orders without any issues at the orders grid, but when I'm using a filter to view a single day, the orders that were placed between 00:00 and 03:00 (Greece/Athens is GMT+3 and I guess that it is related somehow) are not there. Any ideas?

Regards

Yannis

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Some orders not displaying on the admin when filtering by date

@Yannis D

 

This is Magento core issue and it will fix in Magento 2.3 release. 

 

https://github.com/magento/magento2/issues/16507

Manish Mittal
https://www.manishmittal.com/

View solution in original post

3 REPLIES 3

Re: Some orders not displaying on the admin when filtering by date

@Yannis D

 

Can you check once your database cause it seems timezone issue.

 

Check expected orders date in Sales_order table in database.

Manish Mittal
https://www.manishmittal.com/

Re: Some orders not displaying on the admin when filtering by date

@Manish Mittal thank you for your reply.

 

Date and time at the db are in UTC. I tried hard, but I couldn't find a connection.

 

Yannis

Re: Some orders not displaying on the admin when filtering by date

@Yannis D

 

This is Magento core issue and it will fix in Magento 2.3 release. 

 

https://github.com/magento/magento2/issues/16507

Manish Mittal
https://www.manishmittal.com/