If you navigate to Store > Orders and try sorting the table at /admin/commerce/orders?order=order_number&sort=asc by the Order Number column, you will see the following order numbers when sorted ascending:

1
17
18
2
21
23

etc, whereas it should be:

1
2
17
18
21
23

CommentFileSizeAuthor
drupalcommerce.png3.88 KBrwecarter

Comments

rszrama’s picture

rszrama commented
Category: bug » support
Status: Active » Closed (duplicate)

This is a duplicate issue due to the data type of that column in MySQL; it's sorted like text, not merely like numbers.

See: #1455778: Change the default Orders View's "Created" column to a "Last updated" column