Jump to content

Archived

This topic is now archived and is closed to further replies.

Chris_Stewart

Updating Tax Class using Easy-Populate

Recommended Posts

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

cstewart@daltoncomputer.com

Share this post


Link to post
Share on other sites

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.


____________________________________

every day above ground is a good day.

Share this post


Link to post
Share on other sites

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....


GEOTEX from Houston, TX

 

(George)

Share this post


Link to post
Share on other sites

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.


____________________________________

every day above ground is a good day.

Share this post


Link to post
Share on other sites

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.


GEOTEX from Houston, TX

 

(George)

Share this post


Link to post
Share on other sites

×