Order products

Hi,

You can use the arrows of the "order" column, or enter another number in the input field and then click on the save icon button at the top, next to the "order" title of the products listing.
Note that the order of the products is "per category", so, in order to see the arrows and the input fields, you need to access a leaf category ( a category without sub categories ) first with the category explorer on the left sidebar.

Hi,

How about if you drag & drop the rows with the anchor on the left side of the input field ?
Also, I would recommend increasing the number of elements on the page to have all the elements of that category on one page, and then make sure that the order starts at 1 and increments by 1 properly in all the order input fields before saving, that might help.

Worst case, you can run a MySQL query to reset the order to 0 for all the products via your PHPMyAdmin:

UPDATE #__hikashop_product_category set ordering = 0;

Hi,

I don't see how running the MySQL to reset all the ordering would lead to the result on your screenshot.
Can you confirm that you run the MySQL query ?
Did you change the #__ with the table prefix of your database ?

If nothing works, we'll need a backend access, a FTP access and a database access in order to check the situation.

Hi,

Yes, you can go through our contact form to provide them:
www.hikashop.com/support/contact-us.html

Hi,

What you said about the user creation gave me the idea that your issue might be linked to a major problem in your database.
So, after I checked I was able to somehow reproduce the issue on your products listing, I went to your orders listing. There, I clicked on the "new" button in order to create a new order. Normally, the new order should have the id "2" since there was only one order with the id "1". But the new order was created by MySQL with the id "0". This means that there is something seriously wrong with the database. The primary key and / or auto_increment must be missing in the hikashop_order table, and probably with all the tables, not only HikaShop.

I clicked on the "check database" button of the HikaShop configuration. The system found that all the auto_increment values and primary keys were missing in your HikaShop tables and fixed them:
i.imgur.com/DCsfVRP.png
After this, I'm not able to reproduce the issue with the ordering of the products. And the order creation process has been fixed too (and probably any other process of HikaShop which requires saving stuff to the database).

However, note that this only fixes the problem with the HikaShop tables. You likely have the same problem with other tables in your database, like the users table of Joomla, which would explain the error you have with the user creation.

I think this issue comes from a database migration issue. Something must have gone wrong along the way and the primary keys and auto_increments have been lost. That's a big issue. While the check database process can mitigate the problem for HikaShop, you likely want to go over the migration steps you took to avoid loose the primary keys and auto_increment of your tables in the first place.

Hi,

The changes I made for HikaShop are easy. I only pressed the "check database" button. And what it did is to try and repair what was lost in HikaShop as best as it could. That's why the products were moved because it couldn't restore them in the correct category.
While HikaShop's processes should all be working fine now thanks to the database check, processes linked to Joomla will still not work. So, for example, if you require registration or login during the checkout of HikaShop, people won't be able to register a new account if the Joomla users table is missing its primary key and / or auto_increment.

I dont see how updating an extension would remove the primary keys and auto_increment of all the tables. This issue is typical of a database export / import where the auto_increment flag is missing from the export.
It's likely that you saw the issue after the update as it made the problem apparent, but you already had it before.

And the issue with the menu is likely due to that same reason of the primary keys and auto_increment missing for the menu tables of Joomla in the database.

Also, the console errors are not really a problem. However, they seem to indicate that a migration of some sort has happened since the domain for the cookies has changed.

You'll likely find many other problems on your website if the primary keys and auto_increment are missing of all the tables.

The best would be to revert the database to a backup from before loosing all the primary keys and auto_increment.
If you can't, you'll have to go in the database to fix this manually. These are old posts of users of early versions of Joomla with the same issue (before HikaShop even existed). They contain more information about the issue and what to do to manually fix it :
forum.joomla.org/viewtopic.php?t=53592
forum.joomla.org/viewtopic.php?t=93219