Changing product "Ordering" on the backend by catagory

Hi,

In the settings page of each menu items of the type HikaShop products listing or categories listing (you can access that via the Joomla menu manager), you have a tab "products options". Under that tab, you have a setting "ordering column" and a setting "ordering direction". If you set the ordering column to "product_name" and the ordering direction to ascendant, then the products listed in that menu item will be sorted alphabetically based on the name of the products on the pages of that menu item.
So if you have several menu items for different categories, you can configure the ordering differently in them thanks to these settings in each menu item.

Hi,

On the backend products listing, you can click on the title of each column so that the listing will be ordered based on that column's data.
So if you click on the "Name" title, the products will be ordered based on their product name. In fact, this is the same in any listing of the backend where the title can be clicked.

Hi,

In your menu item settings, under the "products options" tab, you have the settings "ordering column" and "ordering direction" which define how the products are ordered on the whole listing. This is done when loading the data from the database directly in MySQL.

Then, you set the "sub element filter" to "group by category". This can't be done when loading the data from the database and is done after that.

So if you base the ordering of the products on something which is global to all the products regardless of the category, you would get a strange result on the frontend since you'll have products from the same category on different pages of the listing.

The best you can do right now is to create a custom field of the table "product" and enter the value you want in each for each product and then base the ordering of the menu item on it. That way, you can really have the order you want.
But it's a bit tedious to do, especially if you have a lot of products.
Thinking about it, I think I found a way to automatically sort the products taking into account first the categories and then the normal ordering of the products in their respective categories. I've made a patch for it.
You can replace the file components/com_hikashop/views/product/view.html.php with the one in the zip attached and it will add the patch.

Hi,

Well, if the category of products is the cut-off category for the pagination, it's normal that you got some products of it on the first page and some in the second page.
And looking into it, it does seem that the 3 products of that category in the second page are the last ones of that category.
Now, in that case, that would mean that the "ordering" of the categories is not filled in properly under the Products>Categories listing. Could you check there ?
What I see there would mean that the ordering configured under the "categories options" tab of your menu item results in an order of the categories different from the "ordering" you set in the Products>Categories.

Hello,

Yes, Mohamed means to use the ordering in order to define the sort order of your categories, like shown in your screenshot.
In details, you have to use your order button (red bordered in my screenshot), to define the order sort of your categories relative to each other.