Jump to content

MySQL request to get HT price from TTC price


kolorslab

Recommended Posts

Hi,

I need to got - with only a 20% TVA - get for all my products a MySQL request to get HT prices form the TTC prices cause all prices in DB are the same for the HT and the TTC price value.

I work on PS1.7.6.3 and i need to convert the TTC price to HT price in the HT products price value.

I have search but i don't know how to get a MySQL request to get HT values in the DB from the TTC prices.

I have to change the value from the TTC price with 20% TVA ton get the HT price value for al products.

Someone has an idea and can give me some ideas to update the value of HT prices from the TTC price to get -20% in the HT value.

Thanks for your help guys

Best

kolorslab

 

 

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...