Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

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

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