I placed a sort order condition in my product collection . I need to sort my products in the order of
Promotional products -> quantity available
In promotional products, i need to sort based on promotion to date i.e the products with nearest expiry date should be sorted first.
I'm not getting the condition to sort the promotional products based on their promotion to date.
please help me... Thanks in advance....