[Skip to main content](#vessel-content) # Product Ordering field issue ## - **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")** - [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author - [ Away](/forum/user/8351-verzevoul) Less More - Posts: 1195 - Thank you received: 13 - - 3 years 1 month ago [\#355788](#355788) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") *[Product Ordering field issue](/forum/26-product-category-display/907118-product-ordering-field-issue#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")* was created by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* -- 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 - [ ![menu_2023-10-11.png](/forum/attachment/57968) ](/forum/attachment/57968 "...2023-10-11.png") [ ](/forum/attachment/57968?download=1 "...2023-10-11.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MDcxMTgtcHJvZHVjdC1vcmRlcmluZy1maWVsZC1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86540 - Thank you received: 14300 - - 3 years 1 month ago [\#355793](#355793) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Ordering field issue](/forum/26-product-category-display/907118-product-ordering-field-issue#355793 "-- 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MDcxMTgtcHJvZHVjdC1vcmRlcmluZy1maWVsZC1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")** - [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author - [ Away](/forum/user/8351-verzevoul) Less More - Posts: 1195 - Thank you received: 13 - - 3 years 1 month ago [\#355818](#355818) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[Product Ordering field issue](/forum/26-product-category-display/907118-product-ordering-field-issue#355818 "-- 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, Yes that is the correct menu item "Νέα Προϊόντα". But i don't understand why it's happening. Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MDcxMTgtcHJvZHVjdC1vcmRlcmluZy1maWVsZC1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86540 - Thank you received: 14300 - - 3 years 1 month ago [\#355824](#355824) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Ordering field issue](/forum/26-product-category-display/907118-product-ordering-field-issue#355824 "-- 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, Maybe you could try deleting and recreating that menu item ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MDcxMTgtcHJvZHVjdC1vcmRlcmluZy1maWVsZC1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")** - [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author - [ Away](/forum/user/8351-verzevoul) Less More - Posts: 1195 - Thank you received: 13 - - 3 years 1 month ago [\#355831](#355831) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[Product Ordering field issue](/forum/26-product-category-display/907118-product-ordering-field-issue#355831 "-- 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")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MDcxMTgtcHJvZHVjdC1vcmRlcmluZy1maWVsZC1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86540 - Thank you received: 14300 - - 3 years 1 month ago [\#355833](#355833) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Ordering field issue](/forum/26-product-category-display/907118-product-ordering-field-issue#355833 "-- 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")* Yes, please provide a backend access via our contact form: [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html) The following user(s) said Thank You: [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MDcxMTgtcHJvZHVjdC1vcmRlcmluZy1maWVsZC1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86540 - Thank you received: 14300 - - 3 years 1 month ago [\#355849](#355849) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Ordering field issue](/forum/26-product-category-display/907118-product-ordering-field-issue#355849 "-- 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 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](/forum/user/8351-verzevoul "View verzevoul's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MDcxMTgtcHJvZHVjdC1vcmRlcmluZy1maWVsZC1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")** - [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author - [ Away](/forum/user/8351-verzevoul) Less More - Posts: 1195 - Thank you received: 13 - - 3 years 1 month ago [\#355853](#355853) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[Product Ordering field issue](/forum/26-product-category-display/907118-product-ordering-field-issue#355853 "-- 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, 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](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MDcxMTgtcHJvZHVjdC1vcmRlcmluZy1maWVsZC1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")** - [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author - [ Away](/forum/user/8351-verzevoul) Less More - Posts: 1195 - Thank you received: 13 - - 3 years 1 month ago [\#355857](#355857) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[Product Ordering field issue](/forum/26-product-category-display/907118-product-ordering-field-issue#355857 "-- 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 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MDcxMTgtcHJvZHVjdC1vcmRlcmluZy1maWVsZC1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86540 - Thank you received: 14300 - - 3 years 4 weeks ago [\#355859](#355859) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Ordering field issue](/forum/26-product-category-display/907118-product-ordering-field-issue#355859 "-- 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 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](/forum/user/8351-verzevoul "View verzevoul's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3Byb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MDcxMTgtcHJvZHVjdC1vcmRlcmluZy1maWVsZC1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.069 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)