Mass Tax Change

[Romerz]

Ive copied a load of products over from an old site to a current site. The old ones however have a different tax treatment (in the details tab). Is there anyway to change everything in the site at once to a different tax (the 3rd down in the list on mine) rather than me going through every product, seeing an error, clicking ok, and going to the 3rd option in the drop down menu?

Thanks in advance

[TraceyG]

Hi,

You could run a SQL query on the database to change them all in one go.

- close Actinic
- browse to your site folder and locate 'ActinicCatalog.mdb' (take a backup)
- open the database with MS Access 2000 (you can open it with a later version but do not save it in the later format)
- go to 'Insert | Query'
- select 'Design View' and click 'OK'
- click on the 'View' menu and select 'SQL View'
- replace the contents with:

UPDATE Product SET Product.sTax1OpaqueData = "301=1750.00=0=";

- click on the 'Query' menu and select 'Run'
- this will update all your products to be set with 'VAT (Normal)'.

If you have any problems with this, close Actinic and copy your backup back into the site folder.