Product Ordering field issue

-- HikaShop version -- : 5.0.0
-- Joomla version -- : 3.10.12

Hello!

In the menu item, i set the ordering as Product created and Descending, but in the frontend if i refresh the page the products order keeps changing on every refresh.

Thank you

Hi,

I can only think that you're looking at the settings of a menu item different than the menu item used on your link.
The one on your link is the one with the id 932

Hi,

Yes that is the correct menu item "Νέα Προϊόντα". But i don't understand why it's happening.

Thank you

Hi,

Maybe you could try deleting and recreating that menu item ?

I created a new one yes but the result is the same. Doesn't make any sense!
Can you check it maybe?

Thank you

Yes, please provide a backend access via our contact form:
www.hikashop.com/support/contact-us.html

Hi,

I got your access but I'm not able to reproduce the problem anymore on your link.
Now, I always see the same products.
So I think that deleting and recreating the menu item worked.
Can you check on your end ?

Hi,

Now yes it does look like it works correct, weird!
If it happens again i wiil let you know.

Thank you!

Hi nicolas,

Now i noticed that the order of some products is changing again. The first 4-5 products are okay and the rest of them are changing with evert page refresh. We noticed this issue from 3 different computers.

Thank you

Hi,

I looked into it and I think I know what the problem is.
You're using the ordering column "product_created" for your products listing, with the direction being descending.
This means that you want the newer products first and the older products last.
The problem is that many products (almost all of them ?) have the same "product_created".
So MySQL doesn't know how to order them and randomly order the products with the same product_created.
That's also why some products don't move from their location because they have a different product_created.