Product Ordering field issue

  • Posts: 1058
  • Thank you received: 11
  • Hikashop Business
1 year 2 months ago #355788

-- 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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 83007
  • Thank you received: 13400
  • MODERATOR
1 year 2 months ago #355793

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

Please Log in or Create an account to join the conversation.

  • Posts: 1058
  • Thank you received: 11
  • Hikashop Business
1 year 2 months ago #355818

Hi,

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

Thank you

Please Log in or Create an account to join the conversation.

  • Posts: 83007
  • Thank you received: 13400
  • MODERATOR
1 year 2 months ago #355824

Hi,

Maybe you could try deleting and recreating that menu item ?

Please Log in or Create an account to join the conversation.

  • Posts: 1058
  • Thank you received: 11
  • Hikashop Business
1 year 2 months ago #355831

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

Thank you

Please Log in or Create an account to join the conversation.

  • Posts: 83007
  • Thank you received: 13400
  • MODERATOR
1 year 2 months ago #355833

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

The following user(s) said Thank You: verzevoul

Please Log in or Create an account to join the conversation.

  • Posts: 83007
  • Thank you received: 13400
  • MODERATOR
1 year 2 months ago #355849

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 ?

The following user(s) said Thank You: verzevoul

Please Log in or Create an account to join the conversation.

  • Posts: 1058
  • Thank you received: 11
  • Hikashop Business
1 year 2 months ago #355853

Hi,

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

Thank you!

The following user(s) said Thank You: nicolas

Please Log in or Create an account to join the conversation.

  • Posts: 1058
  • Thank you received: 11
  • Hikashop Business
1 year 2 months ago #355857

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

Please Log in or Create an account to join the conversation.

  • Posts: 83007
  • Thank you received: 13400
  • MODERATOR
1 year 2 months ago #355859

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.

The following user(s) said Thank You: verzevoul

Please Log in or Create an account to join the conversation.

Time to create page: 0.070 seconds
Powered by Kunena Forum