How to take into account the balance and frequency of requests in the sorting of goods on the site?

Question

Mathematics

Initially, the idea was to sort products by frequency in Wordstat. But besides this, an important parameter is the balance of goods in the supplier's warehouse. In addition, there are goods for which there is no frequency, but the supplier holds a lot of them, because. Due to the price, customers prefer them.
How can both of these parameters (frequency + remainder) be taken into account when sorting in order to give the client the most suitable goods at the beginning?
It may also be necessary to take into account the quantity of goods, because. one product balance is 1000pcs * 50 rubles = 50 thousand, and the other 10pcs * 15000 rubles = 150 thousand. which one is the priority to show?

Answer 1

what's the question? there the answer up to k-means can stretch