Developer forum

Forum » Ecommerce - Standard features » Backend Orders list - sort by completed date not in order

Backend Orders list - sort by completed date not in order

E-mail notifications
Jon Thorne
Jon Thorne
Reply
Posted on 06/07/2023 02:26:06

I often notice that the sorting by completed date is not in the correct order. It mostly works, but there is randomly a few records out of place. This makes it a little hard to be sure if I am looking at the latest order, or it is hidden down the list somewhere.


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 10/07/2023 12:17:17
Reply

Hi Jon

Seems like your screendump is missing.

The orders have 2 dates - order date and order completed date. The first one is the date the order instance was created and the other one is when it was completed. Sometimes the difference can be days or weeks, so be sure to sort by completed date. You can right click the columns and add the completed date if missing.

BR Nicolai

 
Jon Thorne
Jon Thorne
Posted on 10/07/2023 12:37:48
Reply

Hi Nicolai,

Imaged attached again for your reference. I do know the difference between OrderDate and OrderCompletedDate. Regardless of the column, I would expect the dates would be in order. They are not.

Regards, Jon.

Screenshot_2023-07-10_at_8.30.48_pm.png
 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 10/07/2023 12:49:18
Reply
This post has been marked as an answer

That looks weird, we can agree on that!

How does the indexes on the EcomOrders table look like?

Should be something like this - or nothing at all. 

Votes for this answer: 1
 
Jon Thorne
Jon Thorne
Posted on 10/07/2023 13:05:35
Reply

Hi Nicolai,

Very helpful tip. Thankyou.

The index was correct, but disabled. So I just rebuilt this and it now seems to be working correctly.

Regards, Jon.

 
Jon Thorne
Jon Thorne
Posted on 16/08/2023 04:25:21
Reply

Even with the index enabled in SQL. It is a little better, but I am still experiencing strange sorting behaviour.

Screenshot_2023-08-16_at_12.24.09_pm.png
 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 16/08/2023 09:17:28
Reply

Can you profile the database and see the SQL being executed when accessing the order list?

And see what happens when you ru in manager?

 

You must be logged in to post in the forum