Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sql query to make all items taxable?


Guest

Recommended Posts

Posted

Backup then try:

 

update products set products_tax_class_id = 1;

Your online success is Paramount.

Posted

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%

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...