<div>
you do it entirely in woo commerce<br />
<a href="https://docs.woocommerce.com/document/setting-up-taxes-in-woocommerce/" rel="ugc">https://docs.woocommerce.com/document/setting-up-taxes-in-woocommerce/</a>
</div>


you do it entirely in woo commerce
https://docs.woocommerce.com/document/setting-up-taxes-in-woocommerce/ [https://docs.woocommerce.com/document/setting-up-taxes-in-woocommerce/]

<div>
I need to do nearly a 100 products and I didn't want to open them individually. &nbsp;Thus, the need for the sql query. &nbsp;I actually use AvaTax for my sales tax requirements and they have a tax code I need to add to several products.
</div>


I need to do nearly a 100 products and I didn't want to open them individually.  Thus, the need for the sql query.  I actually use AvaTax for my sales tax requirements and they have a tax code I need to add to several products.

sharingsunshine

<div>
This does what I asked but I didn't think about that I would need the name of the product too when it comes to the select option. &nbsp;So I have created another question as a follow-on.<br />
<br />
<a href="https://www.experts-exchange.com/questions/29113925/Existing-Query-Needs-3-More-Fields-Added.html#questionAdd" rel="ugc">https://www.experts-exchange.com/questions/29113925/Existing-Query-Needs-3-More-Fields-Added.html#questionAdd</a>
</div>


This does what I asked but I didn't think about that I would need the name of the product too when it comes to the select option.  So I have created another question as a follow-on.

https://www.experts-exchange.com/questions/29113925/Existing-Query-Needs-3-More-Fields-Added.html#questionAdd [https://www.experts-exchange.com/questions/29113925/Existing-Query-Needs-3-More-Fields-Added.html#questionAdd]

<div>
<div class="content wysiwyg-content">
I need to update my mysql table for tax codes in woo commerce 3.4. &nbsp;What query would I used to put in tax code PH400930 for all products in the essentials_oil category?<br />
<br />
Thanks,
</div>
</div>


I need to update my mysql table for tax codes in woo commerce 3.4.  What query would I used to put in tax code PH400930 for all products in the essentials_oil category?

Thanks,

Need SQL To Change Tax Code in Woo Commerce

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.