Is there a way to display prices both including and excluding sales tax?

I want to display prices on the detail page and in the cart, both including and excluding sales tax.

Is there a way to do that with a calculation without having to add another column in tblprice?

If I have to add another column to the database, is there an easy way to fill it with the calculated values from another column?

I seem to recall you have tax rules based on country and region, so getting that all figured out might be a pain. It is probably going to take some custom coding, but I could certainly help in a 1 hour support session.

I'm sure you are already able to show the price without tax. So showing the tax price is the part you need help with... I'd probably end up writing a function on the page that takes the price and spits out the price with tax. It will just be a bunch of if statements and simple math, but would have to be done by hand.

Yes, that would be great. When can we set that up? Today?

I can probably do it Wednesday. I'm traveling today. Give me a call at the office number at the bottom of every webassist page on Wednesday at 11am PST and I can help.

Sounds great. Thanks.

This looks over-complicated to me. Why not just do it all with php? Then you wouldn't need ajax.

I can also help you getting this working though. Maybe you have a good reason to need to use ajax and javascript that I don't realize.

You can convert a string to a number by:
1) removing any currency symbols
2) removing commas and using dot syntax for decimals
3) using parseFloat() on the resulting string

Hi Ray,

I ran into one more problem.

The code worked based on location, but when I switched to another language, the prices disappeared completely.

When I comment out this code, it works for all languages. When I don't, it works only for English.

The problem is the other languages still need to swap comma for dot.

/*if (languageid != 2) {
			 x = x.replace(".", ",");
		 } */
		if (languageid != 2) {
			 y = y.replace(".", ",");
		 }

I wonder if y is displayed correctly because it is not based on a calculation, and x isn't because it is a calculated value.

I also commented out this

/*if (mylocation3 == "germany" || mylocation1 == "europe") document.getElementsByClassName("itempriceincl").innerHTML = x;	*/

And added it to this line. It didn't have an affect the problem described above.

if (mylocation3 == "germany" || mylocation1 == "europe") {
			 $('.itempriceincl').html('(' +currencysymbol+' '+x+' '+mwstincl+ ')');
		 }

By the way, I am not getting email notifications to this thread even though it is checked. That"s why I saw a few updates too late.

I went over my email quota today accidentally. It will start working again in a few hours.

Thanks, no rush in regards to the emails.