Jump to content

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


alien
 Share

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.

Greetings,
Johny

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
 Share

×
×
  • Create New...

Important Information

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