Magento – Get bundle product price including tax

bundled-productmagento-1.7price

I am trying to get product prices both inclusive and exclusive tax in custom export script.

To get product price with inclusive tax I used this code.

Mage::helper('tax')->getPrice($_product, $_product->getPrice());

This working fine for simple product.

But For Bundle product how we can get price inclusive tax.

Bundle product price type is dynamic.

And I have used this code to retrieve bundle product price.

$bundlePriceModel = Mage::getModel('bundle/product_price');
 $selectionCollection = $_product->getTypeInstance(true)->getSelectionsCollection(
                      $_product->getTypeInstance(true)->getOptionsIds($_product), $_product
                  );

                  $itemPrice = 0;
                 foreach($selectionCollection as $_option) {                             
                            $itemPrice += $bundlePriceModel->getSelectionFinalTotalPrice($_product, $_option,1, $_option->getData('selection_qty'), true, true );
                            }

Best Answer

The price of a bundled product is calculated in the class Mage_Bundle_Model_Product_Price, in the function getFinalPrice() to be exact. When you look into this function you’ll notice two lines in particular:

$finalPrice = $product->getData('final_price');
$finalPrice = $this->_applyOptionsPrice($product, $qty, $finalPrice);
$finalPrice += $this->getTotalBundleItemsPrice($product, $qty);

And for tax

You can get a helper-instance in any file using:

Mage::helper('tax')

Your full code is:

$_product = Mage::getModel('catalog/product')->load($productId);
$_priceIncludingTax = Mage::helper('tax')
    ->getPrice($_product, $_product->getFinalPrice());

EDIT

or you can also use direct function to display price with tax

Mage::getModel('bundle/product_price');
public function getTotalPrices($product, $which = null, $includeTax = null, $takeTierPrice = true)

See for calculation

hope this will sure help you.

Related Solutions

Magento – Retrieving product’s price including tax

I believe the issue here is that there is no sales quote address available. In order to calculate sales tax (including GST) you need a shipping address available. (It can also be set to billing regions - see System > Configuration > Tax).

Debug:

First, try starting a cart (Sales Quote) and proceeding to checkout (Onepage) and move through past the shipping method selection. In the review screen, if configured properly, it should display tax totals.

After this, refresh your script and getFinalPrice should display the correct price.

What's happening?

The lack of a shipping address means no tax rates are being calculated when you call your standalone script. That means each customer would have to either give you their eventual shipping destination upon arrival at your site (yeah, right) or proceed beyond the shipment method selection in checkout -> at that point in the conversion funnel they've probably already made the decision to purchase, right?

So, to circumvent this restriction, consider using a plugin that will default quote values to a preselected shipping address within the locale that you're trying to display tax-inclusive rates for.

One such extension used to exist on Magento Connect but has since been de-listed. I have preserved it on Github:

https://github.com/philwinkle/Mage_Autoquote

Get Stock Values for Bundled Product in Product Grid

Here is an example how to access the is salable state or the stock quantity of all associated child products.
this first method is simply to fetch the child product ids from the bundled product.

function getBundledProductChildIds(Mage_Catalog_Model_Product $product)
{
    $childrenIds = [];
    if ($product->getTypeId() == Mage_Catalog_Model_Product_Type::TYPE_BUNDLE) {
        $childrenIds = array_reduce(
            $product->getTypeInstance(true)->getChildrenIds($product->getId()),
            function (array $reduce, $value) {
                return array_merge($reduce, $value);
            }, []);
    }
    return $childrenIds;
}

The next example gives you the in stock or out of stock for each child product.

$bundledProduct = Mage::getModel('catalog/product')->load(BUNDLED_PRODUCT_ID);

// Just get the is salable state of the child products
$childProducts = Mage::getResourceModel('catalog/product_collection')
    ->addIdFilter(getBundledProductChildIds($bundledProduct));
foreach ($childProducts as $child) {
    printf("%s -> %s stock\n", $child->getId(), ($child->getIsSalable() ? 'in' : 'out of'));
}

The final example gives you the stock qty of each child product.
Note that the key difference is that the require_stock_items flag is set on the collection before it is loaded.

$bundledProduct = Mage::getModel('catalog/product')->load(BUNDLED_PRODUCT_ID);    

// Get the inventory qty of each child item
$childProducts = Mage::getResourceModel('catalog/product_collection')
    ->addIdFilter(getBundledProductChildIds($bundledProduct))
    ->setFlag('require_stock_items', true);
foreach ($childProducts as $child) {
    printf("%s -> stock qty: %d\n", $child->getId(), $child->getStockItem()->getQty());
}

printf("Total stock item qty sum: %d\n", array_reduce(
    $childProducts->getItems(),
    function ($sum, $child) {
        return $sum + $child->getStockItem()->getQty();
    }, 0));

printf("Highest stock qty: %d\n", array_reduce(
    $childProducts->getItems(),
    function ($max, $child) {
        return max($max, $child->getStockItem()->getQty();
    }, 0));

That should hopefully enable you to get what you need.

Best Answer

Related Solutions

Magento – Retrieving product’s price including tax

Get Stock Values for Bundled Product in Product Grid

Related Topic