nickfromtq Posted October 19, 2011 Share Posted October 19, 2011 Hi, Many of my items have been setup with 0 quantity, can some please let me know of an SQL statement that will increase all products with 0 stock to 1. Any help would be very much appreciated. Thank you kindly Kind regards Nick Link to comment Share on other sites More sharing options...
razaro Posted October 19, 2011 Share Posted October 19, 2011 Backup your database first, just in case,andtry this UPDATE `ps_product` SET `quantity`='1' WHERE `ps_product`.`quantity` = 0 Link to comment Share on other sites More sharing options...
Recommended Posts