Guest Posted December 19, 2005 Posted December 19, 2005 i'm redoing an osc-based site that never selected the "taxable goods" pulldown menu for their entertainment-related items i just implimented this fix: http://www.oscommerce.com/forums/index.php?sho...hl=tax++default now how can i go through the entire database and make all items that currently have the --none-- and change it to taxable?
♥yesudo Posted December 19, 2005 Posted December 19, 2005 Backup then try: update products set products_tax_class_id = 1; Your online success is Paramount.
Guest Posted December 19, 2005 Posted December 19, 2005 the query executed successfully, but i just did a test and it didn't charge me any tax :( sql results: Affected rows: 223 (Query took 0.0197 sec the total products in store (active) are 219 (a few offline) i suppose i have the tax settings incorrect for this shop. can anyone tell me if this is correct? Tax Zones -> Wisconsin Tax Classes -> Taxable Goods Tax Rates -> Priority : 1 -> Tax Class -> Taxable Goods -> Zone -> Wisconsin -> Tax Rate : 5%
Recommended Posts
Archived
This topic is now archived and is closed to further replies.