Thank you for this interesting question. I assume that every item assigned to the “Retail items on sale” category is also assigned to the parent “Retail items” category; is that right? Are there any other child categories under the “Retail items” parent? Which taxonomy are you using for these terms?
I can think of two general solutions:
- Display the items in two separate galleries: 1) items not on sale, and 2) items on sale.
- Query the database for all “Retail items” and then add some PHP code using the hooks provided by MLA to re-order the results as you want them.
Would the first alternative work for your application? If not, would the PHP-based solution work? The code could be added to your theme’s functions.php file or packaged in a small custom plugin.
You could also use a custom field, assigning a non-zero value to all items on sale. It’s a bit manual but wouldn’t be too bad with MLA’s ability to filter the Media/Assistant submenu table by category and then the Bulk Edit area to modify the values all at once.
Any additional information you can provide would help me be more specific. Thanks for your interest in the plugin.
It has been a month since my last post in this topic and I have seen nothing further. I assume you have found a solution that fits your application.
I am marking this topic resolved, but please update it if you have any questions regarding my earlier suggestions.