[Skip to main content](#vessel-content)

#   Characteristic values order

##

- **[Galassi](/forum/user/1609-galassi "View Galassi's Profile")**
- [![Galassi's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1609-galassi "View Galassi's Profile") Topic Author
- [ Offline](/forum/user/1609-galassi)

Less More

- Posts: 12
- Thank you received: 0
-
-

15 years 7 months ago [\#11921](#11921) by [Galassi](/forum/user/1609-galassi "View Galassi's Profile")  *[Characteristic values order](/forum/3-bug-report/11921-characteristic-values-order#11921 "Hi, I created the characteristic weight (g).  However, as see attached image; the various values are not sorted according to the ID.  Can I have values sorted according to ID?  The management of variant-products would be more simple.  Joomla 1.5.22 Hikashop Essenzial 1.4.8.  Sincerely, Alessandro.")* was created by *[Galassi](/forum/user/1609-galassi "View Galassi's Profile")*

Hi,
I created the characteristic weight (g).

However, as see attached image; the various values are not
sorted according to the ID.

Can I have values sorted according to ID?

The management of variant-products would be more simple.

Joomla 1.5.22
Hikashop Essenzial 1.4.8.

Sincerely,
Alessandro.  [ ![&#91;img](http://www.hikashop.com/media/kunena/attachments/legacy/images/Img.jpg) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/Img.jpg "&#91;img")

- [ ![Img.jpg](/forum/attachment/793) ](/forum/attachment/793 "Img.jpg") [ ](/forum/attachment/793?download=1 "Img.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMTkyMS1jaGFyYWN0ZXJpc3RpYy12YWx1ZXMtb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86552
- Thank you received: 14304
-
-

15 years 7 months ago [\#11930](#11930) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Characteristic values order](/forum/3-bug-report/11921-characteristic-values-order#11930 "Hi, I created the characteristic weight (g).  However, as see attached image; the various values are not sorted according to the ID.  Can I have values sorted according to ID?  The management of variant-products would be more simple.  Joomla 1.5.22 Hikashop Essenzial 1.4.8.  Sincerely, Alessandro.")*

Hi,

In the config under the tab "display" you have the option "Characteristics values ordering" where you can choose to order them by ID or by alphabetic order.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMTkyMS1jaGFyYWN0ZXJpc3RpYy12YWx1ZXMtb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Galassi](/forum/user/1609-galassi "View Galassi's Profile")**
- [![Galassi's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1609-galassi "View Galassi's Profile") Topic Author
- [ Offline](/forum/user/1609-galassi)

Less More

- Posts: 12
- Thank you received: 0
-
-

15 years 7 months ago [\#11939](#11939) by [Galassi](/forum/user/1609-galassi "View Galassi's Profile")  Replied by *[Galassi](/forum/user/1609-galassi "View Galassi's Profile")* on topic *[Re: Characteristic values order](/forum/3-bug-report/11921-characteristic-values-order#11939 "Hi, I created the characteristic weight (g).  However, as see attached image; the various values are not sorted according to the ID.  Can I have values sorted according to ID?  The management of variant-products would be more simple.  Joomla 1.5.22 Hikashop Essenzial 1.4.8.  Sincerely, Alessandro.")*

Hi,
the recommended setting is already set to ID.

I note that in the frontend the various values ​​are properly ordered.
In the backend are not properly sorted.
As shown in the image attached to the previous message.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMTkyMS1jaGFyYWN0ZXJpc3RpYy12YWx1ZXMtb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86552
- Thank you received: 14304
-
-

15 years 7 months ago [\#11944](#11944) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Characteristic values order](/forum/3-bug-report/11921-characteristic-values-order#11944 "Hi, I created the characteristic weight (g).  However, as see attached image; the various values are not sorted according to the ID.  Can I have values sorted according to ID?  The management of variant-products would be more simple.  Joomla 1.5.22 Hikashop Essenzial 1.4.8.  Sincerely, Alessandro.")*

Ah yes, in that view there is no ordering done. Is that a problem ?

You can change the line:
$query = 'SELECT * FROM '.hikashop::table('characteristic').' WHERE characteristic_parent_id = '.$characteristic_id;

by:
$config =&amp; hikashop::config();
if($config-&gt;get('characteristics_values_sorting')=='old'){
$order = 'characteristic_id ASC';
}else{
$order = 'characteristic_value ASC';
}
$query = 'SELECT * FROM '.hikashop::table('characteristic').' WHERE characteristic_parent_id = '.$characteristic_id.' ORDER BY '.$order;

in the file administrator/components/com_hikashop/views/characteristics/view.html.php in order to get it ordered.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMTkyMS1jaGFyYWN0ZXJpc3RpYy12YWx1ZXMtb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[davcraiguk](/forum/user/1706-davcraiguk "View davcraiguk's Profile")**
- [![davcraiguk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1706-davcraiguk "View davcraiguk's Profile")
- [ Offline](/forum/user/1706-davcraiguk)

Less More

- Posts: 34
- Thank you received: 0
-
-

15 years 6 months ago [\#14591](#14591) by [davcraiguk](/forum/user/1706-davcraiguk "View davcraiguk's Profile")  Replied by *[davcraiguk](/forum/user/1706-davcraiguk "View davcraiguk's Profile")* on topic *[Re: Characteristic values order](/forum/3-bug-report/11921-characteristic-values-order#14591 "Hi, I created the characteristic weight (g).  However, as see attached image; the various values are not sorted according to the ID.  Can I have values sorted according to ID?  The management of variant-products would be more simple.  Joomla 1.5.22 Hikashop Essenzial 1.4.8.  Sincerely, Alessandro.")*

Having to change the core to do a sort, especially in the product variant listing, is surely not the best way.

Most lists in Joomla it is possible to click on the column headings to do a sort.

This would be really useful for me (and others I am sure) where I have multiple variant products, i.e 5 sizes and a 3 choices of colour for each size, thats 15 variant products.

does it take much coding to implement this, where you have a choice of which column you can sort on like you have on the main products listing page?

Like in the main products listing: Code:

&lt;a title="Click to sort by this column" href="javascript:tableOrdering('b.product_name','desc','');"&gt;Name&lt;/a&gt;

It means its much easier to maintain the variants e.g prices etc.

---

David Craig
Hikashop 1.5.0 Business edition
[ www.charitycanvasprints.com](http://www.charitycanvasprints.com)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMTkyMS1jaGFyYWN0ZXJpc3RpYy12YWx1ZXMtb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86552
- Thank you received: 14304
-
-

15 years 6 months ago [\#14623](#14623) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Characteristic values order](/forum/3-bug-report/11921-characteristic-values-order#14623 "Hi, I created the characteristic weight (g).  However, as see attached image; the various values are not sorted according to the ID.  Can I have values sorted according to ID?  The management of variant-products would be more simple.  Joomla 1.5.22 Hikashop Essenzial 1.4.8.  Sincerely, Alessandro.")*

That modification has been integrated in the latest version of HikaShop so no need to hack the core to have your values sorted by name there.

There is no point in sorting variants. Variants are combinations of values of characteristics. Sorting the values of the characteristics is what need to be done and it's already in the todo list.

We don't have the time to do all the features everyone is asking. HikaShop's code is open. If you want it help yourself. We will be happy to integrate the changes in HikaShop if they are done correctly.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMTkyMS1jaGFyYWN0ZXJpc3RpYy12YWx1ZXMtb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.055 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
