spid3r19 Posted November 6, 2009 Posted November 6, 2009 i have about 10k products on my site... now i used EP to upload these... only problem is, tax status any way to change tax status on 10k products ion 1 go?? not a chance i wanna change the status to 10k products 1 by 1
burt Posted November 6, 2009 Posted November 6, 2009 Use phpmyadmin to update the whole lot in one go. UPDATE `products` SET `products_tax_class_id` = '0' OBVIOUSLY - backup your database first!
spid3r19 Posted December 7, 2009 Author Posted December 7, 2009 Use phpmyadmin to update the whole lot in one go. UPDATE `products` SET `products_tax_class_id` = '0' OBVIOUSLY - backup your database first! Cheers Burt... just wondering why i got a -1 rep for asking that question :S
jigga1234 Posted December 7, 2009 Posted December 7, 2009 rep returned dont know why you got the bad :(
♥geoffreywalton Posted December 7, 2009 Posted December 7, 2009 Cheers Burt... just wondering why i got a -1 rep for asking that question :S Maybe because you could use EP to set the tax class or because there are so many posts on how to do mass update already on the forum. The former I could agree with but the latter depends on knowing the right keywords to use in a google search using site:www.oscommerce.com/forums e.g. site:www.oscommerce.com/forums mass update Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
spid3r19 Posted December 8, 2009 Author Posted December 8, 2009 Maybe because you could use EP to set the tax class or because there are so many posts on how to do mass update already on the forum. The former I could agree with but the latter depends on knowing the right keywords to use in a google search using site:www.oscommerce.com/forums e.g. site:www.oscommerce.com/forums mass update i did set the tax class via EP, but for some reason...it hadn't set it properly...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.