How to sort the list in Bitrix in the product catalog by availability in several warehouses?

Question

1C-Bitrix

Hello! Is it possible in Bitrix to sort the list of goods by the balance in several warehouses?
We looked in the direction of transmission as the ELEMENT_SORT_FIELD parameter CATALOG_STORE_AMOUNT_.
But only two warehouses can be passed this way (the second one in ELEMNT_SORT_FIELD2), is it possible to pass an array of warehouses for sorting?

Answer 1

How do you imagine such sorting in SQL?
Create a property in the catalog IB. In it, using the handler, summarize the available quantity of goods from the warehouses you need.
And already by this property, sort in the catalog.