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

[alien]

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

[JAKCRABBIT]

BO - Plaby - Daňové sazby - Povolit DPH -> NE

BO - Nastavení - Produkty - Zobrazení cen -> Bez DPH