change order of charateristics

  • Posts: 38
  • Thank you received: 0
12 years 5 months ago #52501

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

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

  • Posts: 82820
  • Thank you received: 13368
  • MODERATOR
12 years 5 months ago #52555

Hi,

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.

  • Posts: 38
  • Thank you received: 0
12 years 4 months ago #55695

Hello,

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: 12 years 4 months ago by chocovo.

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

  • Posts: 38
  • Thank you received: 0
12 years 4 months ago #55696

.

Last edit: 12 years 4 months ago by chocovo.

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

  • Posts: 82820
  • Thank you received: 13368
  • MODERATOR
12 years 4 months ago #55761

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 following user(s) said Thank You: chocovo

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

  • Posts: 38
  • Thank you received: 0
12 years 4 months ago #55866

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.

Last edit: 12 years 4 months ago by chocovo.

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

  • Posts: 180
  • Thank you received: 13
12 years 4 months ago #55869

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

  • Posts: 180
  • Thank you received: 13
12 years 4 months ago #55872

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.

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

  • Posts: 82820
  • Thank you received: 13368
  • MODERATOR
12 years 4 months ago #55911

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.

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

Time to create page: 0.079 seconds
Powered by Kunena Forum