Try the Demo

Magento Forum

   
Tier Prices excluding VAT
 
dlw
Jr. Member
 
Total Posts:  27
Joined:  2007-09-03
 

I have a site I’m working on where the client wants the price to update when a tier quantity is reached. An example product can be seen here : http://www.vubasupplies.co.uk/paints-coatings/floor/industrial-floor-paint.html

I have some jquery on that page which sends the qty and product id to the script below

require 'app/Mage.php';
Mage::app();

if(isset(
$_POST['qty']) && !empty($_POST['qty'])){
    
    $product_id 
$_POST['pid'];
    
$my_qty $_POST['qty'];
    
$my_price 0;
    
    
$_product Mage::getModel('catalog/product')->load($product_id);
   
    
$_tierPrices $_product->tier_price;
    
$_tierPrices array_reverse($_tierPrices);

    
print_r($_tierPrices );

    
$i=0;
    foreach(
$_tierPrices as $_tier){    
        
        
        
if($my_qty >= $_tier['price_qty']){
            $my_price   
$_tier['website_price']
            echo(
$my_price." ");            
            break;
        
}
        $i
++;
    
}   


    
//$calculated_price = $my_price*$my_qty;
    //$calculated_price = $my_price;
    
    //echo number_format($calculated_price,2,'.',',');
}

The problem is the prices come back including VAT. No mater what I try I can’t get the prices excluding VAT. The site tax settings are setup not to show VAT on product pages.

Any ideas?

TIA,
Darren

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top