euroblaze | OXID e-Commerce User Blog

The Easy Way for Ascending and Descending Sort

Under Categories, you will find a section which allows to select a specific column from OXARTICLES table to sort ascending or descending.  This can be found underAdminister Products > Categories > Main > Fast Sorting.

Customized Sorting

All too often it is necessary to assign a sorting index to products within categories, so that they appear in a specific order in category listings (list.tpl).  OXID does provide a facility for this, though not a very friendly one!

In order to start finding your way to product-sorting in any particular category, select the category and then the Sorting tab as shown in this screen-shot (follow the numbers serially).

Notice first that at 4 it says Sort Categories, which infact should be called Sort Products.  Click that button, in order to open a classical OXID AJAX drag-and-drop popup-slider as seen below.

Once you are done sorting all products from the left to right panes, save the new sort-order.  The sorting-order on the right is hereafter reflected on the shop front-end.

User Unfriendly

Why is this user-unfriendly?  Notice that if you wish to change the sorting order of individual products, you will have to Delete Sorting, and completely start over again!

Using ERP Systems to Populate the Sorting-Index

If you are using ERP back-ends to populate (which is usually the case for shops with large number of products) the OXID product-catalog, you may update the database table oxarticles, column OXSORT in order to influence the sorting order of products in specific categories.