Jump to content

problem with taxes (maybe with our client, who use PS)


Recommended Posts

Hello, my friends,

i have question, our client has included about 2500 products to prestashop without tax, but with the end-price (in th column price in products table is price with tax, but id_tax is 0).

I need help from you, can you somebody give me the right SQL UPDATE to upgrade price.

price column is now something, for exapmle 199 Kč (yes, Im from Czech Republic) I need to upgrade prise in the column to 199/100*81 (VAT is 19%), The update of ID in products is commonplace and I have done it.

The issue will be tax 19% and price in column price like 167,xxxxxx for example what I use upper.

Problem is displayed in the bill, where price with or without vat is same, for this I must resolve it.

So sorry for my english.


Share this post

Link to post
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...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More