How to filter stock in all products page (admin panel)?

[dungminh86]

How to filter inventory from high to low on the all products page?

I mean, filtering inventory to check stock status is a fairly basic and commonly used operation in e-commerce, to see which products have high or low stock levels, sorted from high to low or low to high.

Thank,

[aimeos]

This isn't available out of the box because it's very seldom that someone needs product sorting based on stock level. In Aimeos, volatile stock levels are separated from stable product data (stocks are updated very often vs. products only from time to time) for performance reasons and it's one of the reasons why Aimeos is so fast. If you really need this feature, you would need to query the stock level from the product index manager by joining the tables there.

[dungminh86]

In business (perhaps in my business), the action of viewing inventory from high to low or low to high is quite frequent, as one of the key tasks of the sales department is to check which products have the highest stock levels to plan to sell off the inventory, as well as which products have the lowest stock levels to plan for discontinuing those items. I believe that many sellers are also quite concerned about products with the highest and lowest stock levels, just like I am. So, could you guide me on how to connect the tables?

[aimeos]

In the admin backend, the best option would be to implement a separate panel for stock levels which can be sorted and add the product information as related items:
https://aimeos.org/docs/latest/admin/jq ... nt-panels/

If you can create a PR, we will merge it into the next version so you don't have to care about it in future versions any more.