View Issue Details

IDProjectCategoryView StatusLast Update
0006068OXID eShop (all versions)2.6. Administer orderspublic2024-01-17 14:28
Reportervschmi Assigned To 
Status confirmedResolutionopen 
Product Version4.9.3 / 5.2.3 
Summary0006068: Useless ordering by artid
DescriptionIn oxOrder:_getArticles, the primary order for the SQL clause is:

ORDER BY `oxorderarticles`.`oxartid`

This makes little sense, as the column contains UUIDs. I suggest this is changed to OXARTNUM, as this is most likely what the original author originally intended (and it makes any order article list nicer).
Steps To ReproduceIn Backend under "Administer Orders". open a order with many articles.
Order articles are not ordered by article number, but in random order.
TagsNo tags attached.
PHP Versionany
Database Versionany


related to 0006023 acknowledgedflorian.auer Products sorting in basket vs sorting in database/order history 


There are no notes attached to this issue.