[Skip to main content](#vessel-content)

#   Display products in price order

##

- **[Reev3r](/forum/user/11846-reev3r "View Reev3r's Profile")**
- [![Reev3r's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11846-reev3r "View Reev3r's Profile") Topic Author
- [ Offline](/forum/user/11846-reev3r)

Less More

- Posts: 26
- Thank you received: 0
-
-

7 years 2 weeks ago [\#312047](#312047) by [Reev3r](/forum/user/11846-reev3r "View Reev3r's Profile")  *[Display products in price order](/forum/26-product-category-display/898488-display-products-in-price-order#312047 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.12  Hi,  I have a list of products that I would like to display in price order by default.  I have tried setting the &quot;Ordering field&quot; in the menu to &quot;product&#95;sort&#95;price&quot; but this doesn't seem to affect all the products on the page. I have set up filters to &quot;sort by price&quot; which works correctly, but this requires a user activating them before the products get sorted.  Is there a way to have the same effect as the filter &quot;sort by price&quot; by default? OR can I set a filter to display by default (on page load?)  thanks")* was created by *[Reev3r](/forum/user/11846-reev3r "View Reev3r's Profile")*

-- HikaShop version -- : 4.2.1
-- Joomla version -- : 3.9.12

Hi,

I have a list of products that I would like to display in price order by default.

I have tried setting the "Ordering field" in the menu to "product_sort_price" but this doesn't seem to affect all the products on the page. I have set up filters to "sort by price" which works correctly, but this requires a user activating them before the products get sorted.

Is there a way to have the same effect as the filter "sort by price" by default? OR can I set a filter to display by default (on page load?)

thanks

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTg0ODgtZGlzcGxheS1wcm9kdWN0cy1pbi1wcmljZS1vcmRlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) 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: 86322
- Thank you received: 14281
-
-

7 years 2 weeks ago [\#312049](#312049) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Display products in price order](/forum/26-product-category-display/898488-display-products-in-price-order#312049 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.12  Hi,  I have a list of products that I would like to display in price order by default.  I have tried setting the &quot;Ordering field&quot; in the menu to &quot;product&#95;sort&#95;price&quot; but this doesn't seem to affect all the products on the page. I have set up filters to &quot;sort by price&quot; which works correctly, but this requires a user activating them before the products get sorted.  Is there a way to have the same effect as the filter &quot;sort by price&quot; by default? OR can I set a filter to display by default (on page load?)  thanks")*

Hi,

The "product_sort_price" choice of the "ordering field" is what I would recommend.
Note that this field is set by HikaShop each time to save a product in the backend interface.
If you import products via CSV, or a script, or modify the prices via the database or a mass action, the code to (re)calculate that product_sort_price won't be called.
That could explain why it doesn't work properly for some of your products.
An alternative to this would be to use the "sort by price" filter, and add the parameter of the filter in the URL of the page accessing the listing. But that's kind of a trick. It would be better to use the product_sort_price which is meant for that.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTg0ODgtZGlzcGxheS1wcm9kdWN0cy1pbi1wcmljZS1vcmRlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation.

- **[Reev3r](/forum/user/11846-reev3r "View Reev3r's Profile")**
- [![Reev3r's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11846-reev3r "View Reev3r's Profile") Topic Author
- [ Offline](/forum/user/11846-reev3r)

Less More

- Posts: 26
- Thank you received: 0
-
-

7 years 2 weeks ago [\#312093](#312093) by [Reev3r](/forum/user/11846-reev3r "View Reev3r's Profile")  Replied by *[Reev3r](/forum/user/11846-reev3r "View Reev3r's Profile")* on topic *[Display products in price order](/forum/26-product-category-display/898488-display-products-in-price-order#312093 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.12  Hi,  I have a list of products that I would like to display in price order by default.  I have tried setting the &quot;Ordering field&quot; in the menu to &quot;product&#95;sort&#95;price&quot; but this doesn't seem to affect all the products on the page. I have set up filters to &quot;sort by price&quot; which works correctly, but this requires a user activating them before the products get sorted.  Is there a way to have the same effect as the filter &quot;sort by price&quot; by default? OR can I set a filter to display by default (on page load?)  thanks")*

Hi,

Thanks for the extra information, I thought I had my settings wrong ![:)](/media/kunena/emoticons/3.png ":)")

I ended up exporting all the products then copying the "Price" column and pasting the data into the "product_sort_price" column, then importing all the products again.

This seems to have fixed the issue when I set "product_sort_price" as the new option.

thanks for the help ![:)](/media/kunena/emoticons/3.png ":)")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTg0ODgtZGlzcGxheS1wcm9kdWN0cy1pbi1wcmljZS1vcmRlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.047 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
