How to display Retail inc VAT & Trade Ex VAT in my table?

[plugnplay]

Hi,

Please take a look at the following page from my test site,

http://trials.actinic.com/trials/trial32841/Soil.html

I wish to modify the list below the first product to...

1. Display the prices in the list as VAT inclusive (so as not to upset retail customers)

2. Display another column showing Trade Price Ex VAT when Trade customers login (so my trade customers will know what they are paying and not get confused by the retail price shown in the list)

eg.

Product----------------------Price-------------------Trade Price
Soil Grow HW 01 Litre---------£11.95 (Inc VAT)-------£3.95 (Ex VAT)
Soil Grow SW 01 Litre---------£11.95 (Inc VAT)-------£3.95 (Ex VAT)

Any help would be greatly appreciated, I think it should be possible with some PHP to adjust the retail prices, adding some variables for the trade price column and JAVA script to work out the trade prices server side, I may be totally wrong, I am only going off things i've read on the forum, putting two and two together, getting very lost now though.

Thanks

Al

[plugnplay]

Thanks to this post - http://community.actinic.com/showthread.php?t=22834
I have managed to display the retail prices inc vat.

Still stuck on the trade price column...

[cdicken]

The layout of the trade price is controlled by the ActinicPXML.pm perl script. It takes the product price in the actual HTML page, applies a transformation to it and then redisplays it. This is all possible because when customers are logged in, all the product pages are parsed by the online perl scripts.

The only thing I can suggest is to first of all hide retail prices from all your logged in customers, so that one price is just swapped in a straight swap for another price when customers log in. This helps keep your layout regular.

You could then have a user-definable field called 'RRP' which displays the retail price in a column in the table - but this column is hidden by <Actinic:NOTINB2B></Actinic:NOTINB2B> tags so it won't appear for retail customers.

[plugnplay]

Success...

Have achieved a desirable result, took a bit of figuring out though, a few penny's have dropped after reading all relevant posts I could find

Please have a look and let me know your comments, I'm sure other people will want to do this sort of thing so I'm hoping to post an explanation of how I did it soon

It's really only suitable for sites that use Customer Group discounts (or surcharges) that are of a fixed percentage generated via the marketing menu... Marketing -Discounts and Surcharges Settings -Customer Pricing Tab

http://trials.actinic.com/trials/trial32841/Soil.html

login: trade
pass: trade

Go back to the soil section after login to see the trade prices displayed in the table. The actual cart prices wont tally up as I use the prices tab to get the correct trade price for products- I just did it as a learning exercise and to demonstrate what I would like to acheive with the prices from the associated products prices tab.

Al