Updating Tax Class using Easy-Populate

[Guest]

Hi,

 

I Have just uploaded 700 products to my store and i'm having trouble udating all information that needs updated. I am using easy-populate to upload the information into the database. I'm getting everything to work except for the tax-class. We have 2 tax class defined in our store. (GA, NONE) The default setting is "NONE". How can I use easy-populate to update the tax-class of the 700 products to GA that I have just posted.

 

American PC Sales

[email protected]

[mrguytx]

I would love to see the answer to this.

 

There should be an even easier way to just edit the table in the database to set this correctly.

[Geotex]

If you use phpMyAdmin or a similar program,

 

SQL query to set all products taxable:

UPDATE products SET products_tax_class_id = 1

 

SQL query to set all products non-taxable:

UPDATE products SET products_tax_class_id = 0

 

If you have your products in a spreadsheet, you can set specific items.

UPDATE products SET products_tax_class_id = 1 WHERE products_id = 1;

UPDATE products SET products_tax_class_id = 1 WHERE products_id = 12;

 

etc....

[mrguytx]

Thanks for the mySQL advice, but all my items are still showing as "none" instead of "Taxable Goods".

 

900 items, this will be fun hand editing one by one.

[Geotex]

Take a look at table tax_class.

 

tax_class_id is 1

tax_class_title is Taxable Goods.

 

 

SQL

 

UPDATE tax_class SET tax_class_title = "Taxable Goods", tax_class_description = "The following types of products are included non-food, services, etc." WHERE tax_class_id = 1

 

you should also be able to make the change in Admin, Tax Classes. Delete whatever is listed there and set a "new" tax class named Taxable Goods.