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, 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.




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

Active Member


Sun Sep 27, 2015 1:10 am
Who is online

Users browsing this forum: No registered users and 6 guests