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

dungminh86 · Post by **dungminh86** » 10 Nov 2024, 10:42

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,

Post by **aimeos** » 11 Nov 2024, 09:32

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 · Post by **dungminh86** » 13 Nov 2024, 04:10

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?

Help for Aimeos