Display pricing table by quantity

[cheide]

to sort lowest to highest ad this line:

ORDER BY price_quantity_start, price_quantity_end;

right after

virtuemart_shoppergroup_id IN (".$virtuemart_shoppergroup_id_str.")

[dmuntean]

Thank you, This works great!

[WebStuff]

For those trying to find the VAT rate(and other taxes) it should be available in these arrays for the productdetails page. I've put my Vat tax array in as is to show which variable it would be.:

Discount Before Tax

Code Select Expand

$this->product->prices['DBTax']
Misc Tax

Code Select Expand

$this->product->prices['Tax']
VAT Tax

Code Select Expand

$this->product->prices['VatTax'] => Array ( [1] => Array ( [0] => VAT [1] => 20.0000 [2] => +% [3] => 1 [4] => 52 [5] => [6] => 1 [7] => 1 ) )
Discount After Tax

Code Select Expand

$this->product->prices['DATax']

So to get my VAT rate I would use :

Code Select Expand

$vat_rate = $this->product->prices['VatTax'][1][1];
which gives the value 20.0000;
The rest is just simple maths.

If you want this on the category pages find where the products are stepped through and use $product->prices array instead.
Hope this helps.

[Milbo]

Thank you Mirrosandglass,

In vm3, all prices are always already loaded. I am sure you will have fun with it.

[WebStuff]

In vm3, all prices are always already loaded. I am sure you will have fun with it.

Thanks Milbo,
I'm already at a good stage playing with the vm3 svn on Joomla 3.3.3.    :-)

[lanthan]

including tax calculation

http://forum.virtuemart.net/index.php?topic=114040.msg427903#msg427903

[lamcpp]

Ok, please tell me how do each of these price link after pressing the product is added to the cart with the appropriate price

[servlet]

Ok. Is it possible to display table in vm 3 now?

[jenkinhill]

I believe it is available in the member version: http://extensions.virtuemart.net/support/virtuemart-supporter-membership-detail

[servlet]

Just make VM commercial extension. It will be better...