Magento – Rounding of vat (tax) for product prices and consider 3 or 4 decimal places

pricetaxvat

We enter our product prices into magento exc vat and display them inc vat.

To get a nice price displayed to the customer as 19.95 the exc vat (20%) price would need to be 16.625.

If we store the price in the database directly or use magento store manager importer we can import the product price to be 16.625 but within the admin of Magento the price gets rounded up to be 16.63 and then when the tax is worked out the total would be 19.956 which then gets rounded up to 19.96

Referencing this other question Round Price to 4 decimal places it seems to do the trick on the surface but it seems really dangerous as it could have a knock effect with other areas of the store, specifically the checkout and payment gateways. Has anyone else encountered this issue or can offer a suggestion?

Best Answer

Two possibilities:

I have made good experience with https://github.com/therouv/Magento-BetterPriceRounding which uses 4-digit rounding. No side effects so far as I know.
Use gross prices for your products instead of net prices. Almost all B2C shops I know do this.

Related Solutions

Magento – Magento automatically round up product price based on applied VAT

This is similar to the "5 Rappen Rounding" in Switzerland, where the total always is a multiple of 0.05.

There is an extension for it that you should be able to build upon: https://github.com/openstream/Magento5CentRounding - it rewrites the subtotal and grandtotal models and hooks into their collect() methods.

Magento – Make Tax/VAT number field required for orders more than x

You can achieve this with the following:

Copy app/design/frontend/base/default/template/checkout/onepage/billing.phtml and/or app/design/frontend/base/default/template/checkout/onepage/shipping.phtml to your template folder
add the check on the total value (subtotal, grand total,..) in the class attribute and change YOUR_TOTAL_AMOUNT to the total amount which you need as limit:

<?php echo $this->getQuote()->getGrandTotal() >= YOUR_TOTAL_AMOUNT ? "required" : ""; ?>

The code of your input-form should look like this now:

<input type="text" 
 id="billing:vat_id"
 name="billing[vat_id]" 
 value="<?php echo $this->escapeHtml($this->getAddress()->getVatId()) ?>" 
 title="<?php echo $this->__('VAT Number') ?>" 
 class="input-text <?php echo $this->helper('customer/address')->getAttributeValidationClass('vat_id') ?> <?php echo $this->getQuote()->getGrandTotal() >= YOUR_TOTAL_AMOUNT ? "required" : ""; ?>" />

I didn't test it, but I think it should work #yolo.

Best Answer

Related Solutions

Magento – Magento automatically round up product price based on applied VAT

Magento – Make Tax/VAT number field required for orders more than x

Related Topic