News:

AbanteCart v1.4.2 is released.

Main Menu

Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

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 -