1

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?

3

Two possibilities:

  1. 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.

  2. Use gross prices for your products instead of net prices. Almost all B2C shops I know do this.

  • Thank you for the reply - we're going to look into gross pricing instead of net pricing. We have lots of B2B customers so the vat would have to be removed but the majority are B2C and having the vanity price is preferable – Gavin Jan 19 '16 at 15:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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