Author Topic: Bulk Tax Class Change  (Read 3670 times)

Offline Awirges

  • Newbie
  • *
  • Posts: 6
  • Karma: +1/-0
    • View Profile
Bulk Tax Class Change
« 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?

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Bulk Tax Class Change
« Reply #1 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)
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5807
  • Karma: +274/-2
    • View Profile
Re: Bulk Tax Class Change
« Reply #2 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...

Offline Awirges

  • Newbie
  • *
  • Posts: 6
  • Karma: +1/-0
    • View Profile
Re: Bulk Tax Class Change
« Reply #3 on: June 26, 2015, 04:10:31 PM »
Thanks guys. I went with Abolabo's suggestion. Worked like a charm.

 

Powered by SMFPacks Social Login Mod