JWCravers Posted July 13, 2005 Share Posted July 13, 2005 I have a problem in that my catalog was setup with every item not being set to a taxable item. I could go thru and edit every item (oer 300 of them) to taxable staus, or I could edit the products table, products_tax_class_id values from zero to 1. :blink: The only thing holding me back is that I really don't know SQL. It would seem a simple command but when I reseached it there are so many ways to this that I could easily screw thing up. Any help out there? Thanks Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 update products set products_tax_class_id = 1 where products_tax_class_id = 0; Link to comment Share on other sites More sharing options...
JWCravers Posted July 13, 2005 Author Share Posted July 13, 2005 update products set products_tax_class_id = 1 where products_tax_class_id = 0; <{POST_SNAPBACK}> Thank You! Thank You! Thank You! That just saved me hand editing 358 entries! :thumbsup: 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.