Adding tax to 2000 products, but would like to make gross price the same as it is now

Hi,
I'm about to do a php change to make all my products include tax.
However, we are absorbing the cost of tax (15%)
So a $50 item will still cost $50 but include tax.

How would I mass update all prices to reduce the net price by 15%? (so that the gross becomes the current $ at least)
Thanks!

Are you looking to configure your store to ADD vat @ 15%, so the invoice (checkout confirmation) reflects the tax amount?

If you want to REDUCE all prices by 15%, then you DIVIDE all your prices by 1.15

$115 DIVIDED BY 1.15 = $100

Using SQL via PHPMYADMIN, the following should work...

BACKUP DBASE FIRST !

UPDATE zen_products SET products_price = products_price/1.15;
(This assumes the table HAS the zen_ prefix)

UPDATE products SET products_price = products_price/1.15;
(This assumes the table DOES NOT HAVE s the zen_ prefix)

Thanks for the reply Schoolboy...
Yes, was needing to include our NZ tax into our current prices (not add on top)

For anyone else needing to do this, I inserted:

1. update products set products_price = products_price / 1.15, products_price_sorter = products_price_sorter / 1.15, products_last_modified = now();
   
   ****
   **2)
   ** UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0;

At least it seems to have worked so far.
Thanks again for always helping...

Yeah... that all looks clean emough...