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.
Who is online
Users browsing this forum: No registered users and 6 guests