Totally Zenned
- Join Date:
- Feb 2007
- Posts:
- 1,724
- Plugin Contributions:
- 0
Easy Populate 1.2.5.4 support
kelvyn:
For example, in the UK VAT is 17.5%, so you make a new column in Excel (or OpenOffice calc) and in B2 you put =A1*1.1.75 (assuming your prices are in column A) and copy down the column.
If you want to copy back the VAT-inclusive prices, just select them all, then paste-special, and you want just values (otherwise you'll have a circular reference)
Thats alot of work to do and very complex for some with limited computer skils.... im trying to give work away to other members of staff and releve my time to do more important things.
I need it so my member of staff (prob a temp) can be given a CSV file which has the product model number, name, prices (inc vat) and qty and all they have to do is copy over the prices given to use via our suppliers (in an excell file) or go through them and change the price to suit (when we get prices changes emailed to us as text files ie product AA bats was £1.99 now £1.55 inc vat)
this VAT export would be great as well if it got the vat price from the default VAT code on the site as you all know the UK vat is going to change again soon.