Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do i add bulk changes to the items?


kram

Recommended Posts

Posted

I have an oscommerce store up and running and i want to add tax (vat) to all my products in the datbase.As i stands i'll have to edit each product and switch on the "taxable goods" tab which could take an age as i have about 500 products in the system. Is there a way to make bulk changes i.e. add tax to every product with one change?

 

Thanks in advance...

Posted

you can also use mysql or phpmyadmin and edit the products table, selecting your products enmass and updating products_tax_class_id = 1

Posted

UPDATE `products` SET products_tax_class = 'xxx'

where xxx is the ID of the needed tax class.

 

Rgrds

Matthijs

"Politics is the art of preventing people from taking part in affairs which properly concern them"

Archived

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

×
×
  • Create New...