Guest Posted December 31, 2005 Share Posted December 31, 2005 at present, i do not use the stock quantity function, so some products have 0, -1 or -10 values for their stock number. how could i do a bulk update and for every product that is 0 or below, assign it 99 instead... via phpmyadmin Link to comment Share on other sites More sharing options...
vasttech Posted January 1, 2006 Share Posted January 1, 2006 The following query should do the trick: update products set products_quantity = 99 where products_quantity <= 0 A good reference for mySQL help is at http://www.mysql.com osCommerce Knowledge Base osCommerce Documentation Contributions Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.