Post by BigLarry » Wed Oct 17, 2018 8:05 pm

Ever since the first version this has been around - I've tried buying fixes, free fixes and fixing it myself but for the life of me I cannot see how to get the Option Values to display in sort_order value when you're editing a product!

Perhaps it's something really easy but I just can't see how it's done:

$option_value_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "option_value ov LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE ov.option_id = '" . (int)$option_id . "' AND ovd.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY ov.sort_order, ovd.name desc");

Should do it, the query in phpmyadmin displays them in sort_order but they render to the page in what I think is alphabetical order.

Help!

Newbie

Posts

Joined
Wed Oct 17, 2018 8:02 pm

Post by cyclops12 » Thu Oct 18, 2018 12:22 am

The sort order for product options are sorted via the catalog/options page in admin

Expert Member

Posts

Joined
Sun Sep 27, 2015 1:10 am

Post by etcomputing » Thu Nov 22, 2018 12:51 am

So for example, you create an option named 'Volume' with the following Option Value, Sort Order:

1L, 1
2L, 2
10L, 10

Then you go into a product and add 'Volume', click on 'Add Option Value' and the drop-down shows:

1L
10L
2L

instead of:

1L
2L
10L

Correct? If so, that's the same problem I'm having.

Newbie

Posts

Joined
Thu Nov 22, 2018 12:45 am
Who is online

Users browsing this forum: DesignCart and 47 guests