Author Topic: Products by price VAT issue  (Read 2967 times)

smartypants

  • Guest
Products by price VAT issue
« on: March 02, 2011, 03:44:14 am »
I added the VM Breadz and VM Cherry Picker modules to my shop, VM Breads is a breadcrumb and VM Cherry Picker queries Virtuemart for products by their attributes (the issue is not directly related to the modules).

When I query for low price (i.e. add "&low-price=%price" and "&high-price=%price"to the request), I get a correct product list.

The problem is that my shop show products including VAT. For example: I get "Products under 50$ in the breadcrumb" (because that's what I queried for) and a list products with prices slightly above 50$ (because of the VAT).

How can I solve this? I to query including the price.
Thanks

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3510
  • VirtueMart Version: 3.8.9
Re: Products by price VAT issue
« Reply #1 on: March 02, 2011, 09:30:06 am »
you will probably have to go back to the developers as the VM does not store the VAT inclusive price.

I guess that the developers of the module have not considered this in their query.
Regards
A

Joomla 3.9.27
php 7.4

smartypants

  • Guest
Re: Products by price VAT issue
« Reply #2 on: March 28, 2011, 14:42:12 pm »
I talked to them, we simply hardcoded a query to the TAX table into the queries file.

james007007hun

  • Beginner
  • *
  • Posts: 3
Re: Products by price VAT issue
« Reply #3 on: January 16, 2012, 02:36:45 am »
please insert modified code

Dezign

  • Beginner
  • *
  • Posts: 11
Re: Products by price VAT issue
« Reply #4 on: January 23, 2012, 19:22:36 pm »
I talked to them, we simply hardcoded a query to the TAX table into the queries file.

Do you have the code for us? Have same problem with my shop...

lipes

  • Full Member
  • ***
  • Posts: 720
Re: Products by price VAT issue
« Reply #5 on: March 02, 2012, 04:37:44 am »
Vote here to include Product prices WITH VAT in the Administration Product Area.. in new VM2
http://forum.virtuemart.net/index.php?topic=98944.msg326505#new
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25