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 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

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:

$queryTables[] = 'hk_'.$string;

$queryTables[] = 'hk_'.$string['table'];

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

Not unique table/alias: 'hk_price' SQL=UPDATE orv_hikashop_product AS hk_product LEFT JOIN orv_hikashop_price AS hk_price ON hk_price.price_product_id = hk_product.product_id LEFT JOIN orv_hikashop_price AS hk_price ON hk_price.price_product_id = hk_product.product_id SET hk_price.price_list = hk_price.price_value WHERE hk_product.product_id IN (3,4,5,7,8,9,10,11,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,12,33,34,36,37,38,40,41,43,44,45,46,47,35,39,42,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,93,94,96,98,99,100,101,102,103,104,105,107,108,109,111,112,113,114,115,116,117,118,119,120,121,122,123,124)

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
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!

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

Thank You