Easy question about "Taxable Goods"

[zxedxz]

Hi,

 

I already have like 200 products added. Is there a way to make them all "Taxable Goods" without having to change that to each single product?

 

I know easy populate can do that, but some of my products don't have a product number, therefore it won't work.

 

maybe using the database directly? Or a loop? Anyone can give me an easy way?

[Guest]

do it via the database via phpmyadmin

[zxedxz]

How? Do I just change replace the none with the word "taxable goods"? That it? I also noticed that if I choose traxable goods in the admin, the gross amount also change. What does this mean? What I want is to add the tax later in the check out.

 

Thanks for your help.

 

By the way, any way to make the "taxable good" the highlighed option in the admin add product?

[Guest]

go to phpadmin

 

browse tax_class table make a record of the tax_class_id field for "taxable goods"

 

select the products table then select sql then enter this in the run SQL query box

update products set products_tax_class_id = <the number you recorded from the tax_class table>

backup your dbase first just in case

[ValleyRoaster]

go to phpadmin

 

browse tax_class table make a record of the tax_class_id field for "taxable goods"

 

select the products table then select sql then enter this in the run SQL query box

update products set products_tax_class_id = <the number you recorded from the tax_class table>

backup your dbase first just in case

 

 

 

I had to alter the above sql to this

 

UPDATE `products` SET `products_tax_class_id` =1

 

or whatever id you choose from your tax_class_id

 

It worked great!