vat prices

[emaginedtp]

ive been working through a shopping site and entering prices inc VAT.

is it possible to change something so that i dont have to select excluding/including VAT from the options, as checking 1 of these changes the original correct price.

i dont want to go through the site changing prices as the are 1000's of products

any help?

[emaginedtp]

anyone? dont fancy changing over 1000 product prices here

[emaginedtp]

nobody can help me then?

i want to dissable actinic from adding VAT or exculding VAT from my prices.

the prices ive enterd are including vat, so obviously added vat onto the vat inclusive price up's the price.

[andyh]

Hello Steven,

Ok, if I had to do this, I’d look at using access and run a query against the database or export the data from actinic into excel and apply a formula to the price column, and then import the data back to actinic.

If you have access installed, open the database (first make a back up) and run the following query :-

Select price , round(price / 1.175,0) as exVat from product

You’ll see 2 columns are returned, the price that is currently stored in the database (Price) and a price with 17.5% removed from it (exVat). Both columns are in pence.

If you are happy the exVat column looks ok run the following update query

update product set price = round( price / 1.175,0)

Things to note.

You may get some rounding problems so you’ll need to look into these.

The update query will update ALL products so if you have any products that are zero vat rated, or any products that are stored correctly you’ll need to exclude these from your query.

Hope this helps

Andy