AbanteCart Community

Shopping Cart Operations => Support => Topic started by: Awirges on June 25, 2015, 03:11:18 PM

Title: Bulk Tax Class Change
Post by: Awirges on June 25, 2015, 03:11:18 PM

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?

Title: Re: Bulk Tax Class Change
Post by: abolabo on June 25, 2015, 06:09:16 PM

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

for ex

Quote

UPDATE `ac_products`
SET
`tax_class_id` = '1000';

where 1000 - your tax_class_id (take it from url of tax edit page)

Title: Re: Bulk Tax Class Change
Post by: Basara on June 26, 2015, 03:02:57 AM

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

Title: Re: Bulk Tax Class Change
Post by: Awirges on June 26, 2015, 04:10:31 PM

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