Project Home
Manuals
Contact Us
Download
Demo
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email
?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
AbanteCart v
1.3.4
is released.
Home
Help
Search
Calendar
Login
Register
AbanteCart Community
»
Shopping Cart Operations
»
Support
»
Bulk Tax Class Change
« previous
next »
Print
Pages: [
1
]
Author
Topic: Bulk Tax Class Change (Read 3670 times)
Awirges
Newbie
Posts: 6
Karma: +1/-0
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?
Logged
abolabo
core-developer
Administrator
Hero Member
Posts: 2048
Karma: +319/-13
web for all, all for web!
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)
Logged
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens
Basara
Administrator
Hero Member
Posts: 5807
Karma: +274/-2
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...
Logged
Please
rate your AbanteCart experience
or
leave your review
Awirges
Newbie
Posts: 6
Karma: +1/-0
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.
Logged
Print
Pages: [
1
]
« previous
next »
AbanteCart Community
»
Shopping Cart Operations
»
Support
»
Bulk Tax Class Change
Powered by SMFPacks Social Login Mod