6. Stock Helper¶
The stock helper screen is designed to help you to optimize your products stock levels and also to easily update their ideal & warning stock levels.
Please take a look at the Concepts section to better understand how are working warning & ideal stock levels.
Only simple and virtual products will be displayed in this grid, as others kind of products should not be stock managed, so not be useful in the Stock helper screen.
By the same way, simple and virtual products having the Magento inventory option “Manage stock” set to “No” will not be displayed in this screen.
The “Manage stock” option of each product can be found going into Catalog > Products grid, selecting a product, Advanced Inventory popup > Manage stock.
The stock helper grid is composed of the following columns :
- Sku / Product : product information. There can be several rows for the same product if it is associated to several warehouses
- Warehouse : Warehouse product is associated to
- Qty in warehouse : the physical quantity in the warehouse
- Available quantity : the quantity available for sales, it is equal to the physical quantity minus the quantity to ship for sales order
- Shipped for last XX weeks : this is the quantity of the product shipped for the last X weeks. You can configure the week ranges to use from
Stores > Configuration > Inventory Management > Sales History.
The statistics are not automatically updated, they only get updated with the run of an SSH command line.
You can add a cron task on this command line if you wish to get them automatically updated at a specific interval.
- Warning stock level / ideal stock level : the warning & ideal stock level for the product. By default it will use the default values (configurable in store > configuration > boostmyshop > inventory management). You can apply a custom value for one product unticking the checkbox and filling a custom value
- Qty to order : this is the quantity you have to order to vendor to ship pending sales order AND reach the ideal stock levels.
You can export the stock helper data in a CSV file using the
Export button located in the top-right corner of the screen.