- Posts: 38
- Thank you received: 0
change order of charateristics
14 years 4 months ago #52501
by chocovo
change order of charateristics was created by chocovo
Hello,
Todays, after 9 month with hiskashop, I needed to add new characteristics to my products.
Now characteristics appear like this:
From 5 to 19
From 20 to 49
From 50 to 99
From 1 to 4 <-- New characteristic
From 100 to 199 <-- New characteristic
I don't see anywhere where Can I edit the order...
How can i order it:
From 1 to 4
From 5 to 19
From 20 to 49
From 50 to 99
From 100 to 199
Thanks and regards
Todays, after 9 month with hiskashop, I needed to add new characteristics to my products.
Now characteristics appear like this:
From 5 to 19
From 20 to 49
From 50 to 99
From 1 to 4 <-- New characteristic
From 100 to 199 <-- New characteristic
I don't see anywhere where Can I edit the order...
How can i order it:
From 1 to 4
From 5 to 19
From 20 to 49
From 50 to 99
From 100 to 199
Thanks and regards
Please Log in or Create an account to join the conversation.
14 years 4 months ago #52555
by nicolas
Replied by nicolas on topic Re: change order of charateristics
Hi,
You need to delete the values and add them again in the correct order.
You need to delete the values and add them again in the correct order.
Please Log in or Create an account to join the conversation.
14 years 3 months ago - 14 years 3 months ago #55695
by chocovo
Replied by chocovo on topic Re: change order of charateristics
Hello,
If I delete them, I will lose all the price combinations, isn't it?
Is it possible to edit the order via PhpMyadmin?
If I delete them, I will lose all the price combinations, isn't it?
Is it possible to edit the order via PhpMyadmin?
Last edit: 14 years 3 months ago by chocovo.
Please Log in or Create an account to join the conversation.
14 years 3 months ago - 14 years 3 months ago #55696
by chocovo
Replied by chocovo on topic Re: change order of charateristics
.
Last edit: 14 years 3 months ago by chocovo.
Please Log in or Create an account to join the conversation.
14 years 3 months ago #55761
by nicolas
Replied by nicolas on topic Re: change order of charateristics
You will indeed loose the price combinations.
The ordering is done either alphabetically or based on the id of the characteristic value. Changing the characteristic id can be done in the hikashop_charactersitic table, but be careful as the products are linked to the id via the cross table hikashop_variant. You will have to update the characteristic id values in that table too...
Or you would have to find a solution to have your values in an alphabetical order...
The ordering is done either alphabetically or based on the id of the characteristic value. Changing the characteristic id can be done in the hikashop_charactersitic table, but be careful as the products are linked to the id via the cross table hikashop_variant. You will have to update the characteristic id values in that table too...
Or you would have to find a solution to have your values in an alphabetical order...
The following user(s) said Thank You: chocovo
Please Log in or Create an account to join the conversation.
14 years 3 months ago - 14 years 3 months ago #55866
by chocovo
Replied by chocovo on topic Re: change order of charateristics
Hello Nicolas,
It's a pity not to able to change the order when the shop has hundreds products with several characteristics that determine the price.
Might be a good idea for future updates.
Thanks and Regards
Post data: I tried to order the characteristics values alphabetically but when I aply changes, they order by ID.
It's a pity not to able to change the order when the shop has hundreds products with several characteristics that determine the price.
Might be a good idea for future updates.
Thanks and Regards
Post data: I tried to order the characteristics values alphabetically but when I aply changes, they order by ID.
Last edit: 14 years 3 months ago by chocovo.
Please Log in or Create an account to join the conversation.
14 years 3 months ago #55869
by esotechie
Replied by esotechie on topic Re: change order of charateristics
Please Log in or Create an account to join the conversation.
14 years 3 months ago #55872
by esotechie
Replied by esotechie on topic Re: change order of charateristics
You need to use SQL to set the value in characteristic_alias in XXX_hikashop_characteristic to the correct order (e.g. 1,2,3 or a,b,c). Be careful not to change the alias for the parent characteristics.
Then you need to change the value of config_value to 'alias ' in XXX_hikashop_config for config_namekey='characteristics_values_sorting'
Nicolas may have forgotten, but he has already changed the code in the view.html.php for me, so that the function may be added in future.
Then you need to change the value of config_value to 'alias ' in XXX_hikashop_config for config_namekey='characteristics_values_sorting'
Nicolas may have forgotten, but he has already changed the code in the view.html.php for me, so that the function may be added in future.
Please Log in or Create an account to join the conversation.
14 years 3 months ago #55911
by nicolas
Replied by nicolas on topic Re: change order of charateristics
Ah yes, the possibility to sort by alias will actually be possible in next version of HikaShop.
That will allow you to do that without modifying the code (you changes will be compatible.
That will allow you to do that without modifying the code (you changes will be compatible.
Please Log in or Create an account to join the conversation.
Time to create page: 0.260 seconds