URGENT: tax PROBLEM

Site of a client of me is already live for months (but they apparently don't test it before going live as I asked them to) and now they see that there was no tax. So a product of € 50,= was € 50,= including and excluding tax.

I now have set it up right but all the prices of products are now 21% (tax rate in NL) to much. Because the system changed al the prices from example 50,= excluding plus 21%.

But there are already hundreds of products in the store. How can I cahnage al prices directly the right way. So system takes the 50,= As incuded tax price and do the math for the excluding price. 41.32.

Now it shows the price as 50 + tax is 60,50

Hi,

I think that the best solution would be to :
- Export your product trough a CSV file
- Directly change their price
- Import this file

Then you product prices will be updated.

Mohamed Thelji wrote: Hi,

I think that the best solution would be to :
- Export your product trough a CSV file
- Directly change their price
- Import this file

Then you product prices will be updated.

Thanks,

I did not think about that. Working on it now but it seems that in the export (dbase) there is only one value for price. That's price is with tax now, so I have to math the without tax price, so still a lot of work. Am working now on searching for a script that can ghange the cell value's line = * 0,8264462809917355 (than everything work fine)

Thanks,

Problem solved. I used the dbase code (scary) but worked like a charme. In a few seconds ALL prices changed.