VAT Inclusive Search Results

[James M SellerDeck]

Hi Alistair

Im currently looking into this for you, as I get VAT exclusive prices on the results page even when I displaying inclusive on the product pages.

Ill get in touch with the development team to see if this has changed.
________

[wfl]

Hi James

That is exactly what I get in 8.5 but in 7.5 we got VAT inclusive in both.

Your colleague told me this was a bug in V8 but when I look around I see several prominent sites where both catalog and search results show VAT inclusive.

[wfl]

Has this been fixed in 8.5.2?

[cdicken]

No - but there is a change to the Perl that you can use to show prices in the checkout including VAT.

In SearchScript.pl, look for the following comment:

# The price formatting is a little more complex

Underneath it, you should see the following:

		$sTemp = "";
		if ($$::g_pSearchSetup{SEARCH_SHOW_PRICE} &&	# only display the price if it is on and prices are displayed
			 $$::g_pSetupBlob{PRICES_DISPLAYED} &&
			 $Product{PRICE} != 0)
			{
			($status, $sError, $sTemp) = ActinicOrder::FormatPrice($Product{PRICE}, $::TRUE, $::g_pCatalogBlob);
			if ($status != $::SUCCESS)
				{
				ACTINIC::CleanupIndex($rFile);
				return($status, $sError);
				}
			}
		$ACTINIC::B2B->SetXML('S_PRICE', $sTemp);

Replace all this with the following:

		$sTemp = "";
		# if ($$::g_pSearchSetup{SEARCH_SHOW_PRICE} &&	# only display the price if it is on and prices are displayed
		# 	 $$::g_pSetupBlob{PRICES_DISPLAYED} &&
		# 	 $Product{PRICE} != 0)
		# 	{
		# 	($status, $sError, $sTemp) = ActinicOrder::FormatPrice($Product{PRICE}, $::TRUE, $::g_pCatalogBlob);
		# 	if ($status != $::SUCCESS)
		# 		{
		# 		ACTINIC::CleanupIndex($rFile);
		# 		return($status, $sError);
		# 		}
		# 	}
		# $ACTINIC::B2B->SetXML('S_PRICE', $sTemp);

		if ($$::g_pSearchSetup{SEARCH_SHOW_PRICE} &&
			$$::g_pSetupBlob{PRICES_DISPLAYED} &&
			$Product{PRICE} != 0)
			{
			($status, $sError, $sTemp) = ActinicOrder::FormatPrice($Product{PRICE}, $::TRUE, $::g_pCatalogBlob);
			if ($status != $::SUCCESS)
				{
				ACTINIC::CleanupIndex($rFile);
				return($status, $sError);
				}
			if ($Product{PRICE})
				{
				my $sTemp1;
				my $nTaxPrice = ActinicOrder::RoundTax($Product{PRICE} * 1.175, $ActinicOrder::SCIENTIFIC_NORMAL);
				($status, $sError, $sTemp1) = ActinicOrder::FormatPrice($nTaxPrice, $::TRUE, $::g_pCatalogBlob);
				if ($status == $::SUCCESS)
                       			{
                        		$sTemp .= " Excluding VAT (" . $sTemp1 . " Including VAT)";
					}
				}
			}
        	$ACTINIC::B2B->SetXML('S_PRICE', $sTemp);

That should do it.

[dave_finlayson]

Chris,

Out of interest, why does it work on some sites and not others?

[wfl]

Sorry Chris but that doesn't work.

I think I saw / tried it before but it simply multiplies the price by 1.175 which not a lot of use if one also sells books that are zero rated.

Now if someone (I am no coder) can get the script to look at the VAT type / rate on the product then that would be good.

The really frustrating bit is that I set it up and did the 45 minute upload before I realised. Now I am doing another 45 minute upload to get rid.

[zmagyar]

There was a bug in v8 development resulting that there is no UI to control if the prices on the search result page are inclusive or exclusive of tax. But it still depends on a DB field which can be edited in Access. If you open the table Setup2 in ActinicCatalog.mdb and set bDisplayTaxExclusivePrice to false and bDisplayTaxInclusivePrice to true then the search result prices will be tax inclusive. The same can be achieved by executing the following SQL script in Access

UPDATE Setup2 SET Setup2.bDisplayTaxExclusivePrice = 0, 
Setup2.bDisplayTaxInclusivePrice = -1;

Reversing the fields will result exclusive prices on the page. The SQL script for this setting is

UPDATE Setup2 SET Setup2.bDisplayTaxExclusivePrice = -1, 
Setup2.bDisplayTaxInclusivePrice = 0;

I hope this helps.

[wfl]

At last!

Thanks Zoltan that was the problem - it works now.

Has this suddenly been discovered or is there a shortcoming in Actinic internal documentation that meant that Chris didn't know about it?

It is very frustrating that it has taken the better part of 6 months to get an answer to what ultimately seems to be a very simple problem. We raised the problem in April and it was an admitted as a bug in May. Only when I prompted again last week has the answer been forthcoming.

No doubt this will be resolved one day in 8.5.2.

[pisaia]

Site Search Results

Hello,

I have actioned the above changes on my Version 9 site, as my site search results were only displaying Exc VAT prices.

My results are now displaying like this:


250g Box of Truffles - £11.02 Excluding VAT (£12.95 Including VAT)


Ideally I would like my results to display like this:


250g Box of Truffles - £12.95 Including VAT (£11.02 Excluding VAT)

I have looked at the code and have no idea on what needs changing to get it to look like this, can anyone help me please?

Kind Regards

Paul

[TraceyG]

Hi Paul,

I asked our development team about this as I couldn't get it to work for the format you want and I'm told that you can show tax inclusive prices in v9 by going to 'Settings | Site Options | General tab' and changing 'Use Tax Inclusive Prices for Online Search' to 'True', but this will only show the price in brackets as '(£12.95)'. Apparently, there is no way at present to have the format you want - I will add it to the wishlist though.

[TraceyG]

Hi Paul,

Sorry, ignore what I've said above, I've now been given the amendment to the code to get it into the format you want:

- replace the same bit of code in SearchScript.pl mentioned by Chris with the following:

                $sTemp = "";
		# if ($$::g_pSearchSetup{SEARCH_SHOW_PRICE} &&	# only display the price if it is on and prices are displayed
		# 	 $$::g_pSetupBlob{PRICES_DISPLAYED} &&
		# 	 $Product{PRICE} != 0)
		# 	{
		# 	($status, $sError, $sTemp) = ActinicOrder::FormatPrice($Product{PRICE}, $::TRUE, $::g_pCatalogBlob);
		# 	if ($status != $::SUCCESS)
		# 		{
		# 		ACTINIC::CleanupIndex($rFile);
		# 		return($status, $sError);
		# 		}
		# 	}
		# $ACTINIC::B2B->SetXML('S_PRICE', $sTemp);

		if ($$::g_pSearchSetup{SEARCH_SHOW_PRICE} &&
			$$::g_pSetupBlob{PRICES_DISPLAYED} &&
			$Product{PRICE} != 0)
			{
			($status, $sError, $sTemp) = ActinicOrder::FormatPrice($Product{PRICE}* 1.175, $::TRUE, $::g_pCatalogBlob);
			if ($status != $::SUCCESS)
				{
				ACTINIC::CleanupIndex($rFile);
				return($status, $sError);
				}
			if ($Product{PRICE})
				{
				my $sTemp1;
				my $nTaxPrice = ActinicOrder::RoundTax($Product{PRICE}, $ActinicOrder::SCIENTIFIC_NORMAL);
				($status, $sError, $sTemp1) = ActinicOrder::FormatPrice($nTaxPrice, $::TRUE, $::g_pCatalogBlob);
				if ($status == $::SUCCESS)
                       			{
                        		$sTemp .= " Including VAT (" . $sTemp1 . " Excluding VAT)";
					}
				}
			}
        	$ACTINIC::B2B->SetXML('S_PRICE', $sTemp);