Help!...Allow ordering of out of stock items - 6500 products - SQL query to set allow on 0

[TTNZ]

Hi all,

 

I have 6500 products on my shop and I want to enable the stock management module, however I still want to allow all out of stock products to be ordered. 

 

I have set the product preferences to allow ordering of out of stock products but it keeps on saying "this product is no longer available" and the add to cart button is removed. 

 

Is there a SQL query I can run to default these products to allow for ordering when at 0? 

 

Thanks in advance

 

Prestashop 1.6.0.6