Procuct List from lowest to highest

-- url of the page with the problem -- : www.polaris-ranger-razor-atv.it/home/dis...ry/48-rzr-razor.html
-- HikaShop version -- : last
-- Joomla version -- : 3.4.8

Hi, i want display the product from lowest to highest...

i can do?

Thank you in advamce for your anwser

Hello,
Sure, you'll just have to set the "Ordering" option of your product listing content menu/module to product_sort_price so that it can sort your products by their price.

Hi, Thank you for your answer
but i don't see the option product_sort_price you can click on the these link for
example image

maybe, looking for in the wrong place?

Cheers
Marco

Hi,

What Mohamed is proposing is not yet available in the current release of HikaShop.

For now you need to do like that:
- Create a custom field of the table "product" via the menu Display>Custom fields to store the prices for the sorting
- In your products listing menu/module use that custom field column name for the "ordering column"
- Create a mass action via the menu System>Mass actions with an action "update the values" on your custom field with the value price.price_value
When you run the mass action, it will copy the prices you set in your products in the custom field so that they can be used for the sorting on the listing. And you can add a trigger on the mass action so that it is run each time after a product is updated so that the ordering is maintained in the future when you modify the prices of the products in the backend.

Hi Nicolas, Thank you!

...But i don't undestand the step of the mass action, i created the my field price_list but afther the mass action the fields are empty.

i attached the image about setting my mass action where the field price_list is my costum field

Cheers
Marco

Hi,

You have to set it like that: take.ms/St7P1

Hi Xavier, thank you !

I set it and there is a small improvement, but comeback a error:

1054 Unknown column 'hk_price.price_list' in 'field list' SQL=UPDATE #_hikashop_product AS hk_product LEFT JOIN #_hikashop_price AS hk_price ON hk_price.price_product_id = hk_product.product_id SET hk_price.price_list = 0 WHERE hk_product.product_id IN

the suffix hk on my database is worng, but instead the tables i wrote in red are correct. ( the # is not real suffix i don't write the real suffix for security)

Thanks in advance for your help

Hi,

My bad, the type of the value must be "operation" and not "int".

Hi,
i changed the type of the value but comeback the same error :huh:

Hi,

Please give us a screenshot of how you set your mass action and another one for the way you set the custom field.
It seems that there is an issue on the column selected for the mass action and the one used for the custom field.

What is your HikaShop version ? (with numbers).

Hi,
well, i created my costum field in the product table :
Hika shop --> 2.6.1
Name my costum field--> price_list
tha image of the set --> click here

but i have a question, it's correct the suffix hk_price.price_list ? because my table have another suffix not hk

Thank you soo much for your help!

Hi,

There was indeed an issue, please edit the file "administrator/components/com_hikashop/classes/massaction.php" and replace the line: By:
Thank you for this report.

ok! same thing is changed, but comeback another error number 1066

for your information i replace the line 1799 on the file massaction.php

Hi,

Please provide a backend and FTP access via our contact form with a link to this topic in the url.
www.hikashop.com/support/contact-us.html

Hi,

I am not able to reach your backend but I added a patch on your website, that should fix the issue.
Please confirm that this is indeed the case

I test it but don't work again
I send you a private message on the forum whit joomla credential.

I have the credentials but when I try to login I get an error.
Connexion reset, load error.

Do you have any IP restrictions ?

who was there to set up a server-side protection ... I did not know :huh:
Now I disabled the protection and you can access whit this address:
polaris-ranger-razor-atv.it/administrator use the https


I'm sorry you can try right now, thanks

Hi,

I just understood the issue, it is due to the name of your custom field.
As the name starts with "price_" the system thinks that it is a price column.

Please do the same operation but on a custom product field having a name starting by anything else than "price_".

YES! :woohoo:

Work very well... i changed the name of the field to price_list from colonnaprezzi and now it's ok!

Thank You