[Skip to main content](#vessel-content)

#   How to change product tax id for all products

##

- **[an\_0815](/forum/user/732-an-0815 "View an&#95;0815's Profile")**
- [![an&#95;0815's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/732-an-0815 "View an&#95;0815's Profile") Topic Author
- [ Offline](/forum/user/732-an-0815)

Less More

- Posts: 26
- Thank you received: 0
-
-

15 years 8 months ago [\#9603](#9603) by [an\_0815](/forum/user/732-an-0815 "View an&#95;0815's Profile")  *[How to change product tax id for all products](/forum/4-how-to/9603-how-to-change-product-tax-id-for-all-products#9603 "Hello, how can I change the product tax id for all available products in one go? Say you add a new tax id and want to change it for all products. Is there one command for it?")* was created by *[an\_0815](/forum/user/732-an-0815 "View an&#95;0815's Profile")*

Hello,
how can I change the product tax id for all available products in one go?
Say you add a new tax id and want to change it for all products. Is there one command for it?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzk2MDMtaG93LXRvLWNoYW5nZS1wcm9kdWN0LXRheC1pZC1mb3ItYWxsLXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 8 months ago [\#9618](#9618) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: How to change product tax id for all products](/forum/4-how-to/9603-how-to-change-product-tax-id-for-all-products#9618 "Hello, how can I change the product tax id for all available products in one go? Say you add a new tax id and want to change it for all products. Is there one command for it?")*

The easiest is to note the id of your tax category somewhere, then, go in your phpmyadmin and run the query below after replacing XX with the id of your product category:

UPDATE jos_hikashop_product SET product_tax_id=XX

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzk2MDMtaG93LXRvLWNoYW5nZS1wcm9kdWN0LXRheC1pZC1mb3ItYWxsLXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.040 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
