Jump to content

Massive tax update via phpmyadmin


Recommended Posts

Hello!

I have in my store based on Prestashop 8.0 all products without tax, I would like, using SQL command to set VAT 23% for all products, but not to inflate the price by this 23%, but to include this 23% in the current price of the product, that is, if something is now 100$ (without tax) then to be 100$ gross and net 81,30 after the change, I would like to do this for products with ID 400 to 5100. Can you help me guys? Thanks in advance!

Link to comment
Share on other sites

Easiest way would probably be a csv file.

Use

Export Products Module v2.7.1 - by Oavea - oavea.com

Export file then modify columns E Price tax excluded and F Tax rules ID

Thn after backing up database import the file

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...