[Skip to main content](#vessel-content) # Product list order by cheapest price ## - **[gavin.evans](/forum/user/12042-gavin-evans "View gavin.evans's Profile")** - [![gavin.evans's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12042-gavin-evans "View gavin.evans's Profile") Topic Author - [ Offline](/forum/user/12042-gavin-evans) Less More - Posts: 12 - Thank you received: 1 - - 13 years 9 months ago [\#85920](#85920) by [gavin.evans](/forum/user/12042-gavin-evans "View gavin.evans's Profile") *[Product list order by cheapest price](/forum/2-general-talk-about-hikashop/77518-product-list-order-by-cheapest-price#85920 "Hi, I'm trying to order the product list by the cheapest price, each product has two prices assigned to them. the price I want to order by has a min quantity of 1 the other price has a min quantity of 2. I have tried using details from this thread www.hikashop.com/en/forum/4-how-to/57655...-cheapest-price.html But it does not work. Thanks Gavin")* was created by *[gavin.evans](/forum/user/12042-gavin-evans "View gavin.evans's Profile")* Hi, I'm trying to order the product list by the cheapest price, each product has two prices assigned to them. the price I want to order by has a min quantity of 1 the other price has a min quantity of 2. I have tried using details from this thread [ www.hikashop.com/en/forum/4-how-to/57655...-cheapest-price.html](http://www.hikashop.com/en/forum/4-how-to/57655-order-by-cheapest-price.html) But it does not work. Thanks Gavin Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NTE4LXByb2R1Y3QtbGlzdC1vcmRlci1ieS1jaGVhcGVzdC1wcmljZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 9 months ago [\#85967](#85967) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Product list order by cheapest price](/forum/2-general-talk-about-hikashop/77518-product-list-order-by-cheapest-price#85967 "Hi, I'm trying to order the product list by the cheapest price, each product has two prices assigned to them. the price I want to order by has a min quantity of 1 the other price has a min quantity of 2. I have tried using details from this thread www.hikashop.com/en/forum/4-how-to/57655...-cheapest-price.html But it does not work. Thanks Gavin")* Hi, Are you sure that you made the changes as explain ? Have you many products ? Because another solution exist, create a custom field for the product and set the price as value of this custom field, and then order on this custom field. It imply to edit each products, or you can do a sql request to fill the value of this custom field based on the price of the products. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NTE4LXByb2R1Y3QtbGlzdC1vcmRlci1ieS1jaGVhcGVzdC1wcmljZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[gavin.evans](/forum/user/12042-gavin-evans "View gavin.evans's Profile")** - [![gavin.evans's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12042-gavin-evans "View gavin.evans's Profile") Topic Author - [ Offline](/forum/user/12042-gavin-evans) Less More - Posts: 12 - Thank you received: 1 - - 13 years 9 months ago [\#86107](#86107) by [gavin.evans](/forum/user/12042-gavin-evans "View gavin.evans's Profile") Replied by *[gavin.evans](/forum/user/12042-gavin-evans "View gavin.evans's Profile")* on topic *[Product list order by cheapest price](/forum/2-general-talk-about-hikashop/77518-product-list-order-by-cheapest-price#86107 "Hi, I'm trying to order the product list by the cheapest price, each product has two prices assigned to them. the price I want to order by has a min quantity of 1 the other price has a min quantity of 2. I have tried using details from this thread www.hikashop.com/en/forum/4-how-to/57655...-cheapest-price.html But it does not work. Thanks Gavin")* Thanks for the reply, I decided to try and use the weight field to put the prices in, I have done this an all products, then gone into display > content menus then set the order by to product_weight but it is not working. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NTE4LXByb2R1Y3QtbGlzdC1vcmRlci1ieS1jaGVhcGVzdC1wcmljZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[gavin.evans](/forum/user/12042-gavin-evans "View gavin.evans's Profile")** - [![gavin.evans's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12042-gavin-evans "View gavin.evans's Profile") Topic Author - [ Offline](/forum/user/12042-gavin-evans) Less More - Posts: 12 - Thank you received: 1 - - 13 years 9 months ago [\#86109](#86109) by [gavin.evans](/forum/user/12042-gavin-evans "View gavin.evans's Profile") Replied by *[gavin.evans](/forum/user/12042-gavin-evans "View gavin.evans's Profile")* on topic *[Product list order by cheapest price](/forum/2-general-talk-about-hikashop/77518-product-list-order-by-cheapest-price#86109 "Hi, I'm trying to order the product list by the cheapest price, each product has two prices assigned to them. the price I want to order by has a min quantity of 1 the other price has a min quantity of 2. I have tried using details from this thread www.hikashop.com/en/forum/4-how-to/57655...-cheapest-price.html But it does not work. Thanks Gavin")* Thanks, got it resolved I still had the modifications from the post [ www.hikashop.com/en/forum/4-how-to/57655...-cheapest-price.html](http://www.hikashop.com/en/forum/4-how-to/57655-order-by-cheapest-price.html) in place after I removed it the ordering is working fine. Thanks again. The following user(s) said Thank You: [Jerome](/forum/user/80-jerome "View Jerome's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NTE4LXByb2R1Y3QtbGlzdC1vcmRlci1ieS1jaGVhcGVzdC1wcmljZT90bXBsPW1hcmtkb3du) or [Create an account](/register) 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.074 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)