special Prices

[Surfcornwall]

Does anyone have anything that can generate from the retail price and put in beside it a discounted price next to it globally?

[jont]

The price you have in the price field will be the amount passed through to the cart so be careful about what you are trying to achieve

[Surfcornwall]

Hi thanks .. mm maybe the only way is the hard way .. will have to go through all prices

[jont]

You could try exporting the file into Excel, applying the discount formula and also concatenating the old price into the product description field if you have lots of products... that would give you the new discounted price as the buy price and show the old "was" price above in the description.

[Surfcornwall]

I need to take off 30% on all products and show the old price as you say but not sure of the formula I would need to use

[jont]

The equations for the cells would be:

to work out the new price : old price in cell A1 and the percentage reduction (30) in A2

=A1-(A1*(A2/100))

To concatenate the old price into the product description use:

=concatenate(B1," £",(A1*B3))

where B1 is the product description cell, A1 is the ex VAT price and B3 is the value of VAT (eg 1.175). The " £" adds the currency in front of the price

Often best to use named calls for the fixed "variables" eg Discount and VAT

Not tested so take a back up first

HTH