sql query issues

[socom]

Hi having some issue need to do the following via sql

 

 

What do i need to type for the following

 

 

1) to reduce all NET prices by 20% (/1.2)

 

2) change all product from taxable good NONE to taxable goods

 

 

Laurence

[burt]

You will find useable code at http://www.oscommerce.com/forums/topic/389955-useful-snippets-of-code/

 

Ensure to backup your database prior to using phpmyadmin.

[socom]

ok thanks im unable to find the table for the net price though?

 

 

as i dont want the gross price to change when i change to taxable goods?

[socom]

or is products_price the net price then tax added on via script?

[♥bruyndoncx]

or is products_price the net price then tax added on via script?

yes

[socom]

would these codes work ok?

 

To lower price by 20%

UPDATE `products` SET `products_price` = (ceil(`products_price`)/1.20);

 

and

change tax from non (0) to taxable goods 1?

UPDATE products SET products_tax_class_id='1 WHERE something='0';

[♥bruyndoncx]

a 20% discount is * 0.8 --> 100 becomes 80

going from 80 to 100 is actually a 25% increase (ie 25% VAT rate on 80 excl VAT price)

so rethink the exact value to use in your calculation

 

 

update products set products_tax_class_id = 1 where (products_tax_class_id is null or products_tax_class_id = 0)

[socom]

example 100 /1.2 = £83.33 then x 20% brings it back to 100?

 

Laurence

[♥bruyndoncx]

example 100 /1.2 = £83.33 then x 20% brings it back to 100?

 

Laurence

I'm sorry, isn't that basic math skills ?

are you saying 20% VAT will bring it to 100 ? yes, it should

[socom]

im sorry but yes but im just trying to double check before i run it all. im not a coder or a programmer and just making sure i do it correct first. after your last message i was double checking.