[qualiteam]

I think you may try to update the "orderby" column in the "xc_category_products" database table.

But create a full backup of your website first, just in case something goes wrong.