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!
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.
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.
Who is online
Users browsing this forum: DesignCart and 47 guests