News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Display pricing table by quantity

Started by rayge, June 19, 2013, 21:58:23 PM

Previous topic - Next topic

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

#16
Thank you, This works great!

WebStuff

#17
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
$this->product->prices['DBTax']
Misc Tax
$this->product->prices['Tax']
VAT Tax
$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
$this->product->prices['DATax']

So to get my VAT rate I would use :
$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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

WebStuff

Quote from: Milbo on July 29, 2014, 15:33:54 PM
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


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?
Он-лайн магазин за фототапети http://mishelfoster.com

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

servlet

Just make VM commercial extension. It will be better...
Он-лайн магазин за фототапети http://mishelfoster.com