Help with a tax issue

[Extrem94]

Hi,
I'd like to know if there is a way to globally change the products 's "net", "gross" value, I did not enter the products at first with the "taxable goods" option selected. I decided to update the table taxable ID row with the correct ID 1.
Now it calculed "removed" the tax from the gross
Example:


Sub-Total:$719.04


$0.00
Store Pickup (Walk In):




FL TAX 7.0%:$47.04




Total:$719.04

The net price of the product should be 719.04 and total should be $719.04 +&50.33




Help please !!

[Extrem94]

Hi all,
I'm looking for the SQL statement to update the product price table;
Something like update gross price with net price.
Thank you in advance

[stagebrace]

http://www.w3schools.com/sql/sql_update.asp

UPDATE products
SET products_price = new_value
WHERE products_model = some_text

[Extrem94]

Wow,
That's what I needed...
Thank you so much for you help.