News:

AbanteCart v1.4.2 is released.

Main Menu
support

Bulk Tax Class Change

Started by Awirges, June 25, 2015, 03:11:18 PM

Previous topic - Next topic

Awirges

So I entered over 300 items into our store, and forgot to change tax class on quiet a few of them. Is there anyway to apply one tax class across all 300+ items?

abolabo

yes.. you can run sql in phpMyAdmin and update column tax_class_id in your table products

for ex
QuoteUPDATE `ac_products`
SET
`tax_class_id` = '1000';
where 1000 - your tax_class_id (take it from url of tax edit page)
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

Basara

Or update your product with CSV export/import http://www.abantecart.com/ecommerce-documentation/admin-user-manual/system/data
Please backup before just in case...

Awirges

Thanks guys. I went with Abolabo's suggestion. Worked like a charm.

Forum Rules Code of conduct
AbanteCart.com 2010 -