I use magento 2.2.3 with few thousand products. How to update tax id for all my products with a sql query?

Our products have no product tax. I just wanna add product tax to all products (19%).

  • use update attribute from mass action – Vivek Jun 13 '18 at 11:18

create a tax class id and attach that to all product using mass action of product grid and then select update attribute to change attribute for all products

  • will not work, because i have more then 50.000 products – Tommy Jun 13 '18 at 11:21
  • then you can use product import/ export feature and add tax class id to the export csv. Only keep sku and tax class in csv and import the products – Vivek Jun 13 '18 at 11:23
  • start it. Upload is working and i see a please wait graphic since 40 minutes (50.000 products). I hope it's running in background... :-) – Tommy Jun 13 '18 at 12:08
  • import is done. In admin product detail page the tax is updated correct. I reindex, clean and flush cache. But frontend product detail page the the tax is not shown – Tommy Jun 13 '18 at 13:51
  • tax will not show on frontend for product details page – Vivek Jun 14 '18 at 6:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.