how i generate report or check in backoffice for Minimum quantity product

[vishalsingh119]

I want to see all product with minimum quantity on top ,after this i directly fill my stock with more product.so how it is possible in prestashop that i download report for minimum quantity product or check on prestashop that this product is less than minimum quantity.

 

Note-mail alert option i have,but i need report option or directly check minimum stock product on top.

[vekia]

 

 

I want to see all product with minimum quantity on top

Where you want to see these products? 

What is the minimum quantity? you mean that you want to display minimum quantity field?

 

 

 

that i download report for minimum quantity product 

let's clarify what you mean by "minimum quantity" because each product can have own minimum quantity. 

you mean that you wan to display products that have forexample less than X quantity?

[vishalsingh119]

Thanks for reply,i am waiting for your reply vekia.

 

Minimum quantity i set 3,so i want if any product quantity with specific combination  less or equal to 3 ,so somewhere in prestashop it display that this product quantity is less then 3,kindly refill product.

 

And i already activate advanced stock management,so in stats>product quantity ,its showing product quantity with all combination like 200.

 

Kindly guide me.is this requirement need module or some php or sql code or what

[vekia]

you can create sql query in adv. parameters > sql  manager:

select pl.name, ps.quantity FROM ps_product p
INNER JOIN ps_product_lang pl on p.id_product = pl.id_product
INNER JOIN ps_stock_available ps on p.id_product = ps.id_product
WHERE pl.id_lang = 1 AND ps.quantity <=3

where pl.id_lang is an id of your language 

 

the effect will be list of products with less than or equal 3 quantity 

 

it displays several instances of products because it checks also combinations within selected product

[vishalsingh119]

That query working perfectly Vekia.You are Hero of prestashop.

[vekia]

im glad that i could help you in this case :-)