Product display with cheapest price first.

  • Posts: 1
  • Thank you received: 0
9 years 4 months ago #238517

hi. i am currently evaluating the hikahsop free version. i really like it, even though the category display and product listing took some time to understand and configure.

i currently display all products in a table layout when i click on category. i want to further sort this list to display the cheapest price first. i have looked at the sort fields in the hidden menus product listing menu that i created. i cannot seem to find the price field to sort on.

thanks

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

  • Posts: 84310
  • Thank you received: 13701
  • MODERATOR
9 years 4 months ago #238531

Hi,

There is no price field because there is no price field. Since you can have several prices for a product, they are stored in a separate table and thus you can directly sort on them.
You have two options:
- You manually sort them with the "order" column on the products listing of the backend.
- You create a custom field of the table "product" via the menu Display>Custom fields and then create a mass action with the trigger "on after product update" and an action "update the values" on the column of your custom field with the operation value price.price_value
Then, you can select that custom field for the ordering column of your products listing. You'll have to save once your products so that the custom fields get filled automatically with the price data or run your mass action once so that it does that automatically.
Please note that custom fields of the table "product" are only available with the Essential and the Business editions of HikaShop.

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

Time to create page: 0.055 seconds
Powered by Kunena Forum