title: How to run a SQL command to update some opencart products to non taxable items?
body: <p>I currently have about 4000 products in my Opencart 1.5.5.1 store, Currently ALL products are set to "taxable" items. I have about 500 of these products that are in fact "none taxable" products. </p>
  
  <p>I would like to be able to run a SQL command to update the 500 products using phpmyadmin to change the 500 products. I need to have set as NONE under the tax class in the products. </p>
  
  <p>Does anyone know how to complete such a task using a SQL commend?</p>
  
  <p>Here is part of the products DB file. This one is of two products I manually changed in opencarts admin area on two products - I made the tax class as NONE:</p>
  
  <pre><code>INSERT INTO `oc_product` (`product_id`, `model`, `sku`, `upc`, `ean`, `jan`, `isbn`, `mpn`, `location`, `quantity`, `stock_status_id`, `image`, `manufacturer_id`, `shipping`, `price`, `points`, `tax_class_id`, `date_available`, `weight`, `weight_class_id`, `length`, `width`, `height`, `length_class_id`, `subtract`, `minimum`, `sort_order`, `status`, `date_added`, `date_modified`, `viewed`, `call_for_price`, `custom_message`, `youtubevideo`) VALUES
  (1, 'AAJ - 101', 'AAJ - 101', 'AAJ - 101', '', '', '', '', '', 0, 5, 'data/Products/Americolor/Americolor-Black-Soft-Gel-Paste-.75oz.jpg', 1, 1, '0.0000', 0, 0, '2013-01-09', '0.00000000', 1, '0.00000000', '0.00000000', '0.00000000', 1, 1, 0, 1, 1, '2013-01-09 22:25:59', '2013-05-13 02:01:06', 10, 0, '', ''),
  (2, 'AAJ - 102', 'AAJ - 102', 'AAJ - 102', '', '', '', '', '', 0, 5, 'data/Products/Americolor/Americolor-Royal-Blue-soft-gel-paste-0.75oz.jpg', 1, 1, '0.0000', 0, 0, '2013-01-09', '0.00000000', 1, '0.00000000', '0.00000000', '0.00000000', 1, 1, 0, 1, 1, '2013-01-09 22:25:59', '2013-05-13 02:01:06', 4, 0, '', ''),
  </code></pre>
  
  <p>This is 2 of them that the Tax is assigned to:</p>
  
  <pre><code>(11, 'AAJ - 111', 'AAJ - 111', 'AAJ - 111', '', '', '', '', '', 0, 5, 'data/Products/Americolor/Americolor-Leaf-Green-Soft-Gel-Paste-.75oz.jpg', 1, 1, '0.0000', 0, 9, '2013-01-09', '0.00000000', 1, '0.00000000', '0.00000000', '0.00000000', 1, 1, 0, 1, 1, '2013-01-09 22:25:59', '2013-05-13 02:01:06', 6, 0, '', NULL),
  (12, 'AAJ - 112', 'AAJ - 112', 'AAJ - 112', '', '', '', '', '', 0, 5, 'data/Products/Americolor/Americolor-Mint-Green-Soft-Gel-Paste-.75oz.jpg', 1, 1, '0.0000', 0, 9, '2013-01-09', '0.00000000', 1, '0.00000000', '0.00000000', '0.00000000', 1, 1, 0, 1, 1, '2013-01-09 22:25:59', '2013-05-13 02:01:06', 6, 0, '', NULL)
  </code></pre>