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!
Re: Adding tax to 2000 products, but would like to make gross price the same as it is
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)
Re: Adding tax to 2000 products, but would like to make gross price the same as it is
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) [FONT=Calibri]update products set products_price = products_price / 1.15, products_price_sorter = products_price_sorter / 1.15, products_last_modified = now();[/FONT]
[FONT=Calibri]
[/FONT]
2)
[FONT=Calibri]UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0;[/FONT]
At least it seems to have worked so far.
Thanks again for always helping...
Re: Adding tax to 2000 products, but would like to make gross price the same as it is
Yeah... that all looks clean emough...