I have added product price tax inclusive in the price column and applied a tax class says 5% tax. On the frontend, catalog price should not increase in the cart, but when I'm adding the product into cart, row total, subtotal and grand total coming inclusive of 5%.

For eg. Catalog price added with product INR 654 (incl. tax) Tax 5% - 32.70 INR Row total - 686.70 INR Subtotal - 686.70 INR Grand Total - 686.70 INR

But Row total, subtotal, grand total should be 654 INR.

Here is my store's tax setting https://prnt.sc/pzd0j8

How to get this in Magento?

1 Answer 1


I've repeated your tax config on Magento 1.9.0 and tax is calculated as you expect (product card price = row total = subtotal = grand total = 654).

Do you use default theme or changed one? Can you check these values direct in database?

  • I'm setting custom price in cart of product after add to cart event as "$item->setCustomPrice()". Commented Nov 21, 2019 at 10:17
  • Did you check price_incl_tax in sales_flat_quote_item table? Commented Nov 22, 2019 at 4:35
  • price_incl_tax is the same as row_total_incl_tax. When I add custom price (through AdminPanel) it is also the same. Commented Nov 22, 2019 at 6:37
  • I see that custom_price is amount without tax, so probably you should setCustomPrice(622,86) to get what you want. Commented Nov 22, 2019 at 6:44
  • To get price_excl_tax for your amount you can use calcTaxAmount() from Mage_Tax_Model_Calculation Commented Nov 22, 2019 at 6:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.