extended search problem with prices

Posted on 19/04/2011 17:12:14

hi DW.

I have a problem. I have used the extended search module. But it seems that I can only sort on prices without VAT on the frontend.

I have used the variable <-- withVat --> but the searchstring returns the result withOut VAT. so all the prices are wrong in the result.

you can see an example by going to Sebastians ecom shop, and go to the checkout and set country to Denmark, then danish tax are activated. then back to the search 'engine', and then search for price range 0 - 20 , the result is products with 25 euro.

So is there a way to force the search to sort on with tax ?

any help much appreciated.

Replies

Posted on 20/04/2011 06:22:30

Hi.
1. Try please set next Global settings key to "/Globalsettings/Ecom/Price/PricesInDbIncludesVAT" to“true”
2. Provide please URL of Sebastians ecom shop.

Posted on 20/04/2011 09:12:55

Hi Yury,

the URL is : http://ecommerce.dynamicweb.dk/en-GB/Webshop.aspx

Im not sure where to set the global..?

Posted on 20/04/2011 09:42:12

Thanks for the URL, I will look at the site.
To set GS key go please to

Management center -> eCommerce -> Advanced configuration -> Prices -> Settings. Prices in DB including sales tax

BR.
Yury

Posted on 20/04/2011 09:54:28

Hi Yury,

It is still returning the result incl VAT.

It seems that the searchstring is correct, but when it searches. it deduct the VAT and searches in the DB, then returning the price ex VAT and then multiply with VAT.

Like this:

frontend: 1000 DKK

search string: 500-1000 DKK incl. VAT

actual search 500-1000 ex VAT.

result frontend 1250 DKK.

Posted on 21/04/2011 09:58:04

Hello,

That's a template thing.

Product prices are being indexed "as is" (without any additions) but the template tag "Ecom:Product.Price" automatically includes VAT.

If you want to display a product price without VAT then you can use "PriceWithoutVAT" price tag extension:

1. Go to module settings and open your product list template for editing.

2. Find the tag "Ecom:Product.Price" and replace it with "Ecom:Product.Price.PriceWithoutVAT" (notice that this is just a number and doesn't include a currency symbol).

More info on "Price" tag extensions: http://templates.dynamicweb-cms.com/eCommerce/Dynamicweb-eCommerce-template-tags/Extentions/Price-tag-extensions.aspx

-- Pavel

You must be logged in to post in the forum

Developer forum

extended search problem with prices

Replies